Microsoft has released a few new Cumulaive Update for SQL Server. There is an update for each of the supported releases of SQL Server: Cumulative update package 10 for SQL Server 2005 Service Pack 3 Cumulative update package 8 for SQL Server 2008 Service Pack 1 Cumulative Update package 2 for SQL Server 2008 R2 … Continue reading Do You Patch SQL Server Regularily?
Today started with some quality time getting to know a deadlock that had occurred. While working through the deadlock, I noticed that there were a number of foreign key relationships that weren't indexed on the parent side of the relationship. I am going to skip over the why to index foreign keys and save that … Continue reading Index Those Foreign Keys
Go get the popcorn and let's get ready to watch some PASS sessions! Last month PASS hosted an event called 24 Hours of PASS. In this event, there were 24 back to back webcasts that focused on SQL Server and more specifically SQL Server 2008 R2. As if that weren't awesome enough, you can now … Continue reading You Thought You Missed 24 Hours of PASS
I was a little slow at submitting this year, but this afternoon I submitted my ideas for sessions for PASS Summit 2010. If you aren’t aware of this conference – it’s probably the best way out there to learn a ton about SQL Server while networking with the people that use it daily and helped … Continue reading PASS Summit 2010 Submissions
I like my name. It provides a point of reference to who I am. If I am at work and someone calls for “Jason Strate”… that’s me. If I am at home, the same thing can happen and I still know that it’s me. I know that no matter where I am, my name will … Continue reading Doing Something About Auto Generated Names
I like using raw files in SQL Server Integration Services (SSIS). They are a quick way to build data repository that will be used else where in a package or for use with a separate package. In a recent project, raw files were used to move client data around in a new import process that consolidated business logic … Continue reading Connect Item on Import/Export Wizard
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
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
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
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
Strate SQL 