This website is now rehosted on Github! We are excited to now be apart of this community!

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

I'm excited to announce the 10 Minute DBA Education Session. The 10 Minute DBA is a playlist for SQL Server Enthusiasts and Newbies to SQL Server. Weekly videos are posted for Beginners and Advanced users with topics ranging from Design to Demonstration of Features.

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

Microsoft is taking steps to minamize 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. Perviously, if you wanted to script out an object such as a stored procedure you had to check if it exists. This new statement elimiates that.

In our pervious 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.

This video tutorial will educate you on how to install SQL Server (vNext CTP1) on Linux (Ubuntu 16.04).

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.