Archive for March, 2009

Chris Hansen Should Be a DBA

Thankfully I had yet another cross country flight yesterday. Why thankfully? Because the travel gives me ample time (and booze) to think about things like “If there was a DBA reality television show, what would it be like?” I started with the basics, something in a Survivor format, maybe a Big Brother, or The Apprentice, [...]

When To Use Auto Shrink

Never, that’s when.
Don’t want to believe me? Well then, who would you believe? How about the SQL Craftsman, a man with more MVP-ness than myself.
What’s that? Not good enough for you? Well, then, let me introduce you to Paul Randal. He had some thoughts on the subject.
http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx
http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx
So why is this still an option? I don’t [...]

Global Currency

There has been talk in the news this week regarding the idea of having one unified global currency. I have no idea if that would ever come to fruition or not, but it did make me think about a lot of different sci-fi stories. Most of them refer to currency as “credits” or something similar [...]

PASS Summit Website Is Live!

The 2009 PASS Summit website is now live. You can find it at http://summit2009.sqlpass.org/
The new website has all of the details you need for the upcoming Summit. One change you should be aware of are the new dates. We have moved from the traditional Wednesday through Friday format and the conference will now run from Tuesday [...]

PASS Call for Speakers Now Open

Did you want to speak at the upcoming PASS 2009 Community Summit? Well, now is your chance! The call for speakers went out today and you can find all of the details at
http://www.sqlpass.org/Community/SpeakerResource.aspx
The deadline for submission of abstracts is April 10th, so do not put this off any longer. Get motivated and submit your ideas as [...]

AAPWYGOA

“Amaze Another Person With Your Grasp Of Acronyms”
Whenever I think of people that abuse acronyms I always think of this: http://www.youtube.com/watch?v=6UqqjEeWP9Y
I am always impressed confused when people talk to me using acronyms as if I am supposed to understand everything. Perhaps it was all those years I spent teaching math to some very disinterested college [...]

Upcoming AppDev SIG Presentation

On Tuesday March 31st Jeremiah Peschka will be presenting a session for the Application Development SIG titled “Dynamic SQL: What’s All the Fuss About, Anyway?”. The time is set for 1PM EDT (1700UTC). When the livemeeting details are final I will post them here as well.
For a list of other SIG events, visit the SIG [...]

NOCOUNT and User Options

Recently we had a vendor suggest to us that we turn off the option for NOCOUNT on their database. Upon hearing this my first question was, naturally, why? What was the issue such that they would say they wanted this turned off for their database(s)? Those questions were immediately followed by, naturally, how? How do [...]

SQL 2008 Book by Grant Fritchey

Grant Fritchey’s new book is now available on Amazon, you can order it from the link below.
SQL Server 2008 Query Performance Tuning Distilled
I have know Grant for a few years now and have always been impressed with how he able to dissect query plans as well as his overall performance tuning abilities. This is a [...]

Something Old, Something New…

Something smells rotten in Denmark (it’s probably all that cheese).
This past weekend I started thinking about what it really means to have your databases hosted in the cloud. My first thought was that it struck me as being exactly the same as an Application Service Provider. I mean, MS SQL is an application, right? And you [...]