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.

9003 is a Scary Number

Recently I moved up to the next consecutive error number, a 9003 error:

Log Name:      Application
Source:        MSSQLSERVER
Date:          6/15/2017 4:49:59 AM
Event ID:  …

Read more

0 comments, 226 reads

Posted in Nebraska SQL from @DBA_ANDY on 21 June 2017

It's Just Another 9002...another error like all the rest...

11:30pm on a Saturday night, and the pager went off…

Error: 5901, Severity: 16, State: 1.
One or more recovery units belonging to database 'i3_dialer' failed to generate a checkpoint. This is typically caused by lack of system resources such as disk or memory, or in some cases due to…

Read more

1 comments, 363 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 May 2017

T-SQL Tuesday #89 – The O/S It is A-Changing

It's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different selects a new topic.  This month's cycle is hosted by Koen Verbeeck (blog/@Ko_Ver) and his chosen topic is "The Times They…

Read more

0 comments, 296 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 April 2017

Who Left Those Old Components in My New Database???

Recently a client requested some new transactional replication publications on a relatively new pre-production server.  The client has plenty of transactional and snapshot replication in their environment, including two other publications on this instance already, so this was just adding more to the existing pile.

Piece of cake, right?


Read more

1 comments, 1,177 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 April 2017

Querying SQL and Windows Version Info with T-SQL

Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself.  There are a couple of frequently touted options:



The most basic option, and it does return most of what we want but not in any kind of…

Read more

4 comments, 2,194 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 March 2017

Embrace The Missing Index DMVs - But Proceed with Caution!

One of the performance tools I use all of the time is the set of Missing Index DMVs: 
·         sys.dm_db_missing_index_details– Detailed specifics on the missing indexes, including column lists 
·         sys.dm_db_missing_index_groups– relates individual missing indexes to index groups
·         sys.dm_db_missing_index_group_stats– information on potential…

Read more

1 comments, 2,151 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 March 2017

How many Backups is Too Many?

Does this title seem strange?  Of course we know this is the true answer:


But here is a story of a client that may have too many backups after all.


Our monitoring system found that the backups on a client server had suddenly started running very long.  When…

Read more

4 comments, 2,012 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 February 2017

YouTubing Down the SQL Server River

I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and one of the nicest people out there - Kendra Little (blog/@Kendra_Little).  Since divesting herself from Brent Ozar Unlimited over a year ago Kendra has been…

Read more

0 comments, 387 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 February 2017

#SQLSpeaking this Fall!

I have some great speaking dates coming up this Fall - here is the list:


First - the big one.  I am honored to be chosen for the first time to speak at the PASS Summit in Seattle.  The only negative is that I am not on until Friday…

Read more

0 comments, 192 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 September 2016

Thank You SQL Saturday Sioux Falls!

I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls.  The audience was great with some multiple questions and follow-ups, so it was awesome!

The sessions have been informative and the event team has done a wonderful job with all of…

Read more

0 comments, 250 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 July 2016

Finding File Growths with Extended Events

I give a SQLSaturday session called "Introduction to Extended Events" and at a recent presentation I had a pair of attendees ask me afterwards for a more "real world" example.  I had a basic demo in my session showing setting up a session with a predicate filter to pull particular…

Read more

2 comments, 2,339 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 June 2016

How Do I Change My Domain Password on Windows Server 2012?

As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers on client domains.  Most clients (unfortunately not all of them - security is important, people!) have some variant of password expiration in their domains requiring regular password changes every 30/90/180…

Read more

2 comments, 364 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2016

Catching Up on The #SQLPASS Virtual Chapters

(Didn't realize until I was posting that this was my 100th post...whew!)


A few months ago we purchased a new "smart" Blu-Ray player and one of its intriguing features was its built-in WiFi with pre-installed Internet apps like Amazon Video, YouTube, Vudu, etc. (Previously we had a 6-year-old "dumb"…

Read more

0 comments, 483 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 May 2016

Upcoming SQL Saturdays - June 2016

I am speaking at two different SQL Saturdays in June!


First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517) - I am speaking at 2:45pm on "Getting Started with Extended Events."  This is quickly becoming my favorite of the talks that I give…

Read more

0 comments, 403 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 May 2016

SQL 2016 - The Time Has Come!

Microsoft dropped it on us this morning:


I read the article and was pleasantly surprised, although after some consideration it was more like this:

If you haven't already started working with SQL Server 2016 this is definitely the time.  Here are…

Read more

2 comments, 501 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 May 2016

Where Is My Primary Replica Again?

We have many clients with multi-node Availability Groups - that is, AGs with more than two replicas.  One of the problems I have always had with Availability Group management via the GUI (admit it, you use the GUI sometimes all you non-PowerShell geeks) is the fact that most of the…

Read more

2 comments, 2,036 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 April 2016

How Long Did That Job Run?

When you use the msdb tables to try to gather information on your SQL Server Agent jobs, inevitably you will end up in a situation like this:
sj.name as JobName
,sjh.run_date as RunDate
,sjh.run_time as RunTime
,sjh.run_duration as Duration
from msdb.dbo.sysjobhistory sjh
join msdb.dbo.sysjobs sj
on sjh.job_id…

Read more

2 comments, 2,462 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 April 2016

Don't Use Delimiters In Your Object Names!

It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file are missing / out of date **
db                status   recovery model   last full backup   Full BU hours old
[FinanceDB]    …

Read more

6 comments, 1,142 reads

Posted in Nebraska SQL from @DBA_ANDY on 4 April 2016

Why I Love #SQLSaturday

PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you're attending a SQLSaturday or thinking about hosting your own, we think you'll find it's a…

Read more

0 comments, 304 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 March 2016

Pulling Security Info

A frequent request I receive is to pull a list of logins/users with certain accesses, role memberships, etc.

I had a query to use xp_logininfo to pull group membership chains - that is, DOMAIN\Andy has access, but not directly - DOMAIN\Andy has access because he is a member of DOMAIN\DBAGroup.…

Read more

0 comments, 1,274 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 March 2016

Older posts