Nov 16, 2017 | Conferences, Key2 Stories, Microsoft, SQL Server
By: Jason E Bacani BI Consultant Two weeks ago I joined my fellow colleagues from Key2 Consulting at the annual PASS Summit conference held in Seattle, Washington. Click here to see part one of my Twitter recap of the event! This article is part 2 of that...
Nov 15, 2017 | Microsoft, SQL Server, SSIS
By: Matt Wollner Sr. BI Consultant In all of the SSIS packages that we develop, we include an auditing and logging framework. This framework consists of adding Event Handlers to the package, such as OnError, OnPreExecution and OnPostExecution. ...
Nov 9, 2017 | Conferences, Microsoft, SQL Server
By: Jason E Bacani BI Consultant I was honored to be among the folks heading to Seattle to attend PASS Summit 2017, representing Key2 Consulting from November 01 – 03. Our schedule included three formal days at the conference from Wednesday through Friday,...
Oct 16, 2017 | Data Encryption, Data Security, SQL Server
By: Anvesh Vallabhaneni BI Consultant IHG, Arby’s, Chipotle, University of Washington, Anthem / Blue Cross Blue Shield, Verizon, Equifax, SEC, Deloitte, Whole Foods – these are just a few popular names on a long list of companies that had a data breach this...
Sep 12, 2017 | PowerShell, SQL Server, Technical Information
By: Jharred R. Williams A brief intro of Windows PowerShell • Windows Powershell is a task automation framework used for its ease of use when compared to building full blown executables. • With a command line shell that is almost identical to a...
Aug 28, 2017 | 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...
