Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
Contact the author
for this blog
We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM and MCA programs were dying. He almost immediately blogged the news: MS was canceling the Microsoft Certified Master and Microsoft Certified Architect programs, and it was all up…
Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV! You can get the slide deck and demo code here. This session stemmed from the recurring nightmare that is undocumented, unsupported code that…
Let’s hear a story. The story is true, but elements have been generalized and fictionalized for simplicity, and so’s not to call out any individuals. This story has happened several times, you see. Story Time A few years ago, an election was held for positions on the PASS* board. Several…
The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why I thought live coverage via social media, by individual eyewitnesses, is a wonderful thing. The room more or less agreed that print media is on the way out.…
It’s summer here in the northern hemisphere, and in Texas we’re getting 100F-plus weather pretty consistently. This brain-frying weather may help to explain how I managed not to bother letting anyone here on the Interwebs know that we were taking most of July and some of August off from all…
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…
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…
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.…
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…
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…
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…
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
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
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
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:
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
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
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.…
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…