Ever have a customer request that you take a backup of a database, a restore using that backup, and then tell you that it is the wrong data? Every now and then it happens, so I decided to put together some t-sql to display details on what was done. The script essentially details when the restored … Read more
OK everyone, bring it in for a minute. We had a great scrimmage last week against MS Access Community College. The Jets played tough, and we knew they would, and they showed us just how far we have to go this year. At this time of the season we are building our conditioning while we … Read more
I recently had (yet another) vendor product give my server amnesia. Yessir, just like before, a simple SELECT @@SERVERNAME was returning a NULL value. The net result of this is that anything written that depends upon @@SERVERNAME to return an actual value will not work. Now, last time this happened, I made a casual reference … Read more
Sometimes I feel as if all I do is direct people where to find the things they are looking for. Much like a signpost does. Now, I am not complaining about this. In fact, I want to be the signpost for others. I have no problem helping people find the information they need. And that … Read more
Everyone needs training. It does not matter what your level of experience. Everyone has room for improvement. The improvement could be something dramatic, such as going from being a novice to someone highly skilled. Or it could be that someone who is highly skilled wants to hone those skills even further in order to stay … Read more
Earlier this year I had the honor of co-presenting a session on index tuning with Brent Ozar. During that session I stressed the importance of observation when it comes to any kind of performance tuning. All too often I see people make the mistake of focusing on the duration of their queries as the only … Read more
