Tuesday, November 13, 2018

DevOps and Databases

A robust DevOps environment requires having continuous integration for every component of the system. But far too often, the database is omitted from the equation, leading to problems from fragile production releases and inefficient development practices to simply making it harder to on board new programmers.
In this article, it is discussed the unique aspects of databases, both relational and NoSQL, in a successful continuous integration environment.

Tuesday, October 30, 2018

Script to Create and Update Missing SQL Server ColumnStore Indexes

SQL Server columnstore indexes are helpful when it comes to retrieving large volumes of data.  However, there are instances where columns are added to the table after the columnstore index was created. This means the new columns are missing in the columnstore index. Also, there can be cases where new tables are added and a columnstore index was not created.  In this tip we will look at how we can identify these cases and create scripts to create the index.

https://www.mssqltips.com/sqlservertip/5742/script-to-create-and-update-missing-sql-server-columnstore-indexes 


Sunday, October 21, 2018

Free eBooks from Microsoft Press

Free Microsoft eBooks are available in PDFEPUB and Mobi for Kindle formats.
Find more training eBooks & books at The Microsoft Press Store.

Download from https://mva.microsoft.com/ebooks

Tuesday, July 24, 2018

Why Surrogate Keys are Needed for a SQL Server Data Warehouse

In this tip we look at some of the reasons why surrogate keys should be used when building a data warehouse.
https://www.mssqltips.com/sqlservertip/5602/why-surrogate-keys-are-needed-for-a-sql-server-data-warehouse/