Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2013

When DMVs Cost Me My Job

Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA for a little less than 3 years, but I felt like I knew a lot. I spent every night on the forums helping people with issues as a way of…

Read more

T-SQL Tuesday #49: Wait For It Roundup

A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of T-SQL Tuesday. I hope I didn’t keep you waiting too long for the roundup. <rimshot> Let’s take a look at this month’s participating blog posts: Fellow Certified Master (MCM) Rob…

Read more

Enabling High Performance Power Plan via PowerShell

One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard configuration changes. Much of this process was already done by my predecessor Nic Cain (blog|@SirSQL) who had written an interactive PowerShell process for doing the SQL Server installs and making…

Read more

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL Tuesday, hosted by yours truly, is … wait for it … Waits and Queues. For my donation to this little blog party, I’m contributing my favorite go-to query for waiting…

Read more

Never an Infinite Loop Around When You Need One

You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time. As with most things, there are times when infinite loops can be useful, as long as there is some attainable condition that breaks us out of it. I found myself…

Read more

T-SQL Tuesday #49: Topic is … Wait for It …

Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now. The topic for this month’s T-SQL Tuesday is … wait for it … What? Still waiting? Well, suspend your confusion because that’s it. The topic is (queue the fanfare) Waits.…

Read more