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.
Sharing Is Caring – How To Share Your Power BI Reports
This post is part of our Power BI series and is a follow up to “Baby Steps: How to Create Basic Charts in Power BI Desktop.” In this post, we talk about how you can share your Power BI reports with your co-workers, because after all, sharing is caring.
Baby Steps: How To Build Basic Charts in Power BI Desktop
In part 1 of our Power BI series, we show you step-by-step how you can create basic charts in Microsoft’s Power BI Desktop.
Building a Data Warehouse: Populating and Using a Junk Dimension
A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. In this post, we show you how to build a data warehouse by populating a junk dimension.
SQL Shootout: In-Memory Tables vs. Disk-Based Tables (Round 2)
In Part 1 of our investigation into In-Memory Tables, we saw how changing a Hash Index to a regular Nonclustered index of a sample database table improved the performance of our Select operation. In this article, we take a deeper dive into the types of indexes we can apply to memory optimized tables, focusing on the more common hash and nonclustered indexes.
For the SQL Craftsman: Date Matrix Aggregation
The SQL Date Matrix tool is a business intelligence tool that has its purpose, but is often left on the shelf to be slowly covered in dust and ultimately forgotten. But to the business intelligence expert, the SQL Date Matrix is an invaluable solution when used in the right situation.
How To Inventory Your Sharepoint Content
In this post, we guide you step-by-step on how to inventory your SharePoint content.
Managing Permissions with SSRS Data Alerts in Sharepoint 2013 On Premise
Anyone that has lived on the Admin side of even the smallest of SharePoint 2013 on premise environments has probably come across some of the many interesting “out of the box” permissions scenarios. In this post, we show you how you can overcome difficult permission scenarios that are causing your team headaches.
Recapping 5 Brilliant Presentations From SQL Saturday
SQL Saturdays are always great events to attend. In this post we share some knowledge gained from a recent SQL Saturday in Atlanta…
How to Execute a SSIS Package within a SSIS Script Task
Kicking off an SSIS package from within a Script task ended up being harder than we thought, but it can be done. In this post, we take you step-by-step through the process of executing a SSIS package within a SSIS Script Task.
3 Growing Trends in the Business Intelligence Industry
The business intelligence (BI) industry has really taken off in the last few decades, where more and more businesses are realizing the tremendous value in having a great business intelligence solution. With this exponential growth, BI strategy and implementation is constantly evolving. Three major trends that the industry is currently experiencing are…
Comparing Azure SQL Database to SQL Data Warehouse
Have you wondered what the difference is between Azure SQL Database and Azure SQL Data Warehouse? In this post we highlight the key differences between the two Microsoft product offerings and point out what you need to know.
One of the Biggest Takeaways From PASS SQL Summit 2016
We attend PASS SQL Summit every year. Here’s the biggest takeaway from 2016’s event.
Key2 Consulting | [email protected] | (678) 835-8539