• [Script Of July 24] How to get detailed information of a SQL Server (T-SQL)

    image image
    July
    24
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-get-detailed-ac767add.  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 detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

    As many people ask how to get general information of SQL Server, this script will demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script Of July 16] How to modify send connector's address space

    image image
    July
    16
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-modify-send-75ac2030.  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 updates address space for specific send connectors in Microsoft Exchange Server 2010.

    Send connectors create a logical connection to remote e-mail systems and are responsible for outbound transmission of e-mail messages. If your organization requires a Send connector with specific configuration options, or if you don't use the EdgeSync process, you have to manually configure Send connectors. Sometimes, you need to add or remove dozens of domains in the address spaces. So you want a script to complete this task more efficiently.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script Of July 22] How to extract metadata from report server database (T-SQL)

    image image
    July
    22
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-extract-metadata-bdd38e62.  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 extract metadata about reports.You can use this script for reference when you want to find information about dataset, data source of a report.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script Of July 11] How to list tables with index issues in a SQL database

    image image
    July
    11
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/scriptcenter/How-to-easily-run-an-0c0eb47a/.  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 will demonstrate how to list tables with the following index issues in a database:

    • Tables with no index
    • Tables with no clustered index but with non-clustered index
    • Tables with more indexes than columns

    We provide this script for people to reference. If you want to know tables with no index or clustered index, or tables with more indexes than columns, this script will provide some help.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Jul.1] How to enable Enterprise Mode in Internet Explorer 11

    Script Download:  
    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This script sample shows how to enable Enterprise Mode in Internet Explorer 11.

    Enterprise Mode is a new feature in Internet Explorer that allows businesses to use old web applications in modern versions of IE. This feature is designed to help businesses who still need Internet Explorer 8 for some reason to upgrade to a more modern, secure browser.
    But the Enterprise Mode for Internet Explorer 11 is turned off by default. And this script can help you easily enable the Enterprise Mode.

    image image
     image


    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingaller
    y