Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Nebraska SQL from @DBA_ANDY

I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

CHECKDB - The database could not be exclusively locked to perform the operation

…so the job failed….again…you know the one – that darn Integrity Check job: 
Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete  End Progress  Error: 2015-11-15 03:27:52.43     Code: 0xC002F210     Source: User Databases Integrity Check Execute SQL Task     Description: Executing the query "DBCC CHECKDB(N'master')  WITH NO_INFOMSGS  " failed with the…

Read more

1 comments, 1,299 reads

Posted in Nebraska SQL from @DBA_ANDY on 16 November 2015

SQL Server Training

Brent Ozar’s group ( just announced a pretty crazy set of “Black Friday” deals:

Insane sales if you can be one of the first few at midnight, but discounts all day on various training.


The other top training in the field (to me) is from Kimberly…

Read more

2 comments, 212 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 November 2015

T-SQL Tuesday #72 - Implicit Conversion Problems

This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”

(If you don’t know about T-SQL Tuesday check out the information here– each month there is a new topic and it is a…

Read more

2 comments, 1,340 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 November 2015

PASS Summit 2015 Recap

Last week was the annual PASS Summit in Seattle.  The Summit is the predominant educational and networking event for SQL Server professionals of all types – DBA’s, Developers, Analysts, and many more.

I wasn’t sure I was going to be able to attend this year but after some gyrations with…

Read more

0 comments, 199 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 November 2015

Deleting Files Older than X Hours with PowerShell

(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").


I currently have a situation at a client where we are running a server-side trace that is generating 6GB-7GB of trc files per day while we are watching to see what might be causing a…

Read more

0 comments, 3,836 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 April 2015

Availability Groups - Where Did My Disks Go?

The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!

At a client recently two availability groups on a single Windows cluster went down simultaneously.  Apparently the server that was the primary for the AGs (Server1) had mysteriously lost its DATA and LOG drives.  By…

Read more

1 comments, 2,131 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 April 2015

POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!

UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11 still at Farm Credit - I will be giving this same talk and we hope to see you there!

Please RSVP at this new link:




Read more

0 comments, 380 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 February 2015

Log Shipping - Exclusive access could not be obtained because the database is in use

This story began as they almost always do - with a page at 4am local time...


'Alert: SQL Failed Jobs on InstanceName is Failed'

Job name: LSRestore_InstanceName_DatabaseName
Date & Message: 2014-07-31 05:24:00.0 The job failed. The Job was invoked by User DOMAIN\LOGIN. The last step to run was step…

Read more

2 comments, 2,280 reads

Posted in Nebraska SQL from @DBA_ANDY on 31 July 2014

End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2

@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2


What does this mean?

The key takeaway comes from this section of the MSDN blog:

For both SQL Server 2008 and SQL Server 2008 R2, Microsoft will continue…

Read more

0 comments, 2,320 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 July 2014

Why Is your datetime saved as a bigint anyway?

Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.

On a client system their primary database had grown to throw disk alarms on the DATA drive, so I was alerted.  I signed onto the system and found that…

Read more

0 comments, 382 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 June 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.


Read more

2 comments, 2,010 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, 393 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, 997 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,794 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

2 comments, 1,603 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, 352 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 May 2014

Why Can't I Reinitialize My Subscriber?

I recently had a colleague request help with a replication problem he was having with a client.  The client was running transactional replication from a SQL Server 2005 Publisher to multiple SQL Server 2005 Subscribers and was having issues after attempting to add several articles (tables) to an existing publication.

Read more

1 comments, 824 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 April 2014

Where are my 32-bit Perfmon Counters?

I have run into this before, but not in this same way, so I decided it would be worth writing about.

On a client server they are running 32-bit SQL Server 2005 (I know, not supported - that's a different rant/post) on a 64-bit Windows 2008 installation.  When I logged…

Read more

3 comments, 1,635 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 April 2014

Why does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing multiple failovers when they performed routine Windows patching.

The client's request which generated the work ticket was this:

At some point recently this clustered node failed over from the A…

Read more

1 comments, 2,757 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 April 2014

I Know I Shouldn't Shrink My Log file, BUT...

As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it, as *any* DBA you spend time cleaning up other people's mistakes...)

We all know you shouldn't shrink your log file (right?  We all know this, right?) The experts constantly preach…

Read more

4 comments, 1,579 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 April 2014

Newer posts

Older posts