[Script Of Aug. 18] Access Azure resource data by certificate authentication in Powershell

Aug 18 Script Download: The script is available for download from https://gallery.technet.microsoft.com/Access-Azure-resource-data-ca9cc9f7. The sample code demonstrates How to access Azure resource data by certificate authentication in Powershell. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

0

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

Jul. 13 Script Download: The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-get-the-information-cb205c18. The sample code demonstrates how to get the information of the last backup for all the SQL databases. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

0

[Script Of Apr. 18] Check if SQL system health extended event has incorrect specification

Apr. 18 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/Check-if-SQL-system-health-a79188f0. 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 used to check whether SQL Server system health extended event session has incorrect event specification. You can find more All-In-One…

0

[Script Of Apr. 18] How to create and deploy a SQL Server Agent Job in a VS 2010 SQL project

Apr. 18 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/How-to-create-and-deploy-a-092d4978. You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.  The SQL sample script can be used to create SQL Server Agent Job automatically. You can find more All-In-One Script Framework script samples…

0

[Script Of Apr. 18] How to check remote connection failure using PowerShell

Apr. 18 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-check-remote-5ceb87b9. 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 sample demonstrates how to check remote connection failure using PowerShell.  You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

0

[Script Of Apr. 15] How to monitor system performance and write to SQL Server using Powershell

Apr. 15 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-monitor-system-9ed44bab. 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 demonstrates how to monitor system performance and write to SQL Server using Powershell.  You can find more All-In-One Script Framework script samples…

0

[Script Of Apr. 14] How to create partition table quickly in SQL Server

Apr. 14 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-create-partition-2f6147a7. 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 demonstrates how to create partition table quickly in SQL Server, using the script that you will be able to generate the code needed to create…

0

[Script Of Apr. 13] How to view execution status of package in SSISDB in SQL Server

Apr. 13 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-view-execution-8864096e. 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 demonstrates how to view execution status of package in SSISDB in SQL Server 2012.  You can find more All-In-One Script Framework…

0

[Script Of Apr. 7] How to configure DTC to solve distributed transaction error using PowerShell

Apr. 7 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/How-to-configure-DTC-to-cc0f3f18. 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 shows how to configure DTC to solve distributed transaction error using PowserShell. You can find more All-In-One Script Framework script samples…

0

[Script Of Apr. 5] Determining which version and edition of SQL Server Database Engine is running

Apr. 5 Script Download:   The script is available for download from https://gallery.technet.microsoft.com/scriptcenter/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 by SQL Script. …

0