Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Nebraska SQL from @DBA_ANDY

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.

Why Did My Job Fail Anyway?

One of my biggest pet peeves when I check a new SQL Server for a client is the fact that by default there is no method of telling why a job has failed.

My philosophy is that all job steps should have output files, no matter how mundane or simple…

Read more

0 comments, 451 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 March 2014

Working From Home

I have been working 100% from home for almost four months now,  and one of my former coworkers recently hit me with "How's it going working from home - I expected to see a blog post about it by now."


He's right - I had…

Read more

1 comments, 210 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 February 2014

T-SQL Tuesday #051: Always Hedge Your Bets

It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall.  Jason's chosen theme is Poker Face, asking us to describe situations where someone took a bet that was just a little too risky for our liking.


Read more

0 comments, 264 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 February 2014

The Next Phase of My Career

For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job as a Senior SQL Server DBA for Ntirety on their remote DBA team.  Ntirety is a top Remote DBA services firm that works in MSSQL, Oracle, and mySQL support.


Read more

0 comments, 266 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 November 2013

Hung SQL Server Restores from Tivoli Storage Manager/Tivoli Data Protection

I ran into this with a client last night when trying to restore their SQL Server data warehouse database from TSM.

We went through several iterations of the restore failing without any meaningful error other than a cryptic “TCP/IP Connection Refused” even though we could ping and telnet from the…

Read more

1 comments, 876 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 July 2013

New Page - "How to Get Involved With the SQL Server Community"

I recently composed an email (on the side) for a client DBA looking for info on getting involved with the community, looking for training, etc - and now I have turned it into a web page here on my blog - please check it out and please let me know…

Read more

0 comments, 323 reads

Posted in Nebraska SQL from @DBA_ANDY on 19 June 2013

I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits of that is getting to meet and interact with their team.  One of their team that I never really even knew of before he joined SQLskills was Joe Sack,…

Read more

1 comments, 367 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 May 2013

T-SQL Tuesday #42 - The Long and Winding Road

It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T).  Wendy's excellent subject is "the long and winding road" - changes in our work lives and how they impact us.

I am luckier…

Read more

1 comments, 374 reads

Posted in Nebraska SQL from @DBA_ANDY on 14 May 2013

Announcing SQL Saturday 197 Omaha Pre-Cons!

Here is a flyer produced by someone on the team - he says it all very well:


Friday, April 5, 2013
Get Warmed Up For SQL Saturday By Attending The Preconference!  

Three Great Speakers, Three Great Topics!


Scaling SQL Server 2012 (Glenn Berry - @GlennAlanBerry)

How can…

Read more

0 comments, 468 reads

Posted in Nebraska SQL from @DBA_ANDY on 7 February 2013

The Value of Certifications

A former co-worker recently sent me an email asking about Microsoft certifications, and if I pursued them, and what I thought about them.  I started to write a response and it sounded like a good blog post {-: so here it is:


I am certified through the gills in…

Read more

4 comments, 689 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 February 2013

Why is My New Server Under CPU Pressure?

Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in this TechNet article ( While a lower number is almost always better, it is a useful metric is to start paying attention to when the number rises over…

Read more

0 comments, 2,104 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 January 2013

Everybody Needs to Know About Recovery

My friend and SQL Server professional Tim Radney (blog/@tradney) has written a new entry in the Joes2Pros series:

You can get it from Amazon here for the low price of $9.99 - I ordered mine and will post a review when it comes, but I trust…

Read more

0 comments, 488 reads

Posted in Nebraska SQL from @DBA_ANDY on 1 November 2012

A Minor Problem of Access

A colleague sent this - they received a trouble ticket where a user who had "all access" to the database couldn't do anything:

Can you spot the problem?  :)

Read more

4 comments, 404 reads

Posted in Nebraska SQL from @DBA_ANDY on 19 October 2012

Why I Love the SQL Server Community

As many of you are aware, a SQL Server security patch came out this week (MS12-070 - Vulnerability in SQL Server Could Allow Elevation of Privilege).

No, security patches are *not* why I love the SQL Server Community - it's what happened next:

 The Security Bulletin (MS12-070) sounds like…

Read more

0 comments, 555 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 October 2012

Free Training Before the PASS Summit

How many of you out there get approval to go to the PASS Summit (YES!) but then get denied the $395/session to register for the pre-cons you wanted to see? (DARN!)

If you will be in the Seattle area Monday and/or Tuesday, there are a couple…

Read more

0 comments, 420 reads

Posted in Nebraska SQL from @DBA_ANDY on 1 October 2012

I voted in the PASS Election - you should too!

If you are a member of PASS you have probably already received an email that looks like this:


From: <>
Date: Fri, Sep 28, 2012 at 4:22 AM
Subject: PASS Votes: Your 2012 Elections Ballot

Dear PASS Member,
The future of PASS is in your hands. As…

Read more

0 comments, 856 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 September 2012

No more NebraSQL

After having too many people ask me what NebraSQL meant (its a play on words - Nebraska+SQL - get it?)  I have decided to give up on that attempt at being clever and just go to "Nebraska SQL from @DBA_ANDY" 

I have also updated the URL to - the…

Read more

0 comments, 524 reads

Posted in Nebraska SQL from @DBA_ANDY on 27 September 2012

Come See Us at SQL Saturday #165 in Lincoln!

I will be speaking with several of my House of Brick Technologies colleagues at SQL Saturday #165 in Lincoln in a couple weeks (October 6th):

I am giving my solo presentation on the Ola Hallengren Maintenance Solution and also co-presenting "Virtualizing Business Critical SQL Servers" with our SQL…

Read more

0 comments, 300 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 September 2012

SQL Saturday 154 Rocked - Great Job St. Louis!

This last Saturday (09/15/2012) I traveled to St. Louis to present at #sqlsat154.  My colleague David Klee (blog/@kleegeek) and I each had one session chosen to present - he spoke on Database Health and Performance and I spoke on the Ola Hallengren Maintenance Solution. …

Read more

2 comments, 475 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 September 2012

Going to Seattle for More SQLSkills!

Last April I experienced the most amazing training event I have participated in so far in my life (yet).

I actually got to go to a SQLskills Immersion Event - IE1 in Chicago.  I went with one of my House of Brick colleagues David Klee (blog/@kleegeek

Read more

0 comments, 447 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 August 2012

Newer posts

Older posts