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
Tag: #SQLMagazine
What is a DBA Worth?
The value of a DBA can vary depending on numerous factors. Something that should be easy to answer is: what
March 31, 2015
Automating DBCC PAGE – Part 3: Is a Clustered Index physically sorted on disk?
In my last few blog posts, I’ve shared several methods of getting internal information from a database by using the
March 25, 2015
Check for Errors First, Part II: The Default Trace
In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the
March 17, 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
Check for Errors First, Part I
I have seen a number of environments concerned with performance issues, and jump to looking at performance metrics when these
February 24, 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
Automating DBCC PAGE, part 2: Determining object names on pages
In my last post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option. In
February 3, 2015
A Tale of Two DBAs: A Cautionary Tale
“It was the best of database consulting times…it was the worst of database consulting times…” One of the most common
January 27, 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