Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed using functions within XQuery with the Substring() function as part of the XQuery for the Non-Expert blog series. To continue on that theme, this post is going to take a look into … Continue reading XQuery for the Non-Expert – Aggregates
If you’re looking for a day of training in the Twin Cities, then check out Benchmark Learning’s 2011 TechFuse event. The event features eight tracks of sessions from infrastructure and developer topics to, of course, SQL Server topics. The event is on March 17, 2011 at Mystic Lake Casino – if you are interested in … Continue reading TechFuse 2011 – This Month
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
Strate SQL 