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.

04 September
2012
Author: bryan_cafferky

Use a Function as a Parameterized View! The Best Thing Since Sliced Bread

You have a query that gets data perfectly and you would like to make into a view so you can use it in a number of places without re-coding. But there’s a problem, it requires parameters such as a date range to filter and SQL Server views do not support parameters. You can use a stored...
10 July
2012
Author: bryan_cafferky

Leverage the Power of SQL Server Management Objects (SMO)

Microosoft SQL Server exposes the objects of the database engine, integration services, analysis services, and even SQL Agent so you can directly call services to leverage the power of these object libraries. I first looked into this when my company needed to convert all our character columns to...
11 April
2012
Author: bryan_cafferky

SQL Performance Tuning Tips For Developers Who Don't Like Performance Tuning

Ok, you've clicked on the run button twenty minutes ago and the query is still running. You really don''t want to stop and do serious performance tuning but you're getting that sinking feeling that you may celebrate your next birthday before this query comes back. You start to...
30 December
2011
Author: bryan_cafferky

Use SQL To Write Your SQL Code!

The idea of using SQL scripts to automatically generate SQL code is one that can be applied to many situations, especially when you need to process many different database objects.