Last week I spoke at TechFuse 2010 and my topic was Getting to Know Your Indexes. I thought I’d throw up a link to the presentation materials from the event. TechFuse was a lot of fun and I got to spend some time chatting with Dan English (twitter | blog) and Lara Rubbelke (twitter | … Continue reading TechFuse Presentation and Speaker Rankings
Free SQL Server Training – Week May 2010
We all like free stuff. Especially when we already know it’s something we love. And if you are reading this blog, you likely love or really like SQL Server. Or just maybe you are paid to like it. What ever the reason, the more you know about it the better you will be in applying … Continue reading Free SQL Server Training – Week May 2010
Searching for Plans
A while back I wrote a post on a procedure I created for the DBADiagnostics database that I talk about from time to time. This procedure allowed users to search the procedure cache to find plans for procedures by database name and object name. This had worked out pretty good until I noticed something the … Continue reading Searching for Plans
Changing A Performance Counter Log Format
Ever come across performance counter log that isn’t in your desired format? This is a situation I’ve been in a number of times. And wouldn’t you know, I usually space off the command line tool that I can use to do this. The gem of a tool that you can use to change performance log … Continue reading Changing A Performance Counter Log Format
A Jack Bauer Event In The Making
Sure, you could say that making a Jack Bauer reference for the 24 Hours of PASS event is corny and expected. But then you’d be right and I’d have to actually use my creative juices. So we’ll agree on a détente of sorts and just move ahead. Coming up next month… on May 19 beginning … Continue reading A Jack Bauer Event In The Making
The Power of N
A peer the other day was having some trouble storing some some Chinese characters in a database. Every time he would insert the data into his table, the results would look similar to the following. The phrase he was adding was similar to the following: 烟肉独角兽彩虹乳酪 The T-SQL he was using was forwarded to me … Continue reading The Power of N
Chapter Review – MVP Deep Dive Chapter 11
A few weeks back I was asked it I'd be interested in reviewing a chapter in SQL Server MVP Deep Dives. Of course, since I was already reading the book I thought it'd be a good idea. My review on Chapter 11 - SQL Server Frequently Asked Questions can be found over at sqlperspectives. If you like … Continue reading Chapter Review – MVP Deep Dive Chapter 11
SQL Saturday Chicago Recap – #SQLAwesome
The single word that best describes this past weekend is… awesome. While there were some occasional bumps in the road - Wendy Pastrick (blog | twitter), Ted Krueger (blog | twitter), and Aaron Lowe (blog | twitter) deserves major props for putting this together. Outstanding job! There were a couple lumps so I’ll get those … Continue reading SQL Saturday Chicago Recap – #SQLAwesome
Free eBook – Introducing SQL Server 2008 R2
SQL Server 2008 R2 eBookAs with previous releases of SQL Server versions, Microsoft has released an "introducing" ebook that covers the new features that are a part of SQL Server 2008 R2. If you aren't up to speed with the upcoming release, this is a great resource to give it a once over and understand … Continue reading Free eBook – Introducing SQL Server 2008 R2
FileSystemHelper SQL Server CLR – Codeplex
A while back I decided I need to get down to brass tacks and figure out SQL Server CLR. I'd looked at examples and seen some pretty cool stuff being done with it. Unfortuantely, I hadn't taken the time to become acquianted enough to know enough about the unknown. This limited my ability to be able … Continue reading FileSystemHelper SQL Server CLR – Codeplex
Strate SQL 