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.

The goal of this script is to fix explorer.exe blank message on startup in Windows 8.

Due to some unexpected reason, some users get explorere.exe blank error on start up. This script is to fix it..

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

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.

We can use Get-OSCNotEncryptedMasterKey to identify the database master key which is not encrypted by service master key. By default, this script uses Windows Authentication to connect to your SQL Server. If you want to use SQL Server Authentication, just uncomment some code in this script. 

SQL Server uses a hierarchy of keys and certificates when a database is enabled for Transparent Database Encryption [TDE]. At the upper levels of the hierarchy, the Service Master Key [SMK] encrypts the Database Master Key [DMK] for the master database. The Database Master Key [DMK] encrypts and protects the Certificate and Database Encryption Key [DEK] involved in the encryption of the user database. After enabling a user database for TDE, you will be able to remove the SMK encryption of the DMK for the master database. If you restart the SQL Server at this point, the database startup will encounter error 15581 and prevent the database from starting up. In some situations, the LogWriter will hang with a wait_type of WRITE_LOG and prevent any transactions from committing in this database. Even though it is possible to remove the SMK encryption for the master database DMK, it is not recommended to do this.

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

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 PowerShell script sample shows how to convert Visio page file to .png file.

Many companies generate technical visuals in Microsoft Visio and would like to be able to share this information on their corporate sites. The problem, however, is that most users would not be able to view the visuals in this format. One of the ways of solving this problem is converting Visio diagrams to a more universal format like PNG.  But doing it manually would be time consuming, this sample can help us to batch convert Visio files, it would be very convenient.

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

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 T-SQL script will demo how to find all the logins without user mapping in a specified SQL Server database. Besides, it will list all the users and logins, except for server roles and server principals with names enclosed by double hash marks “##” which are for internal system use only.

Some people may encounter an error "The login already has an account under a different user name" when creating a user account for a specified database. So they need to create a user with another login. If there are many logins, it is not easy for them to try one by one. It will be better if there is a script to find all the available logins.

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

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 VBScript shows how to remove all network printers on a computer.

Remove all network printers is a frequently asked question in many public forums.

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