SQL Server 2012 Diagnostic Information Queries (April 2013)

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.

Here I share a free and easy way for you to get valuable insight into the...

SQL Server Management Data Warehouse (MDW) – Why it Rocks

Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy...

The Bucket List – Item #1 is (finally) finished

We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...

Calculating the length of a string (Len vs DataLength)

This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...

Customizing SSMS–Results

This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...

Determining when statistics were last updated in SQL Server?

I received an email from friend today asking how he can see when statistics were last updated in SQL Server....

DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants

sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...

Event Notifications 101 – Intro to Event Notifications

Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server.  And...

Finding SQL Server Installs with Powershell, Again

But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...