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...
Apr 18, 2018 | Data Warehousing, Featured
By: Ken Adams If you interviewed a handful of database professionals and asked them to define an Enterprise Data Warehouse (EDW, for short), it’s likely you would get a slightly different interpretation from each of them! That’s not to say any of them would be...
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....
Mar 20, 2018 | Uncategorized
By: Paul Schuliger The rise of NoSQL databases has brought about the ability to quickly and easily receive or retrieve data and store it without a predefined schema. This is great, but I would argue that although the data can be stored without a...
Mar 7, 2018 | 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...