SQL Clone
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.

Toolbox - Exporting SSMS Results to Excel

I was working on another post when I found myself needing to dump out query results to a grid format to include in the post.  This is a very normal situation - even in my day-to-day job I send emails with grids of results (we all do right?)

The easiest…

Read more

0 comments, 86 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 March 2019

T-SQL Tuesday #111 - Why Do You Do What You Do?

This month's T-SQL Tuesday is hosted by Andy Leonard (blog/@AndyLeonard) and his topic was this:

That’s the question this month: Why do you do what you do?

For me this was the easiest T-SQL Tuesday I have ever seen.  Some of you may consider this a…

Read more

0 comments, 105 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 February 2019

Why Can't I Shrink TempDB?

I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc

We all know that there are simply times you have to shrink some files.  There are risks - blocking, significant I/O, fragmentation, and more - all of which mean you should not shrink a file willy-nilly without considering the impacts...but sometimes you are having a production…

Read more

0 comments, 400 reads

Posted in Nebraska SQL from @DBA_ANDY on 1 January 2019

Things I Learned at Summit v20 - Visual Studio Code

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this post we'll look at a code editing tool that I hadn't seen before - Visual Studio Code.


When I attend a session at a technical event - Summit/SQL Saturday/etc. -…

Read more

0 comments, 207 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 December 2018

Things I Learned at Summit v20 - Trace Flag 4199

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post we'll look at a trace flag I had never even heard of, let alone deployed - 4199.

What is a Trace Flag?  According to Microsoft:
Trace flags…

Read more

1 comments, 2,444 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 November 2018

Invalid value given for parameter PASSWORD. Specify a valid parameter value.

I still use sp_help_revlogin to transfer logins between servers.  I know there are other options, including a set of Powershell commands contained in dbatools (#YouCanDoAnythingWithPowershell) but this is a case where the old method works so I don't mess with it.


Having said that, I know a lot of…

Read more

2 comments, 2,832 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 October 2018

Coming Soon to Minnesota...Lincoln...and Seattle!!!

It's that time of year when SQLSaturdays start to slow down (in the U.S. anyway) as we march towards Summit and the holiday season.

Having said that, I have three speaking engagements in the near future - two SQLSaturdays and...SUMMIT!!!


I will be giving slight variations on the same…

Read more

0 comments, 262 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 September 2018

Did Not Know That - Redirecting CMD to the Clipboard

One of the items I frequently deal with as a Production DBA is drive alarms.  I have written previously about looking for space inside database files, but what if your problem is non-database files?

The goto tool in Windows for me has always been du (Disk Usage) created by Mark…

Read more

0 comments, 2,791 reads

Posted in Nebraska SQL from @DBA_ANDY on 4 September 2018

The Mystery of the Exploding T-Log

There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:


Log Name:      Application
Source:        MSSQLSERVER
Date:          5/24/2018 12:49:39 AM
Event ID:      3314
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SQL01.client99.com
During undoing of a logged operation…

Read more

4 comments, 2,352 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 August 2018

Speaking This Weekend in Iowa City!

Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never disappoints - Iowa always puts on a fun event with great atmosphere and informative sessions.

I am giving the premiere of my new presentation "Intro to Powershell for the…

Read more

0 comments, 391 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2018

Revoke the permission(s) before dropping the server principal

As a remote DBA I often have to log in to client systems for a fixed amount of time and then remove logins and other security after the work is done.

This morning while cleaning up I ended up with a new error for me:

Msg 15173, Level 16,…

Read more

0 comments, 1,384 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 June 2018

Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!

Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:

The webcast (“SQL Query Optimization. Why is it so hard to get right?”) is free, but with a suggested donation to the  Robert Davis Memorial and Grief Fund:

Read more

0 comments, 776 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 June 2018

Speaking at PASS Summit 2018!

I found out a few days ago that one of my sessions was selected for Summit this Fall - I will be presenting an updated version of my "Getting Started with Extended Events" session that I have been working at SQL Saturdays over the last couple years.


Read more

2 comments, 267 reads

Posted in Nebraska SQL from @DBA_ANDY on 6 June 2018

Toolbox - How Long Has My Server Been Up?

No..not that Up (although it is awesome!)


As a remote service provider a common request is to follow up after a server restart (or investigate a possible server restart).  A question that inevitably comes up is "When did the server restart?"

If all you need to know is…

Read more

0 comments, 264 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 May 2018

When Good Query Plans Go Bad

Today's story starts again with a page escalation:

We are seeing very high CPU usage on DistServer01.  Could you please take a look and do a health check on this server?  Please let us know if there is anything we can do to help.

I connnected to DistServer01…

Read more

0 comments, 2,432 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 May 2018

Why Don't I have a Preferred Replica?

The client reported that the log file on their main database was growing unusually large, and when they checked the backup target the database didn't have any LOG backups!

Oh, and the database was part of an Availability Group.


After some investigation we found that while the Availability…

Read more

2 comments, 2,135 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 April 2018

Toolbox - Do You Have Current Backups?

On our managed servers we run a job each day to check that either a FULL or DIFF has run in the last 24 hours, but all-too-frequently I find myself on a server that we don't manage, trying to determine the current situation (aka the "health check").

An important thing…

Read more

0 comments, 603 reads

Posted in Nebraska SQL from @DBA_ANDY on 4 April 2018

Toolbox - Just the Basics

There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use come from Glenn Berry of SQLskills (blog/@GlennAlanBerry) but I have found that there is more data than his basic set that I like to pull,…

Read more

0 comments, 622 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 March 2018

Which Blogs Do I Recommend?

One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs.  The world used to run on professional magazines and journals (and there are a few good ones still out there) but the current equivalent of a weekly or quarterly periodical…

Read more

0 comments, 364 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 March 2018

Error 33206 - SQL Server Audit Failed to Create the Audit File

One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?


Exhibit A - the 33206:
Error: 33206, Severity: 17, State: 1.
SQL Server Audit failed to create the audit file 'T:\MSSQL\Audit Files\PLAND_Objects_DML_Audit_Events_A2B00B57-4B43-4570-93C8-B30EE77CC8C9_0_131645629182310000.sqlaudit'. Make sure that the disk is not full and that…

Read more

2 comments, 3,367 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 March 2018

Older posts