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.

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.

If you have just started your adventure with F#, then this book will help you take the right steps to become a successful F# coder. An intermediate knowledge of imperative programming concepts, and a basic understanding of the algorithms and data structures in .NET environments using the C# language and BCL (Base Class Library), would be helpful.

VMware vCloud Security provides the reader with in depth knowledge and practical exercises sufficient to implement a secured private cloud using VMware vCloud Director and vCloud Networking and Security.This book is primarily for technical professionals with system administration and security administration skills with significant VMware vCloud experience who want to learn about advanced concepts of vCloud security and compliance.

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 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.

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.

An easy-to-follow guide to reveal the new features of Java EE 7 and how to efficiently utilize them.Given the main objectives pursued, this book targets three groups of people with a knowledge of the Java language. They are:Beginners in the Java EE platform who would like to have an idea about the main specifications of Java EE 7.Developers who have experimented with previous versions of Java EE and who would like to explore the new features of Java EE 7.Building architects who want to learn how to put together the various Java EE 7 specifications for building robust and secure enterprise applications

This book is a step-by-step tutorial with a lot of screenshots that help to explain the concept better. This book will cover the building of a 3D game for Windows Phone using XNA. We won’t explain the C# programming language itself, nor object-oriented programming.We will however explain the aspects of game development thoroughly, so don’t worry if you have never written a 3D game. We will cover all the basics, included the much dreaded math. This is the right book for anyone, regardless of age and gender, if: You are interested in game development You want to start building games for Windows Phone You have some programming knowledge. In this book, we will first go over the technical topics, and end up building a 3D game for Windows Phone 7 together!

An easytouse book, containing 10 engaging projects that will help you learn how to build video games with the easy to use Scratch 2.0 environment. If you are a new, or current Scratch user and would like to improve your understanding of the new Scratch 2.0 interface, and learn how to make video games, this book is ideal for you. Each project is explained indepth from start to finish, so everyone can follow along, even if you don’t have much previous experience with the software. If you want to become a video game designer, this book is an easy to use and friendly guide about the world of interactive media. It will teach, challenge, and inspire you to create great interactive projects.

This book is great for developers, quality assurance engineers, testers, and test managers new to Apache JMeter, or those who are looking to get a good grounding in how to effectively use and become proficient with JMeter. No prior testing experience is required.

Explore the world of Virtual Reality by building immersive and fun VR projects using Unity 3D About This Book Learn the basic principles of virtual reality applications and get to know how they differ from games and desktop apps Build various types of VR experiences, including diorama, first-person characters, riding on rails, 360 degree projections, and social VR A project-based guide that teaches you to use Unity to develop VR applications, which can be experienced with devices such as the Oculus Rift or Google Cardboard Who This Book Is For If you’re a non-programmer unfamiliar with 3D computer graphics, or experienced in both but new to virtual reality, and are interested in building your own VR games or applications then this book is for you. Any experience in Unity is an advantage. What You Will Learn Create 3D scenes with Unity and Blender while learning about world space and scale Build and run VR applications for consumer headsets including Oculus Rift and Google Cardboard Build interactive environments with physics, gravity, animations, and lighting using the Unity engine Experiment with various user interface (UI) techniques that you can use in your VR applications Implement the first-person and third-person experiences that use only head motion gestures for input Create animated walkthroughs, use 360-degree media, and build multi-user social VR experiences Learn about the technology and psychology of VR including rendering, performance and VR motion sickness Gain introductory and advanced experience in Unity programming with the C# language In Detail What is consumer “virtual reality”Wearing a head-mounted display you view stereoscopic 3D scenes. You can look around by moving your head, and walk around using hand controls or motion sensors. You are engaged in a fully immersive experience. On the other hand, Unity is a powerful game development engine that provides a rich set of features such as visual lighting, materials, physics, audio, special effects, and animation for creating 2D and 3D games. Unity 5 has become the leading platform for building virtual reality games, applications and experiences for this new generation of consumer VR devices. Using a practical and project-based approach, this book will educate you about the specifics of virtual reality development in Unity. You will learn how to use Unity to develop VR applications which can be experienced with devices such as the Oculus Rift or Google Cardboard. We will then learn how to engage with virtual worlds from a third person and first person character point of view. Furthermore, you will explore the technical considerations especially important and possibly unique to VR. The projects in the book will demonstrate how to build a variety of VR experiences. You will be diving into the Unity 3D game engine via the interactive Unity Editor as well as C-Sharp programming. By the end of the book, you will be equipped to develop rich, interactive virtual reality experiences using Unity. So, let's get to it! Style and approach This book takes a practical, project-based approach to teach specifics of virtual reality development in Unity. Using a reader-friendly approach, this book will not only provide detailed step-by-step instructions but also discuss the broader context and applications covered within.

This is a cookbook of easy-to-follow recipes about ACT! 2011 dashboard and report practices. If you are an ACT! end user who wants to learn about the existing reports and dashboards available in ACT! 2009, 2010, and 2011, then this book is for you. If you are an ACT! administrator who wants to make changes to ACT!'s dashboard and reporting features or a sales manager who needs to measure the effectiveness of his sales force, you will also find this book helpful. New CRM users will learn how to measure the success of their database. Prior knowledge of ACT! is not essential; however, you'll find it helpful to have good working knowledge of how to add data to ACT!, or to work with an ACT! database that has already been populated with data.

Written in Packt's cookbook style, this book presents numerous practical examples that you can use directly in your applications. The book covers most of the essential issues you will face while developing your web applications and gives solutions to them. Recipes in the book are written in a manner that will rapidly take you from a beginner to expert level. If you want to use PHP and jQuery together to create web applications this book is for you. It provides a large number of examples in each chapter that will take you from a basic developer to a pro by giving step-by-step instructions for each task in developing web applications using PHP and jQUery. All you need are JavaScript basics and you are on your way to building power web applications, with this book in hand.

This hands-on guide takes a look at the main functional areas of Drupal that have significant new features. It explains these new features and how to use them, drawing attention to significant differences from how things used to behave, and giving the reader an idea of the kind of consequences these changes will bring to them. Drupal 7 First Look is written for site administrators, themers, and developers who have some experience with Drupal 6 (or even Drupal 5) and want to upgrade their sites, themes, or modules to Drupal 7 or just learn more about Drupal 7. No programming experience is required, but several code examples are covered for readers that want more in-depth information about building themes and modules.

The book looks at the main functional areas of Moodle that have significant new features, explains the new features and how to use them. It draws attention to significant differences from how things used to behave, and gives the reader an idea of the kind of consequences these changes will bring to them. If you are an existing Moodle user, tutor, or administrator, then this book is for you. You are expected to be familiar with the operation of Moodle.

This book introduces the OSM project, its aims and objectives, and its history, then guides you through the process of gathering, editing, and using OpenStreetMap data using a series of real-world examples. This book is the perfect aid for geographic-information professionals interested in using OpenStreetMap in their work and web designers and developers who want to include mapping in their sites, and want a distinctive style. It is for you if you have a need to use maps and geographic data for work or leisure, and want accurate, up-to-date maps showing the information you're interested in, without details you don't need. If you want to use maps for navigation and want more or less detail than traditional printed maps give this book is perfect for you.

This will be a step-by-step tutorial - a workbook with practical approach. The book starts by looking at the important features that make a professional job site: adding and managing jobs, jobseekers and employers, providing online recruitment services, selling credits and managing credit system, SEO to drive huge traffic to your job site, and so on. This book includes a lot of screenshots which not only illustrate tasks but also create a visual impact. This book contains overall necessary information that is important for the understanding of job site development. If you are looking for building and managing a job site using Joomla! extensions then this book is for you. Prior knowledge of using extensions is not expected but Joomla! basics will be required.

This book is very easy and straightforward to follow, and takes a hands-on approach, using practical examples to illustrate techniques and explain concepts using a fictitious company called "The Party People" to help you master the content administration of your web site. With each task outlined, simple explanations are offered on similar subject areas and links to further information are provided. If you are someone who wants to quickly and easily manage content and users for a Joomla! web site, this book is ideal for you. You could be a content editor, proofreader, graphic artist, feature editor, or anyone else concerned with managing content on a Joomla! installation. If you can browse the Web and use a wordprocessing software package, this book will help you develop the skills to efficiently manage your web site and gain a solid understanding of the Joomla! content management system.

This book is a tutorial, with plenty of step-by-step instructions bundled with examples and screenshots. VoIP telephony concepts are discussed, and how-tos are provided to help the reader become familiar with FreePBX. This book is targeted at system administrators who want to get started with FreePBX. Previous knowledge of Linux or networking is not required, although some basic knowledge of PBX and Linux will be a bonus.