Jun 5, 2018 | Fuzzy Logic, How To, Microsoft, SQL Server, SSIS, Tech Tips, Technical Information
By: Andy Kim I was at the SQL Saturday Atlanta conference last week and attended a session in which the speaker asked the audience, “Has anyone here used fuzzy grouping or fuzzy lookups in SSIS?” To my surprise, I was the only one who raised their hand. When data...
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...
Aug 28, 2017 | How To, Salesforce, SQL Server, Technical Information
By: Jeff Levy If you’re a business intelligence (BI) and/or data warehouse practitioner, chances are you’ve handled sales data in the past or will do so sometime in the future. Incorporating sales data into business intelligence processes has...
Jun 8, 2017 | Featured, How To, Microsoft Power BI, Technical Information
By: Andy Kim An important part in preparing data for business intelligence is manipulating the data into usable standard formats. In PowerBI, data can be manipulated both as it’s being brought into your report as well as after you’re bringing the data into Power BI....
Mar 27, 2017 | How To, SharePoint
By: Mason Prewett As a SharePoint administrator, teams often ask me for advice to help them design their content in a structured way. Here are some common questions I receive: How can we make it easier for my end users to find content? How can we make sure that our...
