Archives: September 2010
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me set the scene: One of the applications I support has had issues with deadlocks for some time now. The deadlocks are really a result of design issues that it… Read more
Not long ago Microsoft announced a new product called Azure AKA “SQL Server in the Cloud”. I have to say that when I first heard about the product I was skeptical. The problem I had is that I already have servers, lots of them in fact. I struggled to find… Read more
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is people that can either not explain what they mean in simple terms or that choose not to in order to appear knowledgeable. I still have a long way to go… Read more
The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices for fill factors on indexes actually does to the structure of those indexes. I have to give special thanks to Brent… Read more
I do not usually post a quote of the day but since this is my own quote I decided to share it.
Today is the first day of the rest of your life. Make it yours, own the day. Repeat tomorrow. This has been your wake up call.
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like most classes had at least 1 new thing for everyone to take away. The big takeaway for me was that I must disclose that I am employed by CDW when… Read more
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the stored procedure I am sharing is to move SSIS packages stored via SQL Server Storage from one server SQL 2005 server to another in a way that can easily be… Read more