This demostration will walk you through step by step on how to configure and enable resource governor to use for workloads on SQL Server

Yours truly worked with SQLServerCentral.com on an article about linked servers. Read the article, Rate the article, Join the discussion.

This video demonstration will educate you on how to implement Dynamic Data Masking and how to ALTER it.

Yours truly worked with SQLServerCentral.com on an article about setting up source control on your SQL Server Database (GO DEVOPS!). Read the article, Rate the article, Join the discussion.

Introduced in SQL Server 2014 and greatly enhanced with SQL Server 2016 is In-Memory OLTP. In-Memory OLTP is a memory optimized database engine intergraded with SQL Server. It's designed to improve performance of data workloads and transaction processing. This demo will walk you through how to set up a database to use In-Memory OLTP.

Read about SQL Server Service Packs that are Reaching End of Life in 2017

Educate yourself on how easy it is to DROP an objects in one statement

Microsoft is taking steps to minimize the amount of code that has to be written to get a job done. With that said, they finally introduced with SP1 for SQL Server 2016 the CREATE OR ALTER statement. Previously, if you wanted to script out an object such as a stored procedure you had to check if it exists. This new statement eliminates that.

In our previous post, when letting the system create temporal tables, it will create the table in the default filegroup that the table is in. But what if you want to manage the object placement of the temporal table, such as indexes.

This demo will educate you on how to create the teproal table and allow you to manage the placement of indexes associated with the temporal table.

Temporal Table is a new type of user defined table introduced in SQL Server 2016. Temporal table are tables except SQL Server automatically tracks the full history of the data changes into a separate history table.

Dynamic Data Masking limits the exposure to sensitive data to users that should not see the data being presented. DDM is used in conjunctions with other features in SQL Server such as SQL Auditing and Encryption (TDE and row-level encryption) to provide a completely secure database platform.

The MERGE statement and perform INSERT, DELETE, and UPDATE operations on a target table from a source table within one statement.