May 8, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Matt Wollner Adding custom logging and auditing to your ETL process can be very beneficial – so much so that if your organization hasn’t added it to your ETL process yet, we highly recommend doing so. Many developers rely on SSIS to log their SSIS packages via...
Apr 10, 2018 | Machine Learning, RevoScaleR, SQL Server, Technical Information
By: Anvesh Vallabhaneni My goal with this blog post is to get you familiarized with a few machine learning capabilities that we can quickly implement using RevoScaleR and SQL Server 2017. I expect you (as the reader) to have a lot of familiarity with R and SQL. In...
Mar 7, 2018 | Analytics, Microsoft, Microsoft Power BI, SQL Server, Tech Tips, Technical Information
By: Paul Schuliger During a recent reporting project, I came across a situation in which the solution was to provide the reporting tool (Power BI sourcing from an SSAS tabular model) a sort order for each level of a dimensional hierarchy. Without a sort order...
Feb 26, 2018 | Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Jharred Williams To kick things off, let’s start with a quick refresh on SQL Server Integration Services (SSIS) and what’s new with the tool today. To say SSIS is strictly a data extract, transformation and loading (ETL) tool would be...
Jan 30, 2018 | .NET, How To, SQL Server, SSIS, Technical Information
By: Jeff Levy Multithreading an SSIS Package – Introduction Ever have a single task in SSIS that can be applied to dozens of tables in your database? Such a task could be as simple as extracting a table out to a flat file and moving it to a network drive. In...
Oct 23, 2017 | Data Visualization, Featured, Microsoft, Microsoft Power BI, Technical Information
By: Ken Adams Sr. BI Consultant In this article, I am going to dive into Power BI and show you the new Timeline Storyteller visualization. This is a custom visualization for Power BI that can be found at the Office Store. I will later show you how to add it to...
