About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As a result, I had created the CodePlex project FileSystemHelper. I blogged about it back then and had meant to get back to it with a number of updates but that never really happened. Along the … Continue reading FileSystemHelper Update and Release
SSWUG Free Expo Event: Basic and Complex SSIS Features virtual conference is today! There’s a chance that you can probably still get registered and I’d recommend doing so. There will be four SSIS sessions that will cover a variety of topics, but you’ll get some of the following through the content: SSIS Sorting and Package … Continue reading SSWUG Free SSIS Expo – Today!
A few PASS Summit’s ago, I became interested in the information available in the Plan Cache. As part of that interest, I started digging into the plan cache to find out what is there and available to be pulled out. Some of those investigations led to a few presentations; which have in turn led to … Continue reading Can You Dig It? – Plan Cache Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog series on so-and-so!” It’s been done before, some examples are: Glenn Berry (Blog |@GlennAlanBerry) with A DMV A Day Paul Randal (Blog | @PaulRandal) with A SQL Server DBA Myth A Day Jonathan Kehayias (Blog … Continue reading Writing A Month Long Blog Series
Do you know about congenital heart defects (CHD)? Did you know that February 7-14 is the week dedicated to making people more aware of these defects? It is the last day of that week and I’d like to take a few minutes to dedicate a post to this issue. Every year approximately 1 in 125 … Continue reading CHD Awareness Week
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
Strate SQL 