Figure 3-1. SSMS results of checking the database file size. After the clustered index rebuild, the used space decreased by 9mb. The clustered index rebuild decreased the used space of the database file by 9mb
Applies to: SQL Server Azure SQL Managed Instance This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or Transact-SQL. If no database collation is specified, the server collation is used. Recommendations You can find the supported ...
Use SQL Server Management Studio To view or change the compatibility level of a database using SQL Server Management Studio (SSMS) Connect to the appropriate server or instance hosting your database. Select the server name in Object Explorer. Expand Databases, and, depending on the database, ei...
To enable CDC, connect to your Azure SQL Database through Azure Data Studio or SQL Server Management Studio (SSMS). Open a new query window, then enable CDC by running the following T-SQL:SQL Copy EXEC sys.sp_cdc_enable_db; GO ...
In the last article ‘ SQL Server FILESTREAM and Replication’, we configured the SQL Server replication on the FILESTREAM database. We cannot use CDC and Replication together because Replication also tracks the changes from the transaction log. Expand the Replication folder in the SSMS and we ...
https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/ Before changing a database collation on a production system, you should test the change (including testing the applications that use the database) on a development, test, or quality assurance (QA) syste...
Azure Data Studio > Command prompt utilities Database Tuning Advisor (DTA) Distributed Replay SQL Server Configuration Manager SQLCMD SSB Diagnose SQL Server Data Tools (SSDT) SQL Server Management Studio (SSMS) SQL Server Management Studio 21 Preview Download SSMS Release notes Overview Qu...
Set up an example database,AdventureWorks Create a new SQL Change Automation project within SQL Server Management Studio (SSMS) Set up a new development database Baselinethe development database fromAdventureWorks Make changes to the development database, andgenerate migrationsfor the SQL Change Automat...
SQL Change Automation 4.0 offers teams new ways to work when developing database changes for SQL Server, Azure SQL Database, and Azure SQL Database Managed Instances. In this article, I’ll first give you a quick overview of the n...
Change authentication mode with SQL Server Management Studio In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select Properties. On the Security page, under Server authentication, select the new server authentication mode, and then select OK. In the SQL Ser...