• [Script of Mar. 17] How to add the “Pin to Start Screen” context menu item to all files in Windows 8

    Posted 10 months ago
    by Huilin zhu}

    Script Download: 26698.zip 
    http://gallery.technet.microsoft.com/How-to-add-the-Pin-to-66fa0251

    This VBscript sample shows how to add the “Pin to Start Screen” context menu item to all files in Windows 8.1

    With Windows 8.1, Microsoft has restricted access to the 'Pin to Start Screen' menu command for 3rd party apps. The same thing could be implemented in Windows 8, any app was able to pin itself to the Start Screen, but not so in Windows 8.1. So this script can get the "Pin to Start Screen" context menu item unlocked for every file, and every file system object in Explorer.

    image image
    image

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

  • [Script of Mar. 14] How to calculate the increasing percentage of sales each month (T-SQL)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: SalesPercentage.zip
    http://gallery.technet.microsoft.com/How-to-calculate-the-de16efde

    This T-SQL script will demo how to calculate the increasing percentage of sales each month in a year.

    As some people asked how to calculate the increasing percentage of sales each month in a year. Sometimes there are several products in a table, we need find out the increasing percentage of a specified product in two nearby month.

    image image
    image

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

  • [Script of Mar. 13] How to delete user profiles older than a specified number of days in Windows

    Posted 10 months ago
    by Huilin zhu}

    Script Download: 26699.zip
    http://gallery.technet.microsoft.com/How-to-delete-user-d86ffd3c

    This PowerShell script sample shows how to delete user profiles older than a specified number of days.

    The computer usually used by more than one person, this often produces a large number of unique user profiles. Some of profiles are needless. (Profiles that have not been accessed in the past 60 days), users would like to clean up these legacy profiles. If we can provide a script that can help user to delete user profiles that is older than a specified number of days, it would be very helpful.

    image image
    image

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

  • [Script of Mar. 12] How to change the time synchronization interval in Windows (VBScript)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: 26816.zip
    http://gallery.technet.microsoft.com/How-to-change-the-time-83ea0f17

    This VBScript sample shows how to change the Internet Time Synchronization interval.

    Windows includes internet time synchronization scheduler to synchronize your clock automatically. But the default synchronization interval for this process is one week. There is no way to change this interval through the user interface. It has to be done using the registry editor. So this script sample can easily help user to do it.

    image image
    image

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

  • [Script of Mar. 11] How to check SQL Server stale statistics (T-SQL)

    Posted 10 months ago
    by Huilin zhu}

    Script Download: CheckStaleStatics.zip
    http://gallery.technet.microsoft.com/How-to-check-SQL-Server-4fefea34

    This T-SQL script will check SQL Server stale statistics that may cause performance issues.

    Some people asked how to find stale statistics for these statistics may cause performance issues. This T-SQL script will demo how to check stale statistics which have been updated for more than 1000 times in SQL Server 2008 R2 starting with Service Package 2 or SQL Server 2012 starting with Service Package 1.

    image image
    image

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