Free eBook - Learn T-SQL Querying By Packtpub

Free eBook - Learn T-SQL Querying By Packtpub

About this book

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 leverage them for troubleshooting. In later chapters, you will explain 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 build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will work with 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 developed 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


Click here to access

Comments

Post a Comment

Popular posts from this blog

  List of paid Udemy Courses for FREE in July 2021 [12th July 2021] Paid Udemy courses for FREE 1.  Criminology : Fundamentals of Criminal Psychology and Law 1.  Apply Coupon code:  CRIMINOLOGYLEARNFREE  2.  Enroll Now 2.  Network Programming Masterclass™:Java Socket, TCP/IP, Server 1.  Apply Coupon code:  NETWORKLEARN  2.  Enroll Now 3.  Android App Development Bootcamp with Kotlin - Masterclass 1.  Apply Coupon code:  LEARNANDROIDFREE  2.  Enroll Now 4.  Reverse Engineering, Debugging and Malware Analysis - 2021 1.  Apply Coupon code:  LEARNREVERSEFREE  2.  Enroll Now 5.  Accounting–Financial Accounting Total-Beginners to Advanced 1.  Apply Coupon code:  CB463C63645DD512CBEF  2.  Enroll Now 6.  Corporate Finance #4 Leverage & Break-Even Analysis 1.  Apply Coupon code:  D5B3DA85936CA536A435  2.  Enroll Now 7.  Corporate Finance #3 Forecasting & Budgeting 1.  Apply Coupon code:  83C44705D28E5033E716  2.  Enroll Now 8.  Corporate Finance #2 Financial Ratios 1.  Apply Coupon code
Read more

Free eBook - Blockchain By Example By Packtpub

Image
Free eBook - Blockchain By Example  By Packtpub About this book The Blockchain is a revolution promising a new world without middlemen. Technically, it is an immutable and tamper-proof distributed ledger of all transactions across a peer-to-peer network. With this book, you will get to grips with the blockchain ecosystem to build real-world projects. This book will walk you through the process of building multiple blockchain projects with different complexity levels and hurdles. Each project will teach you just enough about the field's leading technologies, Bitcoin, Ethereum, Quorum, and Hyperledger in order to be productive from the outset. As you make your way through the chapters, you will cover the major challenges that are associated with blockchain ecosystems such as scalability, integration, and distributed file management. In the concluding chapters, you’ll learn to build blockchain projects for business, run your ICO, and even create your own cryptocurrency. Blockchain by
Read more

Free eBook - Mastering Internet of Things By Packtpub

Image
  Free eBook - Mastering Internet of Things  By Packtpub About this book The Internet of Things (IoT) is the fastest growing technology market. Industries are embracing IoT technologies to improve operational expenses, product life, and people's well-being. Mastering the Internet of Things starts by presenting IoT fundamentals and the smart city. You will learn the important technologies and protocols that are used for the Internet of Things, their features, corresponding security implications, and practical examples of how to use them. This book focuses on creating applications and services for the Internet of Things. Further, you will learn to create applications and services for the Internet of Things. You will discover various interesting projects and understand how to publish sensor data, control devices, and react to asynchronous events using the XMPP protocol. The book also introduces chat, to interact with your devices. You will learn how to automate your tasks by using the
Read more