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.

26 September
2016
Author: Anil
Anil
26 September
2016
Author: Anil
Anil
23 March
2016
Author: Anil
Anil

Speaking at SQLSaturday Nepal SQLSaturday #482 .

Firstly I am happy and excited that I will be speaking at SQLSaturday#482 on March 26 2016. This is my second time for this International SQLSaturday event and I’m really excited that I will be speaking this time. I will be speaking on ‘Using power query to tell your story...
22 July
2015
Author: DevinKnight
DevinKnight

Excel Services in Power BI

**Information current as of 7/22/2015** There’s lots of exciting news this week with Power BI so expect several short blog posts detailing each.  Here’s one you can try now that I was pretty excited to see. So here’s the news.  You can now expose standard Excel...
15 July
2015
Author: DustinRyan
DustinRyan

Learn Designing a Data Warehouse from the Ground Up at SQL Saturday 442 Orlando, FL

I’m very excited to announce that I’ve been selected to present a session entitled Designing a Data Warehouse from the Ground Up on October 10, 2015 in Orlando, Florida at Seminole State College of Florida! I’ll be presenting this session for the first time along side Mitchell...
11 July
2015
Author: DustinRyan
DustinRyan

What’s New in SQL Server Analysis Services 2016?

There’s a load of new features that are included in the release of SQL Server Analysis Services 2016 CTP2. I’m pretty excited about these changes and while these changes have been public for a while now, I’d like to share my thoughts. I’ll say that these features are...
08 July
2015
Author: DustinRyan
DustinRyan

TSQL Script to Find Foreign Key References to a Given Column

It’s always kind of a pain to have to hunt down all those foreign key references so you can address the issues. So I put this script together (based on a script found on StackOverflow) in order to help me find all the required information related to a particular column in a specified table....
28 May
2015
Author: DevinKnight
DevinKnight

Creating a SQL 2016 CTP2 Virtual Machine in Azure

With the CTP2 of SQL Server 2016 now released you may be eager to try it out.  One of the best ways to do this in my opinion is to set it up on a virtual machine.  You could certainly do this with VMWare or Hyper-V but my new preference for creating VMs is Azure. The great thing...
29 April
2015
Author: DustinRyan
DustinRyan

T-SQL Script to Dynamically Create Table, Build Clustered Columnstore Index, and Partition Switch

Recently myself and Mitchell Pearson (blog|twitter) were working on a project for a client that required us to load a ton of data (dozens of TBs) into some tables each built with a clustered columnstore index. We discovered during testing that the fastest way to get that much data into the...
13 October
2014
Author: DevinKnight
DevinKnight

Creating a Reporting Services Subscription

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in this...