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

by Additional Articles

MSSQLTips.com

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?

by Daniel Calbimonte

SQLServerCentral.com

Restore

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.

Making Complex Table Changes

by Steve Jones

SQLServerCentral.com

Editorial

The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.

Security Shaming

by Steve Jones

SQLServerCentral.com

Editorial

This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.

Failover

by Steve Jones

SQLServerCentral.com

Editorial

Too many failovers can cause problems, as can those that happen to often. Steve Jones says you need to consider whether you always need to failover in a sitaution.

SELECT INTO vs INSERT INTO on Columnstore

by Ramya Makam

SQLServerCentral.com

Performance and Tuning

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

Database Lifecycle Management: Deployment and Release

by Additional Articles

SimpleTalk

deployment

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.