Want to learn SSIS project design principles that will streamline your ETL package deployment?
Download our eBook and start saving time and resources.
Data analytics is a constantly evolving landscape.
Keep your knowledge sharp and explore some of our recent content.
How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory
Learn how to copy multiple tables from an on-premise SQL Server database to Azure SQL Data Warehouse.
What is the California Consumer Privacy Act (CCPA)?
The California Consumer Privacy Act (CCPA) is a bill designed to improve the data privacy rights of consumers residing in California.
Back to PASS Summit 2019 – Planning to learn, learn, learn!
Are you heading to PASS Summit 2019? Here’s some of the events we plan to attend while being there!
Data Security Levels and Their Importance in a Data Warehouse
Data security levels are a vital component of successfully securing a data warehouse, particularly when it comes to storing sensitive info like PHI and PII. Learn more in this post!
How to Implement Column Level Security in SQL Server
Column level security (CLS) is a useful tool for limiting access to specific data elements (or database columns) through data obfuscation.
Web Applications and Their Role in Data Security
Learn about the two most common attacks against web applications and what you can do to prevent them from happening to your organization.
PowerShell – How to Display Job Progress
Learn how you can create a PowerShell progress bar per job to monitor and display job progress. We provide the code for you to do so.
Tales from Consulting – Part Two: Software Development Life Cycle (SDLC)
Learn about the highly important software development life cycle (SDLC) in our latest edition of “Tales from Consulting”!
Introducing ‘SharePoint Things’, Our Newest Video Series
Introducing our newest video series, “SharePoint Things.” PowerApps integration with SharePoint Online can be powerful!
Manipulating the Target Table in a SQL SELECT…INTO Statement
The SELECT…INTO statement is a great tool to have in your arsenal if you’re a SQL developer. Learn how to manipulate the target table in such a statement.
Why Data Warehouse Projects Fail
Some data warehouse projects fail – don’t let yours be the next!
Working with Local Groups Using PowerShell
Learn how you can make system administration work easier by taking advantage of PowerShell when working with Local Groups.
Key2 Consulting | [email protected] | (678) 835-8539