Edition: Saturday, June 8th, 2024
Are you familiar with the terms DevOps and Platform Engineering? DevOps is the process of consistently and reliably deploying applications into production environments. Platform Engineering focuses on building and maintaining the foundational infrastructure and t...
Edition: Saturday, April 27th, 2024
Over the past several weeks we've implemented a CA, generated a certificate, and enabled SQL Server network encryption. We validated encryption was being used via the sys.dm_exec_connections dmv. This week, I'll take the validation one more step by using Wiresh...
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...