Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

20 February
2014
Author: CraigLove

SQL Server Firewall Settings - Part 3

This is the 3rd part of my series of blog posts I am writing regarding configuring firewalls to permit connections to SQL Ser

27 January
2014
Author: CraigLove

(Repost) Dimension Attribute Relationships – Rigid vs. Flexible

As a consultant for PragmaticWorks, I work with a lot of different people.  I have noticed that there is a lot of confusion about dimension attribute relationships with SQL Server Analysis Ser

19 January
2014
Author: CraigLove

Windows 8.1 Upgrade And SQL Server Configuration Manager

After some hesitation I installed Windows 8.1 on my main laptop.  I am familiar with the new interface and so there were no surprises in that regard.  However, I was quite fond of Windows

16 January
2014
Author: CraigLove

Deep Dive Into SSRS and Data Connection Permissions

A couple weeks ago I ran across a problem when setting up a shared data connection for a SQL Server Reporting Services in a test environment.  After beating my head against the desk for a few

11 November
2013
Author: CraigLove

SQL Server Firewall Settings - Part 2

In my previous blog entry on firewall settings, I provide

01 November
2013
Author: CraigLove

SharePoint 2013 CU August 2013 Problem

Beware the dangers of the cutting/bleeding edge!

There is a problem in the SharePoint 2013 Cumulative Update for Augus

29 October
2013
Author: CraigLove

SQL Server Firewall Settings - Part 1

Sooner or later you will be faced with the need to open your server or workstation firewall to allow incoming connections.  This is always a pain for me since t

29 September
2013
Author: CraigLove

SSRS Connection Manager Strings

Here’s a quick one that a client sent to me.

When working in SQL Server Reporting Services it is easy to create the Data Source connection using the wizards in Report Designer (Visual

29 August
2013
Author: CraigLove

Mailing Categories and Star Schema Model

I was recently asked to provide some comments on how model mailing categories.  The client could understand how to create a simple dimension as a lookup table b

29 July
2013
Author: CraigLove

SSIS Package Versions

ETL development with SQL Server Integration Services development requires an unusual blend of skills.  Part T-SQL, part .Net Developer, part XML coder, etc., et