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
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
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
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
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
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
I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the event. The great thing about reporting is that for the past few months I’ve been … Continue reading TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
Yesterday I mentioned the upcoming SQL Server 2008 R2 launch event, and today I’m going to bring up this months Minnesota SQL Server User Group (twitter) meeting. This month’s meeting will be sponsored by Fusion-IO. Besides the pizza and drinks, they’ll be discussing SSD and some of their products. If you want to get an … Continue reading Discover SSD… or PASSMN April Meeting (4/20/10)
It was bound to happen, a launch event for the upcoming release of SQL Server 2008 R2. This is a great thing because it means we’ll be able to play with the cool new toys in production soon and start getting our client’s upgraded. I do wonder though if there are talking dolphins in these … Continue reading Discover SQL Server 2008 R2
Strate SQL 