SSG Blog
Insights and news from the SQL Solutions Group.
Recent
The Interview Trick Question
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.
Fight The Weeds
Spring time means tuning up the lawn mower, digging out the pruning shears, and testing the sprinklers (at least in Utah, where we can’t rely
Automating DBCC DBTABLE – Obtaining the Disk Sector Size
It’s a best practice to have the disk sector size (also known as the allocation unit size or block size) set to 64kb (see this
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform your SQL Server Profiler duties.
Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was there one minute, and the