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.

Archives: March 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, 469 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, 633 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, 947 reads

Posted in Nebraska SQL from @DBA_ANDY on 13 March 2012

Double-Dash Comments, the Hidden Menace

While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a presentation once (and unfortunately I can't remember who said it) that has stuck with me for the last several years:

Word Wrap is Your Enemy.

Why is this?  If you…

Read more

0 comments, 1,612 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 March 2012

Cleaning up Old Maintenance Plans

This is something I trip over every now and then on systems we inherit from our clients, and I thought I would write it up in case it helps someone else {-:

In the most recent case, I was looking at a SQL Server 2008 server that had been upgraded…

Read more

1 comments, 480 reads

Posted in Nebraska SQL from @DBA_ANDY on 12 March 2012

A Little Feature Self-Deprecation

The buzz started yesterday, with the rumblings about Database Mirroring showing up on the "Features Not Supported in a Future Version of SQL Server" list for SQL Server 2012 in the wake of the release of AlwaysOn, with multiple blogs and tweets about it (including a blog from…

Read more

0 comments, 903 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 March 2012

Database Mirroring Deprecated in SQL 2012

From the newly released SQL 2012 Books Online documentation:

This note shows that as of SQL Server 2012, which will be Release-To-Manufacturing (RTM) effective 04/01/2012, Database Mirroring will be marked as deprecated.  What does this mean?  As the note states, the feature will be removed in…

Read more

0 comments, 2,507 reads

Posted in Nebraska SQL from @DBA_ANDY on 9 March 2012

Clearing Job Notifications - HELP!

I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the existing notifications on all jobs and then set up new notifications on only a subset of jobs.

Sounds easy right?

Wrote a cursor (gasp) to loop through the jobs and…

Read more

2 comments, 719 reads

Posted in Nebraska SQL from @DBA_ANDY on 2 March 2012