SSG Blog

Insights and news from the SQL Solutions Group.

Featured

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.

May 13, 2015

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

May 7, 2015

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

April 28, 2015

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.

April 22, 2015

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

April 7, 2015

The value of a DBA can vary depending on numerous factors. Something that should be easy to answer is: what is a DBA worth? If

March 31, 2015