Want to learn SSIS project design principles that will streamline your ETL package deployment?
Download our eBook and start saving time and resources.
WHAT’S INSIDE
Data analytics is a constantly evolving landscape.
Stay in the know with more Key2 content.
Reporting with Amazon Marketplace Web Service (MWS)
Amazon Marketplace Web Service (MWS) provides a wide variety of reports that will help you make decisions, and in this blog post we walk through how to access and use those reports.
How to Upgrade to SQL Server Reporting Services 2016 in SharePoint 2013
Need help upgrading to SQL Server Reporting Services 2016 in SharePoint 2013? Check out our latest how-to guide complete with some troubleshooting tips based on our experience making the jump.
Testing Changes in SharePoint 2013 Enterprise Farm with SSRS Report Builder 2016
It’s always important as a SharePoint Admin to understand what effect an update to your system will have on your user base. And this is even more important if your user base is huge.
How to Deduplicate Data Using Fuzzy Logic in SSIS
Data doesn’t always match cleanly. In these cases, fuzzy logic can be an incredibly useful tool you can use to deduplicate and clean up your data.
Custom SSIS Logging and Auditing
Adding custom SSIS 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.
Concepts of an Enterprise Data Warehouse (EDW)
We define what an enterprise data warehouse is, discuss both the alternatives to and the value on can bring, and detail a real-world example.
Machine Learning with R and SQL Server 2017
Learn about the fascinating machine learning capabilities of RevoScaleR and SQL Server and how you can use them to conduct machine learning!
Is Dimensional Modeling Still Relevant?
We share some quick insight as to whether dimensional modeling is still relevant to modern data management processes or not. The short answer? It certainly is.
Using SQL Window Functions – A Power BI Example
Learn how you can use SQL Window functions to properly order results in a report. In this post, we walk you through a client example that involved us working with a Power BI reporting tool.
SSIS Performance Tuning Overview
Learn more about how you can tune SSIS 2018 to enhance maximum performance. In this quick read, we mention concepts around SSIS control flow, the data flow task, and getting great performance results.
Basics of Responsive Web Design – Layout Decisions, Layout Logic, CSS Media Queries
Today’s great web & mobile applications are responsive on any and all devices, including different sizes. Learn about the basics of responsive web design.
How to Multithread the Execution of a Single SSIS Package with C#
Learn how you can use two SSIS packages to dynamically accomplish the extraction of dozens of tables to a flat file using multithreading in C#.
Key2 Consulting | [email protected] | (678) 835-8539
