Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features * Discover T-SQL functionalities and services that help you interact with relational databases * Understand the roles, tasks and responsibilities of a T-SQL developer * Explore solutions for carrying out database querying tasks, database administration, and troubleshooting Book Description Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language that is used with Microsoft SQL Server and Azure SQL Database. This book will be a useful guide to learning the art of writing efficient T-SQL code in modern SQL Server versions, as well as the Azure SQL Database. The book will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting. In the later chapters, you will learn how to identify various T-SQL patterns and anti-patterns. This will help you analyze execution plans to gain insights into current performance, and determine whether or not a query is scalable. You will also learn to build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will study how to leverage the built-in tools of SQL Server to shorten the time taken to address query performance and scalability issues. In the concluding chapters, the book will guide you through implementing various features, such as Extended Events, Query Store, and Query Tuning Assistant using hands-on examples. By the end of this book, you will have the skills to determine query performance bottlenecks, avoid pitfalls, and discover the anti-patterns in use. Foreword by Conor Cunningham, Partner Architect – SQL Server and Azure SQL – Microsoft What you will learn * Use Query Store to understand and easily change query performance * Recognize and eliminate bottlenecks that lead to slow performance * Deploy quick fixes and long-term solutions to improve query performance * Implement best practices to minimize performance risk using T-SQL * Achieve optimal performance by ensuring careful query and index design * Use the latest performance optimization features in SQL Server 2017 and SQL Server 2019 * Protect query performance during upgrades to newer versions of SQL Server Who this book is for This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues, through the help of practical examples. Previous knowledge of T-SQL querying is not required to get started on this book.

Plan and build useful machine learning systems for financial services, with full working Python code Key Features * Build machine learning systems that will be useful across the financial services industry * Discover how machine learning can solve finance industry challenges * Gain the machine learning insights and skills fintech companies value most Book Description Machine learning skills are essential for anybody working in financial data analysis. Machine Learning for Finance shows you how to build machine learning models for use in financial services organizations. It shows you how to work with all the key machine learning models, from simple regression to advanced neural networks. You will see how to use machine learning to automate manual tasks, identify and address systemic bias, and find new insights and patterns hidden in available data. Machine Learning for Finance encourages and equips you to find new ways to use data to serve an organization’s business goals. Broad in scope yet deeply practical in approach, Machine Learning for Finance will help you to apply machine learning in all parts of a financial organization’s infrastructure. If you work or plan to work in fintech, and want to gain one of the most valuable skills in the sector today, this book is for you. What you will learn * Practical machine learning for the finance sector * Build machine learning systems that support the goals of financial organizations * Think creatively about problems and how machine learning can solve them * Identify and reduce sources of bias from machine learning models * Apply machine learning to structured data, natural language, photographs, and written text related to finance * Use machine learning to detect fraud, forecast financial trends, analyze customer sentiments, and more * Implement heuristic baselines, time series, generative models, and reinforcement learning in Python, scikit-learn, Keras, and TensorFlow Who this book is for Machine Learning for Finance is for financial professionals who want to develop and apply machine learning skills, and for students entering the field. You should be comfortable with Python and the basic data science stack, such as NumPy, pandas, and Matplotlib, to get the most out of this book.

If you are an experienced JavaScript developer who wants to improve the design of his or her applications, or find yourself in a situation to implement an application in an unfamiliar domain, this book is for you. Prior knowledge of JavaScript is required and prior experience with Node.js will also be helpful.

If you want to learn how to develop effective machine learning solutions to your business problems in R, this book is for you. It would be helpful to have a bit of familiarity with basic object-oriented programming concepts, but no prior experience is required.

This book is targeted at R programmers who want to learn the graphing capabilities of R. This book will presume that you have working knowledge of R.

This book is a practical tutorial to get you confident and comfortable working with the Microsoft AJAX suite. Packed with step-by-step examples and detailed explanations of how the examples work, this book is the ideal first step into the exciting world of AJAX in ASP.NET This book has been written for ASP.NET developers entering the world of the ASP.NET AJAX Framework, and for existing ASP.NET AJAX developers looking for a more detailed tutorial on the client-side of the framework: the Microsoft AJAX Library.

This book is a mini tutorial full of code examples and strategies to give you plenty of options when building your own applications with MongoDB.This book is ideal for people who want to develop applications on the Node.js stack quickly and efficiently. Prior knowledge of the stack is not essential as the book briefly covers the installation of the core components and builds all aspects of the example application. The focus of the book is on what Mongoose adds to you applications, so experienced Node.js developers will also benefit.

This book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity.Microsoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.

This book is packed with the step by step tutorial and instructions in recipe format helping you setup test infrastructure and gradually advance your skills to plan, develop, and test your backbone applications.If you are a JavaScript developer looking for recipes to create and implement test support for your backbone application, then this book is ideal for you.

This book is intended for IT professionals interested in installing and configuring Ephesoft Enterprise for their organization, but it is a valuable resource for anyone interested in learning about intelligent document capture.

This book is written for PHP developers who want to add custom features to Drupal. You will need to know the basics of PHP and MySQL programming, but no experience of programming Drupal is required, although you will be expected to be familiar with the basic operation of Drupal.

This book is for those who want to build sophisticated Java web applications quickly and easily. It assumes that the reader is reasonably comfortable with the Java programming language, but no knowledge of web technologies is needed. For experienced Servlet, JSP, or Struts developers, the book will show an alternative way that will allow them to raise their productivity to an incomparable level. With this book you will see that a contemporary component-based framework can be easy to learn and a pleasure to work with.

This book is the ideal introduction to theming with Drupal 5. If you want to create a striking new look for your Drupal website, this book is for you. Starting from the basics of theme setup and configuration, you will learn about the Drupal theming architecture and the PHPTemplate engine, and then move on to modifying existing themes and building new themes from scratch. Included is a complete guide to the various style sheets and themeable functions in Drupal 5, making this book a valuable resource even to experienced theme developers. It covers: Creating custom templates Basics of theming in pure PHP Modifying an existing PHPTemplate theme" a step-by-step guide Creating a new PHPTemplate theme" a step-by-step guide Working with forms The main requirements to make use of this book are knowledge of HTML, CSS, and a touch of creativity! Although this book aims to make Drupal theming accessible to designers, theming in Drupal 5 involves writing some PHP code, and a basic knowledge of PHP will be helpful.

This book is a practical tutorial with five detailed and carefully explained case studies to build new and effective mashup applications. If you feel confident with your PHP programming, familiar with the basics of HTML and CSS, unafraid of XML, and interested in mashing things up, this is the book for you! There are a lot of formats and protocols, web services and web APIs encountered in this book ” you do not need to know anything about them or about AJAX; you will find all you need in the book.

This is a practical, hands-on guide that assists you in setting up and efficiently managing ITSM.ServiceDesk Plus 8.x Essentials is for IT helpdesk managers, administrators, and staff, serving as a compendium for service management concepts useful for them.

Written as a step-by-step guide, Getting Started with Hazelcast will teach you all you need to know to make your application data scalable.This book is a great introduction for Java developers, software architects, or developers looking to enable scalable and agile data within their applications. You should have programming knowledge of Java and a general familiarity with concepts like data caching and clustering.

This book is hands-on. As you work through the small business/e-commerce enabled example web site, you will learn how to install, upgrade, configure, and use the various basic features of the e107 Content Management System. The book contains a number of screen shots to reinforce that each step that you perform is correct. This book is primarily for entrepreneurs, small office/home office, small businesses and non-profit agencies who would like to have interactive, business and/or e-commerce web sites at a low cost without sacrificing power or usability. No knowledge of PHP programming, Apache, or MySQL is required.

Anyone interested in securing their networks with IPCop ” from those new to networking and firewalls, to networking and IT Professionals with previous experience of IPCop. No knowledge of Linux or IPCop is required.

It will be a step-by-step tutorial that will discuss best practices. The book is structured in such a way that it can be read both from start to end or can dipped into. .Net developers using Visual Studio for programming will find this book useful. If you are developing your application with C#, you will find better ways to do things with Visual Studio. You should know basics of development with .Net Framework and need working knowledge on VIsual Studio

This book focuses on the real-world understanding of management concepts so as to maximize learning. It focuses on the various aspects of management covering the common pitfalls and practical insights. Although it explains management frameworks using an Indian context and scenarios, these management principles remain the same across all sectors and so people from other sectors will also benefit from this book. MNCs who want to effectively manage employees of their Indian branches, New Managers, Aspiring managers, and soon-to-be managers, All managers who wish to be more effective by better understanding the management frameworks and how they apply to the Indian IT and ITes sectors – IT Product Development, Services, Backend processing, and BPO, Management principles remain the same across all sectors and so people from other sectors will also benefit from this book

As part of Packt’s Beginner’s Guide series, each chapter covers an aspect of working with Inkscape, with plenty of screenshots and practical examples. This book is intended for beginning graphic and web designers who want to expand their graphic software expertise. General familiarity with a graphics program is recommended, but not required.