thomasliddledba.com Site Logo

Thomas Liddle DBA

thomasliddledba.com is a resource for a collection of articles, videos, scripts, and resources that I want to share with SQL Server Database Administrators and developers.

You can also visit me on the following sites:

thomasliddledba.com is now on Github.com

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

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!|Watch it in Action!

10 Minute DBA - Now Available

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.

Educate Yourself!

Changing Linked Server Passwords

Yours truly worked with SQLServerCentral.com 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 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.

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 - Watch the Video

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

CREATE OR ALTER statement in SQL Server 2016 SP1

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.

Read More

Temporal Tables in SQL Server 2016 - More Control

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.

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 Installation (vNext CTP1) on Linux (Ubuntu)

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

Watch Video

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