Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out
May 13, 2015
Category: SQL
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)
April 28, 2015
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
April 22, 2015
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
April 7, 2015
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka
March 11, 2015
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of
February 17, 2015
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index
January 21, 2015
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest encrypting a database. In SQL Server,
September 2, 2014
Synonyms in SQL Server – Good and Bad
When SQL Server 2005 was released, a nifty little feature was included called synonyms. Despite being around since SQL Server
July 1, 2014
Winter 2012 Performance Palooza!
This Thursday, December 6, 2012, the SQL PASS Performance Virtual Chapter will be holding online sessions all day long in
December 4, 2012