The new year is just around the corner. And before you know it, we’ll have an opportunity to start moving SQL Server 2012 into production. While we anxiously await that day, it is a good idea to make sure that you are up on the latest T-SQL enhancements that are coming in the next release. … Continue reading December AppDev Webcast
This month for #MemeMonday, Thomas LaRock (Blog | @SQLRockstar) has assigned a topic with a holiday bend to it. The question for today is “What gift we want from Microsoft to be left under the tree?” Some Ideas That’s a bit of a hard one. For starters, I could ask for one of those delayed … Continue reading December #MemeMonday
It's the first Monday of the December, and it's time to do a monthly checkup. As previously mentioned, the premise of this post is to help DBAs maintain their environments by getting together a monthly checklist and running through it every month. Now, if you were paying attention last month, you would have noticed that … Continue reading December Monthly SQL Server Checklist
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about. If you have some free time or interest, … Continue reading Re-blog – November 25 – December 1
SQL Server 2012 is coming to 12 cities next year. Is your city on the list? It can be – or could be – take a few minutes to complete the survey at http://www.specialopstour.com and you will help determine where the tour will be heading. Personally, I hope everyone puts in Minneapolis, MN – but … Continue reading SQL Server Special Ops
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers back to the forefront to share what has already been shared. If you have some free time or interest, check out the links below from years past to see what you may have missed. … Continue reading Re-blog – November 18 – November 24
You can find the slides and scripts from today's sesson at the SSWUG SSIS Expo, the materials can be downloaded from the link below: [download id="51"]
I’ll be posting a summit wrap-up after I return next week from my honeymoon. Until then, though, I wanted to make sure that anyone that wanted them, had the materials I used in my presentation. [download id="50"] Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can … Continue reading PASS Summit 2011 Session Materials
Since I put up the lyrics for “SQL and I Know It”, it only makes sense to continue the tradition and give you all the lyrics for the latest song. Of course, this is questionably “music” but at least they entertain me. When I first started doing all of these posts, this was actually the … Continue reading Lyrics for “Hold On”
A couple weeks back, I drove out to Madison to present at the MADPASS user group. These guys have a great setup for recording and broadcasting their meetings. Unfortunately, my laptop did not cooperate with the event and the broadcast of my session didn’t go so well. To help get the content out there, I’ll … Continue reading MADPASS Follow-Up
Strate SQL 