[Script Of Oct. 18] How to create linked server for SQL Database on Azure from local SQL Server

Oct. 18 Script Download: The script is available for download from https://gallery.technet.microsoft.com/How-to-create-linked-cb98fa7d. The sample code demonstrates how to create linked server for SQL Database on Azure from local SQL Server. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

0

[Script Of Feb. 23] How to get the information of last backup for all the SQL databases

Feb. 23 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-get-the-information-73e3b675. You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This T-SQL script is used to get the information of last backup for all the SQL Serve databases. You can find more All-In-One Script Framework…

0

[Script Of Nov. 17][Series 1] How to determine which version and edition of SQL Server Database Engine is running

Nov. 17   Script Download:   The articles is available for download from https://gallery.technet.microsoft.com/Determining-which-version-af0f16f6. You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.    In this chapter will talk about how to determine which version and edition of SQL Server Database Engine is running…

0

[Script Of Jun. 05] Find the SQL Server databases that contain a certain table or stored procedure

Jun. 05 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//Find-the-SQL-Server-5e53757b.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This T-SQL script will demonstrate how to find the SQL Server databases that contain a certain table or stored procedure. Some people…

6

[Script Of Apr. 16] How to list the column names into one row for each table in a SQL Server databas

Apr. 16 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-list-the-column-432bc5b4.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This script is to list the column names in one row for each table in a SQL Server database. Sometimes, people want…

5

[Script Of Apr. 13] How to disable all the triggers in a SQL Server database

Apr. 13 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-disable-all-the-03a79962.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This script is to disable all the triggers in a SQL Server database. Sometimes, people want to disable all the triggers in…

4

[Script Of Mar. 10] How to get the backup history of databases in SQL Server

Mar. 10 Script Download:   The script is available for download from https://gallery.technet.microsoft.com//How-to-get-the-backup-ea70af7f.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  This T-SQL script will demo how to get the backup history of databases in SQL Server. As many people asked how to…

4