Cognitive Information

Archive for Microsoft SQL Server

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.

SSAS Cube Partition Slice ErrorCode=”3240034361″

f you ever get the following errors when processing cubes, it has to do with the Slicer property at the cube partition level. Error ErrorCode=”3240034361″ Description=”Errors in the OLAP storage engine:
The restrictions imposed on partition slice where violated.” Source=”Microsoft SQL Server 2012 Analysis Services”

PASS Summit 2013 – A First-timer’s Experience

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

Custom Chart Palettes in SSRS

This article is a follow up to the Cognos article on creating a custom color palette.  Custom palettes are pretty common when companies start to standardize their corporate image across all company communications. Make a copy of your report template. Name it ‘MyCorp Chart Report’ In the report area, add a chart Right-Click the chart […]

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.

How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

A tutorial for configuring SQL Server Reporting Services 2012 on a SharePoint 2013 server in Integrated Mode on a single server.

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

How to fix “Usage Based Optimizer” connection errors in SSAS 2012

The Usage-Based Optimizer can be a very powerful tool for calculating aggregations, when it works. When it doesn’t work perfectly, then it can be frustrating to figure out. The devil is in the details. If you move data between environment, then you have even more details to find and fix.

Business Intelligence & Data Warehouse Consulting