Bonus Post: My PASS Schedule

I’ll be speaking again at PASS this year, and I’m heavily involved in the event when I’m not speaking. I would love to meet you – if you’re a reader of this blog, please stop by and say hello! As of right now, here’s where’s I’ll be: Tuesday: 11:00 AM – 2:00 PM Ask the…


Quote of the Day: What is Impossible

When I worked at the Space Center in Florida, one of my favorite quotes was posted over a particular rocket engine display near my office. It’s by Werner Von Braun, a German scientist who is largely responsible for the Redstone and Apollo Space Programs. It continues to inspire me today: “Always use the word ‘Impossible’…


Don’t be a DBA – Be a Data Professional

I get asked quite frequently now about the “Cloud” technology and how it will affect the job of the DBA. The answer to that is pretty easy: If you’re “just a DBA”, then it will affect you a great deal. The fact that someone else will add users, take backups and worry about uptime might…


Templates for New Query Window

When I’m in SQL Server Management Studio and I click the “New Query” button, my Query Window comes up like this: /* <ScriptFileName, SYSNAME, ScriptFileName>.sql Purpose: <Purpose, SYSNAME, Purpose> Author: <Author, SYSNAME, Buck Woody> Last Edited: <LastEdited, SYSNAME, LastEdited> Instructions: <Instructions, SYSNAME, Instructions> References: */     /* End <ScriptFileName, SYSNAME, ScriptFileName>.sql */ Then I…


Disaster Response and the Physical Plant

Near our home is a Dam about to break. It was built long ago, and even though millions were taxed and spent for it, little to none of that money ever got to the actual shoring up and maintaining the dam  over time (don’t get me started). Anyway, it’s in sad shape, and an entire…


How Normal(ized) Should You Be?

Normalization is the process of removing repeating values from your data design, and ensuring that the values depend on the Primary Key in the table. OK, it’s a bit more complicated than that, but this definition will do for this post. So how far DO you normalize? Consider the following: Name, Address, City, State, Zip….


Women and Cats

I will not explain why I chose this quote for today (it could have to do with the fact that I’m the only male in the house and yes, we do have a cat): “Women and cats will do as they please, and men and dogs should relax and get used to the idea.” –…


New Business Metric: DBOM

With all of the travelling, writing, speaking and working I’ve been doing lately, I’ve come across a new trend. My schedule is so fragmented that I communicate primarily through e-mail, and I’ve noticed that I respond to, and hear back from, various people in various tiem increments. Because of the flights and travel time, I’m…


The 20 Queries

In the book “The Fourth Paradigm”, Jim Gray describes the modeling process he came up with modeling large databases. He was working with scientists, researchers and others, and the data sets they were generating were huge – terabytes of data at a time. To even come up with an entity model was a daunting task,…


The Fourth Paradigm

Microsoft Research published a book based on Dr. Jim Gray’s research into Computer Science, called “The Fourth Paradigm”. It’s about 300 pages long, and it fascinated me so much I stayed up reading it last night. I have so many notes to decompress it will take me weeks. If you’re a data professional, I highly…