SQL Server 2019 webinar by Bob Ward

The recording of Bob Ward webinar on “SQL Server 2019” is now on YouTube. 

Here is the blog: https://www.dataplatformgeeks.com/sql-server-2019-bob-ward-recorded-webinar-resources/

SQL Server Temporal Tables Overview

For many applications, it's a common requirement to get details about data modifications that have occurred in a SQL Server table. Tables can have multiple updates and deletes for different reasons, and there may be a need to keep the different versions of records. Prior to SQL Server 2016 you would have to use triggers to keep track of data changes in tables, but now we can use the built-in temporal table feature that was first released in SQL Server 2016.

Read more at https://www.mssqltips.com/sqlservertip/5781/sql-server-temporal-tables-overview/

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.

Read more https://www.infoq.com/articles/DevOps-Databases

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 

Free eBooks from Microsoft Press

Free Microsoft eBooks are available in PDF, EPUB and Mobi for Kindle formats.

Find more training eBooks & books at The Microsoft Press Store.

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

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/

Field Notes on SQL Server Cluster Installation

Something good to note. 

https://gdatatech.blogspot.com/2018/01/field-notes-on-sql-server-cluster.html

SQL Server auditing with Server and Database audit specifications

Auditing is a key feature in any application or any system as it provides end users with better analysis for administrators. Apart from analysis, auditing can be used as a troubleshooting mechanism too. Apart from organizational reasons, there are compliance reasons for enabling auditing depending on the domain of operation.

Read more at https://www.sqlshack.com/sql-server-auditing-server-database-audit-specifications/

Not Align UI

Look at the following screen you will see in SQL Server when configuring Audit.

Where is the aligning?

New T-SQL Commands in SQL Server 2017

Despite the maturity of TSQL, SQL Server 2017 still introduces several new features which to the T-SQL family which can be very useful in database development.

http://www.sql-server-performance.com/2017/new-t-sql-commands-in-sql-server-2017/