Edition: Saturday, March 16th, 2024
Good morning! Hopefully, this week's edition finds you getting some much-needed rest on a Saturday. It's early here in Tennessee and I'm hoping for a sunny day.
This past week I posted a few LinkedIn challenges on the topic of change tracking...
Edition: Saturday, March 9th, 2024
Keeping data confidential is a crucial role for a DBA. Today, I'll share strategies that Database Administrators can implement to enhance data confidentiality. You'll learn about the importance of encryption, access controls, auditing, and...
Edition: Saturday, March 2nd, 2024
Welcome to March!
Today, I want to talk about one common challenge a DBA may encounter. Scripting a database(s). There are a few common scenarios that may require this. Here are a few:
- Needing to create an empty shell of an...
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,...
Edition: Saturday, February 17th, 2024
I recently had a conversation about the placement of SQL Server native backups. Backups were stored on the same drive as the database log files, and I mentioned that they needed to reside elsewhere.
Today, we will look at what happens when...
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...
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...
Edition: Saturday, January 27th, 2024
Welcome to this week's edition. We'll break down the two most popular posts ranked by comments. Be sure to grab the scripts to work through the demo yourself if you'd like. We'll jump right in (I hear DBAs are busy people).
Day 24 - Comments...
Edition: Saturday, January 20th, 2024
Welcome to this week's edition (actually, this is the very first edition). We'll break down the most popular posts ranked by two categories: Most Comments and Most Impressions.
Most Comments - 39
Let's take a look at the first challenge.
...