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.

14 February
2017
Author: SteveHughes

T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT

Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday. Splitting Strings in SQL A problem that has plagued SQL developers through the years is splitting strings. Many techniques have been used as more capabilities were added to SQL Server including XML datatypes, recursive CTEs and...
09 February
2017
Author: SteveHughes

Consumption Based Architecture for Modern Data Analytics

Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data in one location so it could be easily consumed by reporting and analysis tools from SQL Server Reporting Services to Microsoft Excel. We have followed the dimensional modeling...
07 February
2017
Author: JasonStrate

Not Quite Monday Morning SQL Break – February 7, 2017

It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform...
07 February
2017
Author: JasonStrate

Not Quite Monday Morning SQL Break – February 7, 2017

It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform...
03 February
2017
Author: Robert Cain

Troy Hunt: A data breach investigation blow-by-blow

This is a fascinating read from security researcher Troy Hunt. In it he describes the process by which he investigates a data breach. Well worth the read. https://www.troyhunt.com/a-data-breach-investigation-blow-by-blow/
31 January
2017
Author: Robert Cain

SQL Server Reporting Services Playbook now live on Pluralsight!

My newest course, the SQL Server Reporting Services Playbook, is now live on Pluralsight! If you are looking to get up to speed fast writing reports in SQL Server Reporting Services, this is the course for you. In roughly two hours you will have enough information to start cranking out reports...
16 January
2017
Author: JasonStrate

Monday Morning SQL Break – January 16, 2017

It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing.  If you haven’t already, follow me on twitter...
16 January
2017
Author: JasonStrate

Monday Morning SQL Break – January 16, 2017

It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing.  If you haven’t already, follow me on twitter...
13 January
2017
Author: Robert Cain

What’s New in SQL Server 2016 Reporting Services–Now live at Pluralsight

So you want to see what’s new in SQL Server 2016 Reporting Services? Well I’ve got just the thing for you. My 12th course just went live on Pluralsight, named appropriately “What’s New in SQL Server 2016 Reporting Services”. This course is designed specifically for those who are already familiar...
03 December
2016
Author: Robert Cain

SQL Sever 2016 Reporting Services Cookbook has arrived!

  I’m proud to announce my latest book, the SQL Server 2016 Reporting Services Cookbook, has been released! This was a real labor of love, it consumed most of my summer and well into the fall. This book was published via Packt Press, and my coauthor was Dinesh Priyankara (blog | twitter). In...