SQL Server Performance, Best Practices, & Productivity
In the latest-&-greatest effort in my mission to deliver my Columnstore presentation to every geekly denizen of the SQL community on the Northleft Coast of the United States & beyond, I’ll be delivering this week to the Oregon SQL Server User Group.
Though Columnstore indexes were introduced in SQL Server 2012; they're still largely unknown. In 2012, some adoption blockers remained; yet Columnstore was nonetheless a game changer for many apps. In SQL Server 2014, potential blockers have been largely removed & Columnstore is going to profoundly change the way we interact with our data.
Here’re the logistical details:
Title: Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit Group: Oregon SQL Server User Group URL: http://osql-d.org Twitter: @OSQLd Location: 1515 SW 5th Avenue, Suite 900, Portland, OR 97201 (downtown Portland in the ninth floor conference room of OHSU IT Group) Time: Wednesday evening April 9, 2014, 6:00p
Thanks to MVP Arnie Rowland (b|t) for the invitation as well as Vern Rabe & Paul Turley (b|t). As I understand it, there’ll be several MVPs & MCMs there. No pressure—and with luck, there’ll be no Stump-the-Chump.
I’m bringing a copy of the following for one lucky attendee: Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton (b|t), Rob Farley (b|t), Glenn Berry (b|t), Justin Langford (b|t), Gavin Payne (b|t), Amit Banerjee (b|t), with contributions & reviews from other big-time geeks such as Robert Davis (b|t) & Mike Anderson (b).
Jimmy, good luck tonight with your presentation! I wish I could fly over from Boston to benefit from your need to do the Columnstore Index Safety Dance for all, but the jet is down for index maintenance ;+) Any chance we unluckies might be able to experience the deck or a video of your presentation? Thanks for all the work you've done over the years, I've benefited greatly from reading what you've been so willing to share.
Great presentation. Thank you for making the trip.
@Adam: The deck & some demos are posted here on my blog:
Let me know if you have any questions, I'd be happy to help. And thanks for the kind words, I appreciate it.