• [Script of Oct 24th] Enroll SQL Server instances on multi server into an existing SQL Server Utility

    Script Download: EnrollInstances.zip
    http://gallery.technet.microsoft.com/scriptcenter/Enroll-SQL-Server-66687842

    This PowerShell sample script is used to enroll SQL Server instances on multi server into an existing SQL Server Utility. This script applies to SQL Server 2008 R2 and SQL Server 2012 editions.

    SQL Server Utility can manage the SQL Server environment as a whole through the concept of application and multiserver management in it, so after created one utility control point, administrator need to enroll instances of SQL Server into the SQL Server Utility. If your task included in below two scenarios, this script will be one good assistant.

    1. There are multiple managed instances need to be enrolled tothe SQL Server Utility.
    2. We can store the server and instance names in one .txt file.

     

    image image
    image image

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

  • [Script of Oct 23rd] Remove Notes Pages in PowerPoint (PowerShell)

    Script Download: RemoveNotesInPowerPoint.zip
    http://gallery.technet.microsoft.com/scriptcenter/Remove-Notes-Pages-in-e5d722da 

    This PowerShell script will remove all the notes pages form specified PowerPoint files. 

    In PowerPoint, people often use the notes function to record additional information. When these documents are shared, you may want to remove notes before sharing the document. Instead of removing the notes one by one, you can remove all the notes using the script.

     

    image image
    image image

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

  • [Script of Oct 22th] Convert PowerPoint Presentation to Word Document (PowerShell)

    Script Download: ConvertPowerPointToWordDocument.zip
    http://gallery.technet.microsoft.com/scriptcenter/Convert-PowerPoint-d65f3a82 

    This PowerShell script sample illustrates how to convert PowerPoint presentations to Word documents. Additionally, script will maintain the original format, layout for presentation and reduce the output file size. Supported version is PowerPoint 2010.  Converting PowerPoint presentations to Word documents is a frequently asked question in many public forums.

     

    image image
    image image

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

  • [Script of Oct 19th] Add Allowed Inline Downloaded MIME Types for one Web Application in SharePoint

    Script Download: mdlTransferAccessToExcel.zip
    http://gallery.technet.microsoft.com/scriptcenter/Import-Multiple-Tables-ad78b80f

    This script could be used to add allowed inline downloaded MIME types for one Web Application in Microsoft SharePoint Server 2010. 

    By default PDF files cannot open in browser. It is not listed as a safe MIME type. But for most companies, PDF files are widely used in their daily work, so it is necessary to add PDF to the allowed inline downloaded MIME types list.

    image image
    image image

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

  • [Script of Oct 18th] Import Multiple Tables from Access to Excel

    Script Download: mdlTransferAccessToExcel.zip
    http://gallery.technet.microsoft.com/scriptcenter/Import-Multiple-Tables-ad78b80f

    This VBA sample illustrates how to import multiple Access tables to Excel worksheets at once, meanwhile each worksheet‘s name will correspond to each table's name. It can be run on Excel 2003, 2007 and 2010.

    Users would like to import Access tables to Excel worksheets, meanwhile each worksheet's name will correspond to each table's name.

     

    image image
    image image

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