T-SQL Tuesday #065 – Teach Something New (Roundup)

With Ed’s #sqlnewblogger going on and lots of regular #tsql2sday folks there was a big turn out this month for the topic of teaching something new. In no particular order:

• Russ Thomas (aka @SQLJudo) wrote about Memory Optimized Hash Indexes (say that five times fast)
• Jason Brimhall (aka @SQLRNNR) talks about extended events and the custom data types he can explore. This was certainly something I hadn’t looked at before.
• Steve Jones (The Voice of the DBA | @way0utwest) tells about an exception when using XML in computed columns. I’d love to see the follow-up post on how well this performs.
• Ed Leighton-Dick (@eleightondick) writes about PowerShell Providers and he took my admonition about giving us good content with screen shots to heart.

• Ken Wilson (@_KenWilson) Wrote about FMT_ONLY Replacements in SQL Server 2012 when you just want to see the Metadata for a query.
• Mike Fal (@Mike_Fal) creates an endpoint using PowerShell and in the typical #sqlcommunity way he learned something new when one of his commenters knew a different way to accomplish this same thing.
• Andy Yun (@SQLBek) shares some new things he learned about SQL Server Management studio at SQL Saturday Madison earlier in the month.
• Rob Farley (@rob_farley) lets us know about a quirk of the SHOWPLAN permission.
• Robert Davis (@sqlsoldier) overcomes Variable Limitations in SQLCMD mode and gives plenty of code snippets so we can replicate.
• Cathrine Wilhelmsen (@cathrinew) proves that everything can be new again. She writes up a post on the use of a Numbers table. I think she summed up how most people feel about numbers tables, “something I wish I had known about years ago.”
• Daniel Mellor  (@sqlsanctum) give us a straightforward post about APPLY that coincidentally builds on the idea of a numbers table.
• Kenneth Fisher (@sqlstudnet144) explains how to Remotely SHUTDOWN and Instance of SQL Server. With some caution added to only use when necessary.
• Aaron Bertrand (@aaronbertrand) puts together some great examples on how changing from NOT NULL to NULL might not be as simple as you think.
• Boris Hristov (@BorisHristov) teaches about the small but powerful NOEXEC Thing.
• Dustin (@nujakcities) took a complex framework, Slowly Changing Dimensions, and explained it succinctly in a single blog post with pictures and everything.
• John Morehouse (@sqlrus) wrote a detailed blog post on Failing Over your cluster using Powershell.
• Andre DuBois (@MtnDBA) has a blog post about the Sequence Object, which is one I enjoyed because it’s something I’ve been meaning to learn more about as well.

Also blogged that day ( I think these posts were supposed to be a part of the blog party as well, but they didn’t follow all the rules so I am just going to give them honorable mention. next time be sure to include the logo guys.)

• Ryan Lundahl (@sql_wizard) gives us a quick and dirty script for Searching SSRS Meta Data
• Aalamjeet Rangi (@AalamRangi) How to Have Standard Logging in SSIS and Avoid Traps

I really enjoyed reading the posts this month and I learned a lot of new things from all of you.