What has two thumbs and just signed on to be a PASS Regional Mentor? This guy! Over the past couple weeks, I’ve been going back and forth with some e-mails with PASS. The result of which places me in the open Regional Mentor position for the North Central region. For a little history, this process … Continue reading There's A New North Central Regional Mentor
Here’s wishing you a Happy Pi Day… If my picture isn’t good enough, here’s a better representation of pi. Hope you didn’t forget about Daylight Savings if you are one of the those afflicted by this change in the time zone.
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek). The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries. A query … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday
Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences. It’s that time of the year again, and the next virtual conference is coming up in a few short weeks. The event will be on April 20-22 and you can attend from the comforts of your home or office. If … Continue reading SSWUG DBTechCon Coming Up
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
Strate SQL 