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.

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

0 comments, 121 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

1 comments, 254 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

2 comments, 133 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,472 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, 278 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

3 comments, 233 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, 329 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, 251 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, 481 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, 337 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, 127 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, 134 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, 250 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, 109 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

1 comments, 886 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, 84 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 June 2012

Presenting at SQL Saturday 119 Chicago!

First thing in the morning Saturday May 19th:


















I will be presenting with my colleague from House of Brick David Klee (@kleegeek/blog) on virtualizing critical applications.  We will have a VMWare focus, but the concepts are appropriate regardless of your virtualization vendor.

The list for SQL…

Read more

0 comments, 85 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 May 2012

Get Free Learning

A couple of different events going on today and tomorrow:

Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning" at the PASSMN monthly meeting.  

What's that you say?  You're not in Minnesota?

Darn.  Oh well...

But wait - PASSMN is one of the chapters that runs…

Read more

0 comments, 69 reads

Posted in Nebraska SQL from @DBA_ANDY on 20 March 2012

Help I'm not Sysadmin!


I am currently working on some client servers to upgrade multiple SQL 2008 R2 Express instances to 2008 R2 Standard.  On several of them, the only sysadmin is sa, and we don’t have the password.  BUILTIN\Administrators is only in dbcreator by the configuration in place, even though by the client…

Read more

0 comments, 101 reads

Posted in Nebraska SQL from @DBA_ANDY on 16 March 2012

T-SQL Tuesday #028 – Jack of All Trades, Master of None?


It's T-SQL Tuesday again, and this month Argenis Fernandez (@DBArgenis/Blog) is hosting with the topic of "Jack of All Trades, Master of None?"

This topic has become especially relevant to me in the past six months as I have left my previous life as an in-house…

Read more

1 comments, 89 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 March 2012

Older posts