• [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 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 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 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 25th] Check SQL Server missing KB2277078 to prevent leak of security audit entries

    Script Download: CheckSQLInstanceVersionNumber.zip
    http://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-missing-ac29a3ed

    This script will demo how to check SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUserStore.

    When we create and enable a SQL Server audit on a computer that is running Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2008, the TokenAndPermUserStore cache store continues to grow in size. Additionally, the size does not decrease even when we run the DBCC FREESYSTEMCACHE command, this issue occurs because a memory leak occurs when a SQL Server audit is enabled on an object. To fix it, for different versions, we should install the corresponding updates.

     

    image image
    image image

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