Cognitive Information

Archive for Microsoft SQL Server

Allen Speaking at InnoTech – FREE Tickets!

Cognitive Information will be presenting a session titled ‘Return on Data’ at the 2015 InnoTech show. This session will explain the basics of business intelligence, big data and getting results from your company data. Click for free tickets.

SSAS Lost security context

SSAS lost security context in the domain and is showing SID’s in the Security properties. How to fix it.

SSAS Tabular Error “The object reference not set to an instance of an object”

SSAS Tabular Error “The object reference not set to an instance of an object” means you need to check all the columns in your tabular model.

Downloads for SQL Saturday #396 – Dallas BI Edition

Here are the downloads for today’s sessions at SQL Saturday #396, Dallas BI Editoni. BI Basics: Finding Return on Data   Kimball’s not Dead:  Dimensional Modeling Basics   Thank you to all the sponsors.  Thank you for inviting me.  

Data Problems? Get Help

After a short hiatus from consulting, I am once again available for short or long term consulting projects. We also offer onsite training and desk-side mentoring for database issues.

SQL Saturday #300 Kansas City, MO 2014

This is my second year at SQL Saturday in Kansas City.  I thoroughly enjoy the people and of course the BBQ Crawl.  This year my hands down favorite was Q39.   Of course that’s not what your’e here for, so here is the synopsis and download for the BI Basics session.  This slide deck has been […]

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 […]

Tulsa TechFest Presentations

Thank you to all who attended my sessions at Tulsa TechFest. Downloads of each presentation are available.

Speaking Schedule

I’m looking forward to speaking at the following upcoming events. August 15th – Tulsa TechFest,  speaking about Business Intelligence Basics and SQL Server Reporting Services Basics August 23 – SQL Saturday 309 in Oklahoma City, speaking about Business Intelligence Basics and SQL 2014 Columnstore Indexes September 13 – SQL Saturday 300 in Kansas City,  Business Intelligence […]

SQL 2014 ColumnStore Indexes

In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: