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

TRY, CATCH, and Transactions

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood, so let’s talk about the basics. (Or, you can skip to the summary at the end.) A group of Transact-SQL statements can be enclosed in a TRY block. If an…

Read more

5 comments, 1,033 reads

Posted in SQL Awesomesauce on 20 June 2013

Why should we upgrade off of SQL Server 2000?

A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted on Twitter, SQL Server 7.0 and 6.5) . If you’re one of those companies, and you’ve never had a problem with it, why should you upgrade?1, stability: It’s completely out…

Read more

5 comments, 467 reads

Posted in SQL Awesomesauce on 13 June 2013

We’re speaking at PASS Summit 2013!

PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back for part two: Mouth Wide Shut: Interviews from the Other Side of the Table. This is our brand-spanking-new session for the interviewERs…those who question, vet, and rant about it afterward.…

Read more

0 comments, 237 reads

Posted in SQL Awesomesauce on 22 May 2013

My 2013 SQL Saturday Schedule!

I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m speaking at, or that I’ve submitted to, or are considering submitting to! I’ll update this list as plans solidify: 5/18/2013 – Atlanta - Scheduled to speak. 8/3/2013 – Baton Rouge…

Read more

0 comments, 320 reads

Posted in SQL Awesomesauce on 16 May 2013

Use Powershell to find and punish – er, delete – rogue files

I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I run a quick check of sys.master_files: SELECT LEFT(physical_name, 1) as Drive, SUM(size)*8/1024 as SizeMb FROM sys.master_files GROUP BY LEFT(physical_name, 1) ORDER BY Drive; And then I compare the numbers…

Read more

0 comments, 708 reads

Posted in SQL Awesomesauce on 13 May 2013

Quick Tip: Navigating to a UNC within SQLPS

I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the moment that the script is simply “cd \\backup\SQL; dir *.bak” The error information returned by PowerShell is: ‘Cannot find path ‘\\backup\SQL’ because it does not exist. The script…

Read more

1 comments, 346 reads

Posted in SQL Awesomesauce on 6 May 2013

Quick Tip: Where’s my SQL Server Job History?

Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on schedule, but many of them show no history. You look around, and there doesn’t seem to be a nightly job history purge (you’re looking for something with “sp_purge_jobhistory“).… Read more

0 comments, 337 reads

Posted in SQL Awesomesauce on 29 April 2013

In which we compare CISPA to Rick Astley

Wherever you click, either CISPA or Rick Astley is there…

I’m studying up on CISPA for a segment on our webshow.  Even though you’ve heard CISPA and SOPA and PIPA and online privacy so many times it’s like an audible, political Rickroll….even so, you should give a great big rat’s… Read more

0 comments, 249 reads

Posted in SQL Awesomesauce on 20 April 2013

Remembering Alan Weber, @Aauugold

We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone smart and funny, and I’m not remotely qualified to write his tribute…I only met him once or twice.

Last week, we saw Alan enter the chatroom mid-show, and we… Read more

2 comments, 331 reads

Posted in SQL Awesomesauce on 5 April 2013

The New MidnightDBA.com is live!

GUYS! GUYS! GUYS!!!  We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for, for the last few years quite some time now.  The site is in early version, “just get it working right” mode. But you will notice:

Read more

1 comments, 320 reads

Posted in SQL Awesomesauce on 2 April 2013

T-SQL Tuesday #40 Roundup: Files and Filegroups

Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect it’ll go get itself a fast car in the upcoming months.

We had a great turnout for this month. “Files and Filegroups” is an open enough topic that I got… Read more

1 comments, 409 reads

Posted in SQL Awesomesauce on 18 March 2013

Twitter Talk Theatre, Episode 1: “RAID is good enough!”

But We’ve Never Had a Disaster Before!

This week, some of my Twitter followers were kind enough to chime in on a topic near and dear to my heart: the proper caretaking of SQL Server. Here is some of what we said.

Me: Common scenario: A company has databases, but… Read more

3 comments, 354 reads

Posted in SQL Awesomesauce on 7 March 2013

Invitation to T-SQL Tuesday #040: File and Filegroup Wisdom

Hello and welcome to the third T-SQL Tuesday of 2013!

Over three years ago, Adam Machanic (Twitter) dreamed up the idea of T-SQL Tuesday:

Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted.…

Read more

6 comments, 333 reads

Posted in SQL Awesomesauce on 5 March 2013

FileTable: SQL Server 2012's little gasp-maker

When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”?  Was it around March of last year? No? Then you might have missed something really, really cool.

Let me introduce you to my friend, SQL Server 2012′s FileTable.

A Brief History…

Read more

6 comments, 1,075 reads

Posted in SQL Awesomesauce on 2 March 2013

We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)

Your MidnightDBAs

Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting podcast Thursday Feb 28, 2013 at 9:30PM EST here. You know, if you want to.

Onward!

-Jen McCown
http://www.MidnightDBA.com/Jen

Read more

1 comments, 425 reads

Posted in SQL Awesomesauce on 27 February 2013

23 Pieces of News and Fluffery (Feb 9-15)

I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s no way I can get to everything that’s happened in the last few days! So, here’s your weekly news update.

Actual News

CISPA is back, as I mentioned… Read more

1 comments, 356 reads

Posted in SQL Awesomesauce on 15 February 2013

#CISPA’s Coming Back: Time to Pay Attention Again

Update: The President’s cybersecurity Executive Order was  signed and released today (see the Wired article). “Although the order comes after a number of failed attempts by Congress last year to pass cybersecurity legislation, the White House has indicated that it doesn’t see the executive order as a substitute for… Read more

1 comments, 420 reads

Posted in SQL Awesomesauce on 12 February 2013

Install .NET Framework using #Powershell (#TSQL2sday!)

One of the really great things about being married to an MCM is that I can steal recycle his blogs, blame-free. Which is what I shall do today.

Sean wrote a great blog post in 2010 entitled “Today’s Powershell Fun“. Long and short, he shows you how to… Read more

0 comments, 560 reads

Posted in SQL Awesomesauce on 12 February 2013

Clustering Concepts for the Common Man

SQL Server clusters are widely used, and widely misunderstood, which makes people like our good friend (and clustering MVP) Allan Hirt cry bitter tears. So here are a few notes for you and yours.

Cluster IS NOT Disaster Recovery

A cluster does not protect against disaster. Unless it’s a very,… Read more

2 comments, 539 reads

Posted in SQL Awesomesauce on 29 January 2013

Talking on Purpose

Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This was in some part due to many lessons I’ve learned over the years – everything from business and sales to storytelling and obsessive-compulsive record keeping.

But to a far greater… Read more

0 comments, 490 reads

Posted in SQL Awesomesauce on 10 January 2013

Newer posts

Older posts