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.

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.

Why…

Read more

0 comments, 181 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, 495 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, 258 reads

Posted in Nebraska SQL from @DBA_ANDY on 19 June 2013

SQLPerformance.com

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, 275 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, 274 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, 400 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, 564 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 (http://technet.microsoft.com/en-us/magazine/hh781189.aspx). 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, 1,822 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, 409 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, 340 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, 467 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, 354 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: <hq@sqlpass.org>
Date: Fri, Sep 28, 2012 at 4:22 AM
Subject: PASS Votes: Your 2012 Elections Ballot
To: andyhusker@gmail.com


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

Read more

0 comments, 671 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 nebraskasql.blogspot.com - the…

Read more

0 comments, 469 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, 227 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, 343 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, 379 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 August 2012

SQLSaturday 159 - KC Can Sure Throw a SQL Saturday!

This past weekend was SQLSaturday159 - Kansas City.  I drove down with my wife and our sons (2 years old and 11 months old) and spent the first day sightseeing (Union Station & Crown Center) and scaring the wits out of our 2-year-old (T-Rex Cafe - he…

Read more

2 comments, 262 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 August 2012

Licensing SQL Server Dev/Test Environments

I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and testing (they call it staging) environments.  The client said that they purchased regular licenses for their staging environment but that they had MSDN Professional (“Visual Studio Professional with MSDN”) licenses…

Read more

3 comments, 3,499 reads

Posted in Nebraska SQL from @DBA_ANDY on 27 July 2012

Speaking at SQL Saturday 159 in Kansas City!

Come to Kansas City on August 4th for SQL Saturday 159 and hear us speak!




At 2:30pm, I will be speaking with my House of Brick Technologies colleague David Klee (B/T) on Virtualizing Business Critical SQL Servers - this is the marquee topic for our employer,…

Read more

0 comments, 197 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 June 2012

Newer posts

Older posts