Finding Ad Hoc Queries with Query Hash

I was presenting a session on how to read execution plans when I received a question: Do you have a...

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I...

Monitoring and Baselines Presentation

Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...

Power Map Enhancements and Presentation

Power Map for Excel 2013 has had some recent enhancements that are worth noting.  You can download the latest Power...

Reblog: September 13 to September 19

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

Secrets of successful projects…:)

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket...

Web Design & Azure

I’ve listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I’m friends with several...

Adding Top 10 Charts to Power View Which Honor Filters

Before I get too far in the weeds, I have to recognize Rob Collie, his blog (http://www.powerpivotpro.com) and his bookDAX...

Extract DacPac Using Command Line

When extracting Dacpacs it’s quite straightforward to go through the UI and extract, however what if you want to do this for more than one database, or automate the...