Apr 30 2010
#12 SELECT * Plain and simple this is a lazy habit that causes performance problems and possible code fail over the application lifecycle. That is all. “Explain myself” you say? Fine. Imagine you’re given a grocery list by your Significant Other that states: “Go to the Sunny Mart and buy everything. It’s exactly what we [...]
Apr 26 2010
#13 Being A Visible DBA At The Wrong Time I’ve given presentations where I state that one of the qualities of being a good DBA is being a visible one. The days of being a Database Administrator that sits in the smallest cubicle next to the noisy refrigerator and generally avoided by the rest of the [...]
Apr 23 2010
I give you exhibit A: The Last Straw: Yes, Third Party Software vendors out there are still trying to ruffie our SQL Servers. I encountered these instructions yesterday when reviewing a pending installation process. What you don’t see here though are items 1-11 in their instructions (one being a requirement for [...]
Apr 21 2010
First of all I can’t take credit for this. The credit for what I’m about to show you comes courtesy of Steve Jones and the crew of 1,000s over at SQLServerCentral. When I stumbled across this today I felt like Charlie Sheen on a bender in Amsterdam. What am I talking about? Well, it’s about turning SQL Server Management Studio [...]
Apr 16 2010
As always seems to be the case I’m still changing up my newest presentation right up until the last minute. Yes, tomorrow I’ll be delivering two presentations here in Elk Grove, IL – where apparently the 1970′s never came to an end according to the bar I’m sitting in now surrounded by Teamsters and locals [...]
Apr 9 2010
I often rail against Third Party Vendors in my posts here and also on Twitter and on any other virtual stump I can climb onto. It is refreshing when I have conversations like I just had with a technical representative from a software developer whose product we have purchased and used for a number of [...]
Mar 21 2010
Test post using WordPress on Droid. Quite often these terms are bandied about interchangeably and therefore incorrectly. Perhaps it’s a good first full post for SQL N00B CREW training if we discuss the differences. Login: a instance-level object that serves as the identity of the individual interacting with SQL Server. User: the database-level identity object [...]
Mar 18 2010
Inspiration leads to perspiration. I’m developing my first presentation as part of my initiative to train those just entering the enticing world of SQL Server database administration. I’m having difficulties maintaining the priciples of KISS (Keep It Simple Stoopid) in that I want to cram so much into the presentation that I’m defeating the purpose [...]
