Stretch Database in SQL Server 2016 RTM

Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.

Reclaiming Space After Column Data Type Change

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

Steps to change the server name for a SQL Server machine

In this tip Jugal Shah looks at the steps within SQL Server you need to follow if you change the physical server name for a standalone SQL Server.

Backup Strategy in Azure SQL?

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.

SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.

Database Lifecycle Management: Deployment and Release

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamwork, planning and forethought, though, the process can be made almost painless.

Proper Storage and Handling of Personal Names

As database developers, we may need to rethink the way we store and handle personal names

SQL Server 2016 Temporal Table Query Plan Behaviour

In this latest T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.

Byte Me: Earning in the Grave

Create a SQL Server Reporting Services Report from an Analysis Services Tabular Database

Daniel Calbimonte walks through the steps to creating a SQL Server Reporting Services (SSRS) Report from an Analysis Services Tabular Database.