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 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.
I have recently had a client with a problem each morning where they were having processes fail with this message in their SQL Server Error Log:
Date 12/01/2015 5:58:48 AM
Log SQL Server (Current - 12/01/2015 1:00:00 PM)
Message Error: 9002, Severity: 17, State: 3.
I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer. Grant the login the same permissions as Domain\Mary.
On the face of it, this seems relatively straightforward, right? It is the kind of request that we all get from time to time, whether as an…
(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 great…
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but many of them), and looking in the output file from the LiteSpeed Maintenance plan (the client's tool of choice) I found entries like this:
Database Database01: Transaction Log Backup...
Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):
|PASS Anti-Harassment Policy Reminder|
It is unfortunate that I have to write this letter, but it has become necessary.
An Anti-Harassment Policy
(AHP) was implemented in 2012 to help provide a harassment-free conference experience.…
…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…
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…
(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…
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…
(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…