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.
This is the 3rd part of my series of blog posts I am writing regarding configuring firewalls to permit connections to SQL Ser
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
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
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
In my previous blog entry on firewall settings, I provide
Beware the dangers of the cutting/bleeding edge!
There is a problem in the SharePoint 2013 Cumulative Update for Augus
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
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
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
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