T-SQL Tuesday #41 – Presenting and Loving it!

It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...

T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!

It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...

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...