• [Script of Oct 31st] Modify Picture Compression Resolution Settings in PowerPoint 2007 (PowerShell)

    Script Download: ModifyPictureCompressionResolutionSetting.zip
    http://gallery.technet.microsoft.com/scriptcenter/Modify-Picture-Compression-e669d72e 

    This PowerShell script demo illustrates how to modify picture compression resolution settings in PowerPoint 2007.  This question is asked by many users in the TechNet forum. They want to pre-configure picture compression in PowerPoint 2007.

     

    image image
    image image

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

  • [Script of Oct 30th] Get Mailbox Usage Report in Microsoft Exchange 2010

    Script Download: GetMailboxUsageReport.zip
    http://gallery.technet.microsoft.com/scriptcenter/Get-Mailbox-Usage-Report-72a72976 

    This script creates mailbox usage report in Microsoft Exchange 2010. It will use IssueWarningQuota and TotalItemSize to calculate the usage rate.

    In a real world, IT Administrators may want to know the usage rate of specific mailboxes. They can use Exchange Management Shell to get total item size and issue warning quota for mailboxes very easily. But issue warning quota could be set for all of the mailboxes in a database or on a per-mailbox basis. IT administrators need a script to help them to decide which quota is applied. Then, they want to use correct issue warning quota to calculate the mailbox usage.

     

    image image
    image image

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

  • [Script of Oct 29th] Switch between Windows Server core and Windows Server GUI in Windows Server 2012

    Script Download: SwitchGUIServerCORE.zip
    http://gallery.technet.microsoft.com/scriptcenter/Switch-between-Windows-9680265d 

    This PowerShell script sample can be used to switch from a full installation user interface server to the server core mode in Windows Server 2012.   It can also switch Windows Server 2012 from the server core mode to the full UI mode.

    After setting up Windows Server 2012, IT Administrators may need to convert it to the server core for some security reason.  Sometimes, it's more convenient for IT administrators to switch back to the UI mode to modify some configurations.  This script sample can help you switch between the two modes in Windows Server 2012.

     

    image image
    image image

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

  • [Script of Oct 26th] Publish report to Reporting Services in SharePoint Integrated Mode

    Script Download: PublishReportInIntegratedMode.zip
    http://gallery.technet.microsoft.com/scriptcenter/Publish-report-to-0ca69662 

    This VB.NET sample script illustrates how to publish a report from a computer path to Reporting Services in SharePoint integrated mode. This script applies to SQL Server Reporting Services 2008 R2 integrated with SharePoint 2010.

    Starting from SQL Server 2008 R2, the rs utility is supported against report servers that are configured for SharePoint integrated mode as well as servers configured in native mode. Today, most of the available script samples correspond to the native mode.  This sample script will ease the problems in below two scenarios:

    1. The report server configured to SharePoint integrated mode.
    2. The published report use embedded data source or shared data source.

     

    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