This is a collection of articles both internal to and external

I also list external links to articles I write for the following web sites:

Getting Started with Resource Governor

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

Educate Yourself!

Changing Linked Server Passwords

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

Read More | Join the Discussion

Video: Dynamic Data Masking

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

Watch the Video | Read More

Put your Database under Source Control -

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

Read More | Join the Discussion

In-Memory OLTP - Part 1

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 More

SQL Server Products Reaching End of Support in 2017

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

Read More

DROP IF EXISTS statement in SQL Server 2016

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

Read More

CREATE OR ALTER statement in SQL Server 2016 SP1

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.

Read More

Temporal Tables in SQL Server 2016 - More Control

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.

Read More

Temporal Tables in SQL Server 2016

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.

Read More

SQL Server Dynamic Data Masking (DDM)

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.

Read More

MERGE TSQL with SQL Server

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

Read More