Louisville SQL Server and Power BI User Group



Welcome to the Louisville SQL Server Users Group! We represent the SQL Server community in Louisville, the surrounding metropolitan area, and throughout most of Kentucky. As a technical users group, we focus on monthly meetings, but also provide networking, learning opportunities, speaking opportunities, training, and collaboration for SQL Server professionals throughout the Ohio Valley area. Our monthly meetings occur on the second Thursday of each month, either at lunchtime in the downtown Louisville area or in the evening outside downtown. This alternating approach to meeting times and locations allows us to support as many of our users as possible and provides different venue and time options for our meetings and our attendees. We also partner with various volunteer groups to bring special events to the area, such as SQL Saturdays. Those events typically draw large crowds of SQL Server professionals from Kentucky, Ohio, Indiana, Tennessee, and beyond!



Next Meeting




Clustered Columnstore Indexes

Join us on Thursday, March 12 for the next meeting of the Louisville SQL Server Users Group! We will meet at the Humana Training Center in the Waterfront Plaza in downtown Louisville. We plan to have food arrive at 11:30am with the meeting starting at 11:45pm. Our featured presentation will begin at 11:50pm.

Our meeting sponsor this month is Skybridge Resources:

SkyBridge Resources provides a wide array of premier staffing capabilities and expertise to our customers. We understand that there is no such thing as a one size fits all approach to recruiting and work closely with our customers to provide cost effective and customized, strategic staffing solutions. At our core we believe that recruiting is the most important aspect of our business. With our proven SkyBridge Recruiting Methodologies partnered with our “go the extra mile” mentality we are able to not only recruit but maintain individuals of high character, superior abilities and proven track records.

We recognize that the pursuit for top talent is greater than ever, therefore having an actual recruiting strategy vs. posting and waiting for a response is critical for all organizations. It is our overall commitment to both clients and employees that enable us to achieve overall objectives for everyone involved. Visit http://www.skybridgeresources.com/search-jobs.aspx today!

Please come out for our March meeting, learn about clustered columnstore indexes, and thank Skybridge Resources for being our sponsor!

Featured Presentation:

Clustered Columnstore Indexes

Dave Fackler, Senior BI Architect Rolling Hills Enterprises, Inc.

SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable. Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management. SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable! During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled. We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally. Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!

About Dave:
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.

Supplementary Materials

The following event attachments are available to you:



Back to Top