Hello, World! Encore Edition aka Good-bye, Microsoft

Moving On After nearly nine years at Microsoft, I’ve chosen to move on. I’ve accepted a position at Fusion-io—now a SanDisk company—as Worldwide SQL Server Solutions Architect where I’ll be evangelizing, documenting best practices, collaborating directly with the Windows & SQL product teams & other partners, doing cutting-edge performance work, & of course flipping the…

0

Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit at #SQLSaturday347 / #SQLSatDC

This weekend on December 6, 2014 I continue my evangelization of Columnstore—possibly the most exciting unheralded feature in SQL Server 2014—at SQL Saturday 347 at an auspicious venue: the Microsoft Technology Center in Chevy Chase, proximal to the US capital city of Washington DC. Register, see the schedule, or see the event home page on…

0

AdventureWorks 2014 Sample Databases Are Now Available

  Where in the World is AdventureWorks? Recently, SQL Community feedback from twitter prompted me to look in vain for SQL Server 2014 versions of the AdventureWorks sample databases we’ve all grown to know & love. I searched Codeplex, then used the bing & even the google in an effort to locate them, yet all…

0

Why Certification Still Matters: The Why, The Journey, and Certification-fu à la Bruce Lee

MSIT People Aspirations Last year MSIT’s People Aspirations team asked me to share my Microsoft certification experiences. The team adopted a Bruce Lee meme which I weaved into my deck. This week the PowerPoint team deployed a bug fix enabling embedded YouTube clips (the Insert > Video command has been extant for years, but it…

0

Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not the Entire 2.5GB Windows 7 SDK: Part 1

Say It Ain’t So! In my first post on Xperf, I described the simple 4.4MB download necessary to install the Windows Performance Analyzer (WPA) & the other tools which comprise the Windows Performance Toolkit (WPT), including Xperf. I was surprised to learn that the toolkit is no longer available in a discrete download. The only…

1

A Rendezvous With Destiny: PASS 2009 (#sqlpass)

Rendezvous With Destiny Forty-five years ago, Ronald Reagan aka Ronaldus Magnus spoke to Americans of our rendezvous with destiny. In a few short days the SQL Community will rendezvous in Seattle for the PASS 2009 Summit. This time last year, eager & anxious, I was preparing for my very first presentation at PASS.  Those who…

2

Wait Stats Introductory References

Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new here.  However, if you’re a n00b, this is a great place to start. History As I commented here on SQL MVP Jason Massie’s blog, I first became aware of the importance of wait stats in an editorial for…

3

VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)

My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally. Now it’s time to spread my wings a bit & learn about Visual Studio Team System (VSTS) web testing.  Spread Your Wings! https://www.youtube.com/watch?v=JtsJDTyY95g My colleague & A.C.E. performance engineer Chris Lundquist has compiled a 6:58 wmv featuring his unscripted…

1

Drum Roll, Please…The Debut of The SQL DMV All-Stars Dream Team!

<#Author’s note: Though I originally posted this six years ago, it’s still one of my most popular posts.  I still use the queries & I’ve updated them a bit.  Enjoy!Jimmy May2015-01-14#> The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provides us with all manner of wonderful information, much of which was heretofore…

9