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

Nebraska SQL from @DBA_ANDY

I'm a forty-something Microsoft SQL Server DBA of 12+ years, a devoted husband, and a father of two young boys (with another coming soon!). I have been a DBA at a university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States.

Archives: May 2014

Handling Perfmon Logs with Relog


In a recent situation, I was tasked by a client to check one of their servers which they believed to be grossly over-provisioned.  As a VM they knew they could easily pull both CPU and RAM from the server if they could determine the true needs of the server.

One…

Read more

2 comments, 1,119 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 May 2014

Come to #SQLSAT307 in Iowa City!

June 6th & 7th in Iowa City - Friday precons & Saturday all day sessions!  I will be presenting on Maintaining your SQL Servers and my good friend David Klee will be presenting a Friday Virtualization precon (Only $99 if you register now!) and two Saturday sessions about Virtualization and… Read more

0 comments, 219 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2014

Why Won't My Clustered Instance Start?

Last weekend I had a client page me in the middle of the night (because, of course, these things always happen in the middle of the night) with the complaint that their SQL Server Failover Cluster Instance (FCI) wouldn't come online on their B node after multiple attempts.  When they…

Read more

0 comments, 348 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 May 2014

T-SQL Tuesday #54 - Interviews and Hiring



This month’s T-SQL Tuesday is hosted by Boris Hristov (blog/@BorisHristov) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring of SQL Server Professionals.  This is an interesting topic to me since I have given dozens of interviews over the years and…

Read more

0 comments, 1,295 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 May 2014

Help - I Need a List of my Maintenance Plan Jobs *and* Schedules!

UPDATE - Jason Brimhall (blog/@sqlrnnr) pointed out after reading this post that there is a more inline way to do a lot of this work as shown in his post here.  Jason's post relates to SSRS reports (very similar logic since they also are SQL…

Read more

1 comments, 342 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 May 2014

Speaking at #SQLSat307 in Iowa City!

I just received confirmation I will be speaking at SQL Saturday 307 in Iowa City on June 7th!

 
I will be giving an updated version of my Ola Hallengren Maintenance Solution talk that I have given at a few previous SQL Saturdays, re-titled "Are You Maintaining Your SQL…

Read more

0 comments, 181 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 May 2014