Cognitive Information

PASS Summit 2013 – A First-timer’s Experience

An overview of PASS Summit 2013 from the eyes of a first timer.

Customized SSRS reporting template.

Large reporting projects can be simplified with a good template as a starting point. Design templates can store the company header with logo, company color palette, font preference and layout.

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

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.

Practice Exams: Transcender vs. SelfTest vs. MeasureUp

A product review of practice tests for Microsoft certifications. Products include Transcender, Kaplan SelfTest and MeasureUp.

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

SSRS Data Driven Subscription Troubleshooting

Microsoft SQL Server Reporting Services (SSRS) 2008 R2 will only allow data driven subscriptions under certain conditions, including data source security and server configuration options. SSRS Subscriptions always work great and easy in the demos and training classes. The following is the list of requirements to actually get them to work with in a data driven environment.

SSRS Adding “Image Not Available” as Alternate Image

I just had a requirement to build a report which had images stored in the database and show a ‘not available’ image when data was not available. This method uses stacked image objects and the visibility properties.

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: