Cognitive Information

SSIS 2012 Parameters vs. 2008R2 Configurations

In this session, SQL Santa (Allen) will review configurations in SQL 2008R2. These options allowed dynamic configuration across environments. Next, we look at SSIS 2012 and the new dynamic options, including Parameters, Expressions and Variables.

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

Getting SQL data into SharePoint

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL data in Sharepoint.

What’s New in SQL Server Reporting Services (SSRS) 2012

This is a short summary of new features found in SQL Server 2012 Reporting Services.

SQL 2012 Study Materials

This started as my personal list of study materials, but it bears sharing.  I got started studying as I studied for the new SQL 2012 Beta Exams.  You might still get a slot to try out the exams for free over at the Born to Learn blog  Once you choose an exam, follow their link […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: