Availability Groups: When Your Synchronous Secondary isn’t Synchronous

During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...

DevOps and Automation Will Eliminate the DBA

I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...

Developing Presence

At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to...

SQL Server Monitoring: What to start measuring

So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...

Quick Permissions Audit

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:

Easy Permissions Audit...

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...

SQL Bits 2019: The Great Data Heist

SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...

Data Warehousing Tip #4 – Trust your instinct

My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...

Dodging Deadlocks With Indexes

A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....

WordPress's Block Editor and the Publicize Feature

Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...