Video: Designing a SQL Server Always On Availability Groups Topology

As you go thru different phases in your career as a SQL Server professional, you progress from being a technician (primary task is more focused on operations) to a designer/architect (primary task is focused on designing a solution and eventually assists in building it.) A technician will be more concerned about a single aspect of a […]

Resources: Windows Server Failover Clustering (WSFC) for SQL Server DBAs

Last week at Live360, I have had the opportunity to deliver my workshop on Windows Server Failover Clustering (WSFC) for SQL Server DBAs. The workshop was based on an online course that I am about to re-release. One of the things I like about delivering presentations is that I learn a lot from the attendees […]

Before You Go Down The Rabbit Hole

Effects of a Full SQL Server Transaction Log, Error 9002 and Why Understanding The Application Matters When Troubleshooting

One of my favorite topics in SQL Server is transaction log internals. When I first got started with SQL Server, I thought all I needed to do with the transaction log was to run regular log backups to make sure they don’t grow unexpectedly. Until I realized that there was more to it than I knew. […]

The Truth About SQL Server Backup Verification Using The GUI

Why You Shouldn't Just Rely On The Checkbox That Says So

I recently had a conversation with a SQL Server DBA about making sure that backups do work as expected. And while I try not to use scary tactics to convince people to change their way of thinking, this particular example needed it. I’ve written a blog post about why I don’t trust the “Verify backup […]

Why Your Job Really Matters Today

And Why You Need To Constantly Sharpen The Saw

When you are surrounded by some of the smartest and brightest people in the Microsoft data platform community, it’s like drinking from a fire hose. But the overwhelming feeling that you get from learning a lot in a very short span of time suddenly sinks in when you realize this very important message: your job […]