Compress and Decompress in SQL Server 2016

Explore using Compress/Decompress with varying types of data and examine size/storage usage

Creating Strings with Replicate

Changing Linked Server Properties

A quick guide on changing the linked server properties and settings.

Additional Data Files and Proportional Fill

Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.

SQL Server Unit Testing in Visual Studio

Unit test stored procedures in Visual Studio using an existing database or new SQL scripts

Union Date/Time Data Types

Int Conversion

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.

Temp Table Foreign Keys

Diagnosing parallelism-related latching

Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV’s, the activity monitor, procedure execution plans, and index tuning.