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

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

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

SQLIOSim Parser by Jens Suessmeyer & Yours Truly

New! Improved! v.3.3.0 Now Available on CodePlex!  Preamble SQLIOSim Parser shreds the results of SQLIOSim.log.xml in seconds, allowing easier & more accurate interpretation of the output of SQLIOSim. SQLIOSim is a tool written by CSS Engineer Bob Dorr.  Many of you know Bob from the excellent insights he shares on the CSS SQL Server Engineers blog. …

4

Aspiring Geek Speaks This Week Yet Again: Perpetual Technologies (PTI) Back-to-School with Microsoft and Oracle Event

Yesterday I flew to Minneapolis to speak at PASS MN on disk partition alignment.  I left for the airport immediately afterward to get home to Indianapolis in order to speak at Perpetual Technologies, Inc. (PTI) 2nd Annual Back to School with Microsoft & Oracle Event. PTI is home to some great folks, including my friends…

0

Aspiring Geek Speaks This Week: PASS Minnesota

Greetings, my current colleague & former MVP Lara Rubbelke (blog | twitter) was gracious enough to invite me to speak this week at PASS Minnesota aka PASS MN. I’ll be reprising my spiel on Disk Partition Alignment, the Best Kept Secret in SQL Server I/O Performance.  For more details, see PASS MN’s September Meeting or…

0