Learn T-SQL Querying
Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers
2024-06-26 (first published: 2024-02-29)
2,543 reads
Books
Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis
Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.
2024-04-10 (first published: 2023-06-19)
3,404 reads
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.
2024-04-08 (first published: 2023-01-12)
9,111 reads
Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen
Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.
2024-03-06 (first published: 2020-07-28)
10,318 reads
Expert Performance Indexing in Azure SQL and SQL Server 2022
Take a deep dive into perhaps the single most important facet of query performance―indexes―and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other […]
2024-01-17 (first published: 2023-03-17)
4,170 reads
Practical Graph Structures in SQL Server and Azure SQL: Enabling Deeper Insights Using Highly Connected Data
Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data that go beyond classic relationships.
2023-11-22 (first published: 2023-08-18)
983 reads
SQL Server Execution Plans, Third Edition, by Grant Fritchey
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.
- Download free eBook
- Printed book:
2023-08-16 (first published: 2020-07-28)
5,800 reads
SQL Server Internals: In-Memory OLTP
In this book, Kalen Delaney explains how the 2016 In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
- Download free eBook
- Printed book:
- Kindle book:
2023-04-28 (first published: 2014-11-11)
983 reads
Best of SQLServerCentral, Volume 5
Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007.
2022-04-27 (first published: 2009-02-10)
5,251 reads
Best of SQLServerCentral, Volume 6
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
2022-04-27 (first published: 2009-02-10)
7,556 reads
Blogs
Visualising SQL Server in Kubernetes
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Picking a Starting Table in Test Data Manager
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server Migration Using a Distributed Availability Group
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Forums
what is the difference between these two queries
Please I am struggling to understand the difference between these two queries. It behaves...
Introduction to PostgreSQL for the data professional
Comments posted to this topic are about the item Introduction to PostgreSQL for the...
what happens to ssis and ssrs whenb we migrate to sql saas
Hi we know (or believe) ssas saas gets stood up separately when a company...
Question of the Day
CHOOSing an Alias
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers