Columnstore Indexes in SQL Server 2012
One of the new features of SQL Server 2012 is columnstore indexes, where the storage of index data is “turned on its head”, resulting is some great performance improvements. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, its current limitations, and how to work around some of those limitations.
Vern Rabe (Blog | LinkedIn) Vern has 18 years of experience in database architecting, implementation, and maintenance, on both OLTP and dimensional model environments. As a Microsoft Certified Trainer, he instructs various SQL Server classes while also working on consulting projects, giving him an invaluable appreciation for a balance of theory and practice. His career focus is on Microsoft SQL Server solutions.
Introduction to the Excel 2010 PowerPivot Add-In Feature
In this brief, but informative session, Sopheap will show you how to create a powerful report with a few clicks of the mouse.
Sopheap Suy(Blog | LinkedIn | Twitter) Sopheap is a Database Administrator with over 12 years experience providing quality and timely database management for development, test, and production environment.
Refreshments graciously provided by Apex Systems, Inc..
Jobs, Jobs, Jobs …
- The SQL Server related job market has really taken off in the past few months. Currently, there are approximately 20 open positions (Admins, Developers, BI -from entry to advanced skills) in the Oregon/SW Washington region. Check out the Oregon SQL Jobs page. Tell your friends and colleagues to regularly visit the Jobs page.
Featured Sponsor: Idera
- Idera is excited to help bring free training to the Portland area by sponsoring the Oregon SQL User Group meetings! We’re looking forward to seeing you there. Idera offers a full suite of award-winning solutions to help you with SQL Server performance monitoring, backup and recovery, security and compliance and administration.
For more information, visit our website.
We wish to acknowledge Robert Half Technologies for supporting Oregon SQL by generously sponsoring the meeting venue.