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.

25 June
2012
Author: kylewalker

Kill them all... Your SPIDs of course!

I had a pretty common task to perform the other day.  And that task was to simply restore a database on a development server.  Now, restoring a database in and of itself is a very simple

09 February
2012
Author: kylewalker

Keep in Mind: SSIS Replace Function is Case sEnsitive

After a brief hiatus, I'm getting back into the swing of things with my blog.  To kick things off I'm going to share a helpful little tip about the SSIS replace function that, for some reason,

17 August
2011
Author: kylewalker

Pull Data from a Sharepoint List with Task Factory's Sharepoint Source!

With the increasing popularity of Sharepoint sites in a lot of shops, wouldn’t it be great to have an easy way to extr

16 August
2011
Author: kylewalker

Job Step Settings for Executing Packages Containing Excel Componenets on a 64-bit Machine

Many of the SSIS packages you'll see on the job might use Excel workbooks as a source or destination for your data.  Another trend that's becoming increasingly common is the use of 64-bit mach

11 August
2011
Author: kylewalker

HRESULT E_FAIL Error when trying to add Breakpoints

I ran into a small problem this morning when trying to test an SSIS package.  I simply wanted to add a breakpoint to a Foreach Loop Container to pause the package at the beginning of each iter

05 August
2011
Author: kylewalker

Parameters Don't Always Work in your Execute SQL Task

Chances are, if you've used SSIS in any capacity, you've used an Execute SQL Task.  I would say that about 95% of all the packages I write include at least one.  And if you're a fan of making your

28 June
2011
Author: kylewalker

How to Match Your Subcription Names with its Job Id

If you've worked on any reporting solution using SSRS, you may have been able to take advantage of subscription feature.  Subscriptions allow you to schedule a repeating or one time request to rece

14 June
2011
Author: kylewalker

SQL Server Compatibility Issues with SSIS Packages Converted From DTS

If your business is in the process of converting old DTS packages to new SSIS packages, you will quickly notice that many of the components used in DTS are not easily converted to SSIS native compo

10 May
2011
Author: kylewalker

Want the Functionality of a CASE Statement in a WHERE Clause?

You may find yourself wanting to apply the functionality of a CASE statement inside a WHERE clause in one of your SQL scripts or stored procedures.  Although you might get you case statement workin

21 April
2011
Author: kylewalker

Query to Find a List of Jobs Running on your Server

Usually I decide what to blog about by running across something cool or challenging during work.  But every once in a while I like to share something that I've received a number of questions about