SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2012

No Caps for SQL Saturday : Speaker Edition

A few weeks back, I got into a conversation about whether PASS should put the boot down on events and prevent people from doing what some view as “bad” things.  Unfortunately, I hadn’t realized that this had turned into such a controversy until I received a DM the other day… Read more

0 comments, 991 reads

Posted in StrateSQL on 17 May 2012

“Thou Shall Not Shrink the Database” #TSQL2sDay

This month, Chris Shaw (Blog | @sqlshaw)  is leading the charge on the T-SQL Tuesday.  This event is basically a blogging party where a number of us in the SQL Server community gets together to discuss a central topic.  The topic that was chosen for this month… Read more

0 comments, 991 reads

Posted in StrateSQL on 8 May 2012

May 2012 – Monthly SQL Server Checklist

They say, “April showers bring May flowers.”  But what if it doesn’t bring May flowers?  What if instead you get May servers getting zapped by lightning?  Are you ready?

One of the easiest ways to find out is to check your environment and make sure that you have done as… Read more

0 comments, 829 reads

Posted in StrateSQL on 8 May 2012

Can You Dig It? – Determining Index Plan Usage

She Can Dig It!

A while back I was asked, if you can use the plan cache to determine which plans are using specific indexes.  The answer is, of course, yes, you can.  And it’s important that people, especially DBAs, understand how to do this.  Usually during index analysis, we… Read more

0 comments, 1,425 reads

Posted in StrateSQL on 4 May 2012

Changing Priorities

If you’ve been following this blog for a while, you have probably noticed that the content here has been a bit sparse.  In fact, I don’t think I’ve written anything wholly interesting in a number of months.  Lots of posts about checklists, up coming presentations, and re-caps of posts from… Read more

0 comments, 704 reads

Posted in StrateSQL on 3 May 2012

SQLFriends in Minneapolis

Ever wanted to hang out and talk about SQL Server over lunch?  Maybe get a chance to ask those questions about SQL Server that have been bugging you for a while?  Or better yet – ever wanted to make fun of me for an hour and a half for the… Read more

0 comments, 610 reads

Posted in StrateSQL on 2 May 2012