Edition: Saturday, April 20th, 2024

For a DBA, securing SQL Server is a critical aspect of the job.  Securing data at rest, data in motion, and data in use (in memory) are all areas a potential attacker could focus on.  This month, I've focused on "securing data in motion" using trusted certificate...

Edition: Saturday, February 24th, 2024

A common challenge DBAs encounter is efficient capacity planning.  Ensuring that SQL Server is operational, optimized, and ready to scale is important. 

In today's edition, I'll share insights on capacity planning, including strategies, tools, and best practi...

Edition: Saturday, February 10th, 2024

Sign up for the DBA Challenges Newsletter here --> DBA Challenges - Newsletter (automatesql.com).

It's hard to believe we're already in the 2nd week of February 2024.  

Today, I will focus on how to leverage Extended Events to identify and troubleshoot queri...

Edition: Saturday, February 3rd, 2024

In today's issue, I will show how to perform a simple installation of Active Directory, cover basic concepts, and explain why it's crucial to a DBA.  

For DBAs, understanding how SQL Server integrates with Active Directory is important for ensuring secure, eff...

Have you ever needed to install a relational database engine fast in your sandbox?  SQL Server is well known for its easy installation, albeit not all best practices are configured as part of the general installation.  In this video, I will show you how to install SQL Server 2022 Developer Edition f...