SQL Saturday 309 Downloads

Downloads for SQL Saturday #309 in Oklahoma City are below. Thank you to all who attended. Thanks also to all the sponsors who help make these great events possible for the tech community.

Business Intelligence Basics: Finding Return on Data

This session will you chart the waters through the sea of Business Intelligence (BI) options. IT departments need tools to turn data into useful information for users. Instead of ROI, this session talks about ‘Return on Data’ for IT Managers. In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint.

Subscribe to Download Presentation:

[email-download download_id=”778″ contact_form_id=”739″]

Columnstore Indexes: Introduction

ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows.  With SQL 2014, those ColumnStore indexes become update-able.   In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.

Subscribe to Download Presentation and Sample Files:

[email-download download_id=”750″ contact_form_id=”739″]

Privacy Policy:  I will never sell or share your data.  When you sign up, I’ll send you a note when there is a new blog article about BI.  Unsubscribe any time.