Books

Pro Encryption in SQL Server 2022

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.

2023-03-27 (first published: )

1,656 reads

SQL Server 2022 Revealed

SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability

Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.

2023-03-24 (first published: )

1,348 reads

SQL Server 2022 Query Performance Tuning

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.

2023-03-20 (first published: )

3,401 reads

Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen

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.

2023-03-20 (first published: )

3,836 reads

Expert Performance Indexing in Azure SQL and SQL Server 2022

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 […]

2023-03-17

11 reads

SQL Server Execution Plans eBook, Third Edition, by Grant Fritchey

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.

5 (3)

2023-03-15 (first published: )

1,763 reads

Tribal SQL eBook Download

TribalSQL: 15 New Voices in SQL Server

MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.

2019-03-26 (first published: )

378 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Managed Instance Link and SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managed Instance Link and SQL...

Passing parameters to query without TVFs

By seanachim@hotmail.com

Comments posted to this topic are about the item Passing parameters to query without...

Capturing Data Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Capturing Data Changes

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers