• [Script of Mar. 10] How to detect system health extended event session incorrect event specification

    Script Download: CheckIncorrectEventSpecification.zip http://gallery.technet.microsoft.com/How-to-detect-system-40857284 This T-SQL script will demo how to detect system health extended event session incorrect event specification in SQL Server 2012. Every instance of SQL Server has a default extended...
  • [Script of Mar. 11] How to check SQL Server stale statistics (T-SQL)

    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...
  • [Script of Mar. 12] How to change the time synchronization interval in Windows (VBScript)

    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...
  • [Script of Mar. 13] How to delete user profiles older than a specified number of days in Windows

    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...
  • [Script of Mar. 14] How to calculate the increasing percentage of sales each month (T-SQL)

    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...