Officially disguised as a Canadian
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because they are based on DMVs and catalog views built into SQL Server 2005 and higher. With her permission, I haveContinue reading My brain hurts
There are words that can accurately describe how I’m feeling right now. These would include exhausted, drained, tired, sleepy, somnolent, and soporific. Then there are other words that can describe my state of mind, which would also be accurate: inspired, grateful, excited, awed, amazed, and invigorated. The latter have resulted in the former, and whileContinue reading My first week of three with SQLskills Immersion Events
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. His blog has a walkthrough in SQL Server Management Studio if you prefer the GUI. [Note: If you copy and paste this code, please be sure to check the quotation marks. WordPress may changeContinue reading Increasing SQL Server Error Logs
Happy new year.
Good news, all three of you that follow this blog and are interested in my ShutOff application: it’s almost done! Luckily it hasn’t taken me over twelve years to get to this point! Last week I realised that twelve years brings with it a new era: the death of anything before Windows XP, and theContinue reading ShutOff 2000 Update
Today at the clinic, we did the second of three phases of network reorganisation. In the first phase, which we completed a week ago, our new server was set up with the EMR software, all data was migrated from the old server, and the vendor remoted in to make sure everything was up and running.Continue reading What I did today
Thus far I have made it through 11 of the MCM videos on SQLSkills.com, as well as the associated demos. There is a large amount of information in these videos, and I’ve been learning a lot. The point of this training next year is to fill in the blanks. I consider my T-SQL skills forContinue reading SQL Preparation, Part the Second
As I noted in a previous entry, I’m going to be upgrading my SQL Server knowledge with the best minds in the business, in early 2012. To prepare myself for this training, I’m planning on going through the 40+ hours of videos that are provided for MCM training, as well as two of the requiredContinue reading SQL Preparation, Part the First
In February and March 2012 I’m taking a trip to Tampa FL to attend three weeks of in-depth SQL Server training, provided by Paul Randal and Kimberly Tripp, those legends of the SQL world. I cannot wait.
I’m off Facebook. I joined in (I think) 2006 and after the latest changes, combined with their increasingly bizarre opinion on privacy, I decided to run for the hills. The hills of Google+. Ironically, I wrote an article some time ago about Google and its potential to know everything about you. I may have evenContinue reading Google+