Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for.
- By Joey D'Antoni
- 05/24/2022
Getting a bird's eye view can help to quickly spot trouble areas.
- By Joey D'Antoni
- 02/23/2022
The next major version of Microsoft's flagship database engine is now in private preview. Here's what you need to know about it.
- By Joey D'Antoni
- 11/02/2021
Time to hit the basics and dive into how theSQL Server database engine works.
- By Joey D'Antoni
- 10/28/2021
Here's how to fix that performance database query to speed up response time.
- By Joey D'Antoni
- 09/28/2021
As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives.
- By Joey D'Antoni
- 08/25/2021
As of July 13, SQL Server 2016 no longer has mainstream support. Your next steps as a DBA include understanding Microsoft's support model, knowing the risks of upgrading and then biting the upgrade bullet.
- By Joey D'Antoni
- 07/20/2021
Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.
- By Joey D'Antoni
- 06/15/2021
Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as possible.
- By Joey D'Antoni
- 05/19/2021
Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your storage properly to keep SQL Server workloads running smoothly.
- By Joey D'Antoni
- 04/14/2021
Microsoft announced a lot of Azure SQL news at Ignite this month, but few as critical to application development security than the public preview of Always Encrypted with secure enclaves. Here's how to get started with this new feature.
- By Joey D'Antoni
- 03/15/2021
Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in Azure.
- By Joey D'Antoni
- 01/22/2021