Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
Contact the author
for this blog
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.
(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…
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…
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: http://omahamtg.com/Events.aspx?ID=268
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…
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…
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…
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.
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
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…
This month’s T-SQL Tuesday
is hosted by Boris Hristov (blog
) 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…
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…
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…
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.
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…
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…
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…
My employer Ntirety
(a division of HOSTING
) is currently looking for multiple SQL Server DBA's. As you have probably seen from me on Twitter (or on this blog) previously, I joined Ntirety last November as a 100% work-from-home Senior SQL Server DBA.
Ntirety is based out of Boston, but…
This story begins, as so many often do, with a few key elements:
1) A client who experienced a problem on Thursday and waited until Friday evening to report it, even though the problem was "critical" enough to ask us to work on it all weekend if we couldn't solve…
We - the rank-and-file employees at Ntirety
- received word yesterday that we had been acquired
, a cloud and network services provider based out of Denver, CO. Apparently Hosting did not have a database services division and decided it made more sense to buy one than to…