Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s the eighth post in the plan cache series. I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I … Continue reading Can You Dig It? – Find Estimated Cost
This past Wednesday I took a drive down to the Iowa SQL Server Users Group meeting. It was a bit of a drive but I got a chance to hang out with a fellow Digineerian on the way there and talk about solutions. I really enjoyed the meeting. There were probably 40 people at the … Continue reading Iowa PASS Presentation Materials
Last month, I published the 31 Days of SSIS blog series. As a conclusion to that series, I wanted to post a wrap-up post, but quite honestly I was a little out of steam on February 1. I wanted to thank those that have read or will read the posts in this series. It was … Continue reading 31 Days of SSIS Conclusion
A while back, I started a twitter list of SQL Server MVPs. I wasn't really sure why, but I just thought it would be interesting. After a couple months of putting it together, Rob Farley (Blog | @Rob_Farley) challenged me to see if I could find more than 100 current SQL Server MVPs on twitter. … Continue reading SQL Server MVP Daily Paper
This weekend, I was working on something that I will blog about later this week. As part of that, though, I needed to download a list of all of the SQL Server MVPs that Microsoft publishes. A few times back, I just cut-n-pasted these down to get them all out quick and dirty. After reading … Continue reading PowerShell: Download List of SQL Server MVPs
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has crept by, more like flown by, and that expo is now this month on February, 18th. If you are interested in learning more about SSIS then now’s the time to get registered. SSWUG is offering a … Continue reading This Month… SSWUG Free SSIS Expo
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with an introductory post. This series has been a collection of the things that I’ve picked up over the years in my work with SSIS. I figured I’d end this series with a best practice that I’ve not often … Continue reading 31 Days of SSIS – SSIS Naming Conventions (31/31)
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS chapter. For both nights the presentations seemed to go fairly well – especially given the e-mail requests for the presentation materials after the events. PASSMN Meeting Session: Error Logs and Deadlocks, Oh My Tired of … Continue reading Presentations Materials From Last Week
Almost time to wrap up the 31 Days of SSIS. We are down to just two more posts with today’s post being number thirty. If you’re behind on this series, check out the introductory post. This morning’s one day late twenty-ninth post went over the use of the Export Column transformation. Since we discussed that … Continue reading 31 Days of SSIS – Importing Execution Plans (30/31)
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still coming out. And if things go right, I’ll be caught up where I need to be by the end of the day. If you’re behind on this series, check out the introductory post. File Export Requirements When considering … Continue reading 31 Days of SSIS – Exporting Execution Plans (29/31)
Strate SQL 