Welcome To Our Data Analytics Blog
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.
What’s Happening at Key2 Consulting – Q1, 2019
What’s Happening at Key2 Consulting – Q1, 2019
Location, Location, Location… Adding richness to your data using Spatial Data Types in SQL Server
Learn the basics of using geography and geometry data types in SQL Server with data from Google Maps.
Get our latest analytics content straight to your inbox
Key2 Consulting | [email protected] | (678) 835-8539