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

#SQLPASS: To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT

Capping off a fantastic third week of presentations (see #SQLSatSLC & #SQLSatOregon), I’m speaking Thursday 11/6/2014 at 1:30p at the Professional Association for SQL Server International Summit.  It’s an honor to be chosen to speak at this event for a fifth time.  This summit’s topic: To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned…

0

Spooked by Columnstore? See My Halloween Weekend Preso at #SQLSatOregon

This Halloween weekend I continue my efforts to make the world of SQL DWs a better place—one table at a time—via evangelizing Columnstore at #SQLSaturday337 in Portlandia.  Columnstore Indexes in SQL Server 2014: Flipping the DW /faster Bit If you’ve not been in a crypt since last All Hallows Eve, you likely know this is…

0

Two Presentations This Weekend at #SQLSaturday349 in Salt Lake City

I have the privilege of being selected to fill two slots this weekend at #SQLSaturday349 in Salt Lake City.  The venue is simultaneously hosting the Big Mountain Data event. My talks are: To the Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT & Columnstore Indexes in SQL Server 2014: Flipping the DW /faster…

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

Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

Preamble This is the second in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in my big deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to…

0

Columnstore Case Study #1: MSIT SONAR Aggregations

Preamble This is the first in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in this deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide…

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

MSDN Whitepaper: More Cowbell—Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

Hot off the presses is this new MSDN white paper: Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator One of the gems introduced in SQL Server 2014 is the Cardinality Estimator (CE)—new! improved! & now with more cowbell.  I’m thrilled to be a Technical Reviewer for a superb MSDN white paper authored…

0