Welcome To Our Data Analytics Blog
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.
How to Set Up Row Level Security (RLS) in Microsoft Power BI
Learn about two different methods you can use to set up Row Level Security (RLS) in Microsoft Power BI.
Enhance Your SQL Server Tool Belt – How to Add Compression to Existing Objects
Enhance your SQL Server tool belt with compression, a great tool for saving space in databases.
What’s Happening at Key2 Consulting – Q2, 2019
In our second edition of “What’s Happening at Key2 Consulting,” we share some company highlights over the last quarter!
How to Manage Power BI with PowerShell – An Example
Learn how you can use PowerShell to get more out of Microsoft Power BI. We provide a quick example that you can try on your own.
How to Use the SQL LEAD Window Function – LEAD with EOMONTH
Learn about the SQL LEAD window function, a great tool to have under your belt for complex reporting projects.
Webpack – A Great Tool for Managing JavaScript Modules
Many utilities exist for managing JavaScript modules, but one that has rightfully gained a great deal of attention over the past few years is webpack.
How to Install Hadoop on a Linux Virtual Machine on Windows 10
This step-by-step tutorial walks you through how to set up and use your very own Hadoop instance.
Create A File System Size Tree View Using PowerShell
Manually determining what is causing your machine to run out of disk space? Try this PowerShell code to automate a quick directory size view.
Step By Step – Chaining Jobs With SQL Server Agent
Learn how to use SQL Server Agent to chain and schedule dependent jobs together.
Get our latest analytics content straight to your inbox
Key2 Consulting | [email protected] | (678) 835-8539