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 does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing multiple failovers when they performed routine Windows patching.

The client's request which generated the work ticket was this:

At some point recently this clustered node failed over from the A…

Read more

1 comments, 76 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 April 2014

I Know I Shouldn't Shrink My Log file, BUT...

As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it, as *any* DBA you spend time cleaning up other people's mistakes...)

We all know you shouldn't shrink your log file (right?  We all know this, right?) The experts constantly preach…

Read more

4 comments, 864 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 April 2014

We Are Hiring!

My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's.  As you have probably seen from me on Twitter (or on this blog) previously, I joined Ntirety last November as a 100% work-from-home Senior SQL Server DBA.

Ntirety is based out of Boston, but…

Read more

0 comments, 123 reads

Posted in Nebraska SQL from @DBA_ANDY on 31 March 2014

Backup Checksums and Trace Flag 3023

One of the items I always flag when performing a health check on a server is whether backups are being run with CHECKSUM enabled.  As Paul Randal (@PaulRandal/blog) writes in his post "Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums…

Read more

1 comments, 959 reads

Posted in Nebraska SQL from @DBA_ANDY on 25 March 2014

Error 701 - Insufficient System Memory - Now what?

This story begins, as so many often do, with a few key elements:
1) A client who experienced a problem on Thursday and waited until Friday evening to report it, even though the problem was "critical" enough to ask us to work on it all weekend if we couldn't solve…

Read more

0 comments, 1,172 reads

Posted in Nebraska SQL from @DBA_ANDY on 20 March 2014

A New Day at #Ntirety

We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network services provider based out of Denver, CO.  Apparently Hosting did not have a database services division and decided it made more sense to buy one than to…

Read more

1 comments, 92 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 March 2014

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, 126 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."

HASHTAG GuiltTrip HASHTAG Sigh

He's right - I had…

Read more

0 comments, 24 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.

When…

Read more

0 comments, 66 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.

Why…

Read more

0 comments, 130 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, 417 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, 224 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, 236 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, 242 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, 363 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, 524 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,745 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, 370 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, 314 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, 427 reads

Posted in Nebraska SQL from @DBA_ANDY on 11 October 2012

Older posts