Cognitive Information

Want to Be a SQL BI Consultant?

Presentation Download for OKC SQL User Group. At the February meeting of the OKC SQL User Group, I presented a session on what it takes to become a consultant.

My Intro to SQLFamily

By trade, I’m a Cognos BI developer that jumped the fence to MS SQL BI a few years ago. My first encounter with SQLfamily was at SQL Saturday #63, April 2, 2011 in Dallas, Texas. First SQL Saturdays and SQL Rally I came to a SQL Saturay #63 pre-con to learn more about the BI […]

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

SQL 2014 ColumnStore Indexes

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

How to set OLE DB Source data in SSIS

When preparing data for a Merge Transformation, the data has to be sorted. The database sending the data can sort data faster than SSIS. This works if you already have data sorted in the table or if you use an ORDER BY clause. The IsSorted properties just inform sall the downstream transformations that that data from this data source is coming in already sorted.

Presenting at SQL Saturday 255 in Dallas

Just a quick note that I will be presenting an ‘Intro to SharePoint BI’ at SQL Saturday 255 in Dallas this weekend, November 2nd. Looking forward to seeing everyone. The SharePoint presentation and sample code is already available, though it is getting renamed at Dallas. http://www.cognitiveinfo.com/2013/sql-2012-sharepoint-2013/

Sharing SQL 2012 data in SharePoint 2013

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

Business Intelligence Forecasting in SQL and Cognos

Note: This article is an update of a presentation given when I was at the University of Oklahoma’s Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012.  Revisiting this subject ten years later, my opinion is that Microsoft has […]

‘SQL with Style’ class by Joe Celko

Come learn about SQL with author Joe Celko. August 24th, 2012 in Oklahoma City, OK, USA.

SQL Rally 2012 BI Track Highlights

PASS SQL Rally in Dallas, TX had some great speakers. Here is my list of some great sessions on the business intelligence track of the conference.

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: