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.

09 April
2014
Author: Roger Wolter

MDS Source Updates

        I ran into an interesting requirement on a recent MDS engagement.  The customer wanted to give a large number of users read-only access to the MDS data.  While they didn’t want most of the users to be able to update the Master Data, they...
25 September
2013
Author: Roger Wolter

SQL File System Slides

Here are the slides from my Training on the Ts presentation: SQL File System Slides

25 September
2013
Author: Roger Wolter

SQL File System Questions

    I did a presentation on the SQL File system Tuesday for Training on the Ts The answers to questions asked during the presentation follow:     Questions Asked by Attendee Q: Are there any changes in the file internals...
09 September
2013
Author: Roger Wolter

TSQL Tuesday SSB Rube Goldberg Solutions

        For those of you who don’t know me, I was one of the program managers for the SQL Server 2005 Service Broker.  One of the harder parts of being the Service Broker (SSB) PM was positioning it.  The first reaction I got when I did...
23 August
2013
Author: Roger Wolter

Wither ASP.Net?

        I ran into an interesting problem while installing MDS on a customer machine this week.  I installed SQL Server 2012 and Visual Studio 2012 on a Windows 7 box.  When I tried to configure MDS, I got a warning that said some Web Server software...
11 August
2013
Author: Roger Wolter

MDS Source Updates

        I ran into an interesting requirement on a recent MDS engagement.  The customer wanted to give a large number of users read-only access to the MDS data.  While they didn’t want most of the users to be able to update the Master Data, they...
02 August
2013
Author: Roger Wolter

File Format Versioning

        File versioning is another thing that I assume most people understand but I still run into a lot of confusion about.  This came up in one of the 24 Hours of PASS sessions I watched,  The question was something like “does the format of...
24 July
2013
Author: Roger Wolter

SQL Server Space Allocation

        Space Layout   In my last post I talked about how SQL Server uses Windows to store data in files and how you have to manage those files to maintain database performance.  In this post I’ll cover how SQL Server manages the space...
12 April
2013
Author: Roger Wolter

SQL Server Storage

  SQL Server Storage   At its heart, SQL Server is just a place to keep data.  There’s a lot of fancy logic for putting data in quickly and finding the data you need quickly but bottom line it’s just a bunch of database stored and a bunch of disks (or other...
12 April
2013
Author: Roger Wolter

Hello (Again)

  Hello (Again)     After being absent from the blogosphere for a few years, I decided it was time I started again.  I lost the ability to access my previous blog (http://blogs.msdn.com/b/rogerwolterblog/) when I left Microsoft so it has taken me a while to get...