Earlier this month Microsoft launched SQL Server 2008 R2. And then last week Microsoft release Cumulative Update 1 for SQL Server 2008 R2. You might might be getting serious like this baby thinking, “Really, already?!” The reality though is that this deserves a “YES!” Why would a quick Cumulative Update after release be such a … Continue reading And Here You Thought It Just RTM’d
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
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
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
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
Strate SQL 