T-SQL Tuesday #41 - Presenting Opens Doors

This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....

TSQL Tuesday #41–Presenting and Loving it?

Well sort of…it took a while.

I’d done some plays and singing at school but my mother made me practice...

T-SQL Tuesday 41 – Presenting and Loving it!

Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for...

Unknown Unknowns: SSAS Version Number and Default Admins

With Service Packs and Cumulative Updates rapidly released for SQL, it can be hard to keep up with what version you have installed where. It’s easy enough to find...

Analysis Services Webinar Recording and Q&A

I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013.  If...

Chicago SQL Saturday (#SQLSat211) Is This Weekend

The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th.  If you are waiting until the last minute...

Disabling Resource Governor

I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the...

DMV-5 : Queries runing are adhoc or proc , single or multi use ?……..sys.dm_exec_cached_plans

sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached...

How do I use a variable in an IN clause?

I see this question in one form or another a lot. I’ve seen this or something like it probably half...

How Much Power Does Your PC Use?

I can’t say I’ve ever worried too much about how much power my PC uses. I care about battery life...