May 9, 2017 | SQL Server, Tech Tips
By: Matt Wollner Keyboard shortcuts play an important role in increasing the productivity of any development environment. There are myriad shortcuts that are highly beneficial in SQL Server Management Studio (SSMS), and SSMS also allows you to easily add...
May 8, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Senior BI Consultant at Key2 Consulting As was mentioned in a previous blog post comparing the pros and cons of Microsoft Azure SQL Database versus SQL Data Warehouse, Microsoft announced at SQL PASS 2016 that they are offering a free, 1-month...
May 1, 2017 | SQL Server, Technical Information
By: Paul Schuliger BI Consultant at Key2 Consulting This is the second article about the use of the Date Matrix in reporting applications. The first article can be found here if you missed it. The Date Matrix is a SQL tool that is used to solve the problem of...
Feb 27, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Sr. Business Intelligence Consultant at Key2 Consulting 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. This...
Feb 20, 2017 | SQL Server, Technical Information
Choosing the right index for Memory Optimized Tables (MOTs) 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...
Feb 9, 2017 | Business Intelligence, SQL Server, Technical Information
By: Paul Schuliger Business Intelligence Consultant Anyone who’s looked into a master craftsman’s toolbox knows that they keep an extensive variety of tools. So many so, that it seems only half of them are ever used. But the craftsman doesn’t...
