AZR-SQL101

SELECT 'ALTER INDEX ' + QUOTENAME(I.name) + ' ON ' + QUOTENAME(SCHEMA_NAME(T.schema_id))+'.'+ QUOTENAME(T.name) + ' DISABLE' FROM sys.indexes I  INNER JOIN sys.tables T ON I.object_id = T.object_id  WHERE I.type_desc = 'NONCLUSTERED' AND I.name IS NOT NULL AND I.is_disabled = 0 Till Next Time

SELECT 'ALTER INDEX ' + QUOTENAME(I.name) + ' ON ' +  QUOTENAME(SCHEMA_NAME(T.schema_id))+'.'+ QUOTENAME(T.name) + ' REBUILD' FROM sys.indexes I INNER JOIN sys.tables T ON I.object_id = T.object_id WHERE I.type_desc = 'NONCLUSTERED' AND I.name IS NOT NULL AND I.is_disabled = 1 Till Next Time

USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'<<Friendly Name>>' , @srvproduct=N'' , @provider=N'sqlncli' , @datasrc=N'<<AzureSqlServerName>>.DATABASE.WINDOWS.NET' , @catalog=N'<<databasename>>' EXEC master.dbo.sp_addlinkedsrvlogin   @rmtsrvname=N'AZR_RSZK_STG' , @useself=N'False' , @locallogin=NULL , @rmtuser=N'<<LocalAccount>>' , @rmtpassword='<<VeryStrongPassword>>' Till Next Time

DROP EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>]; CREATE EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>] WITH ( TYPE=RDBMS, LOCATION='<<SQL-ServerName>>.database.windows.net', DATABASE_NAME='<<DatabaseName>>', CREDENTIAL=  <<CrendentialName>> ); Till Next Time

-- --  Database Credential -- -- Drop db credential IF EXISTS(SELECT * FROM sys.database_credentials WHERE name = '<<CrendentialName>>') DROP DATABASE SCOPED CREDENTIAL <<CrendentialName>> ;  GO -- Create db credential CREATE DATABASE SCOPED CREDENTIAL <<CrendentialName>> WITH IDENTITY = '<<UserName>>', SECRET = '<<UserStrongPassword>>';  GO Till Next Time

-- Drop master key IF EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') DROP MASTER KEY; -- Create master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<<ReallyStrongPassword>>'; GO Till Next Time

-- Remove existing user DROP USER IF EXISTS [<<UserName>>] GO -- Create new user CREATE USER USR_CROSS_DBMS WITH PASSWORD = '<<Really Strong Password>>',   DEFAULT_SCHEMA=[dbo] GO -- Add user to the database owner role EXEC sp_addrolemember N'db_owner', N'<<UserName>>' GO Till Next Time