This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or [!INCLUDE tsql]. If no database collation is specified, the server collation is used.

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Your browser does not support the audio element. Hello Devs, SQL is one of the most essential skills in today's increasingly data-driven world. It's vital for any ...

Your browser does not support the audio element. Auto-increment is a feature in databases that automatically generates a unique number for each new row added to a ...

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced adding WITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup ...

This post is co-authored by Pam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...