Data Insights Asia

Welcome to the Data Insights Asia repo. This is public repositry of resources, samples, and demos created and used by the Data Insights Asia team of Field Engineers. The team consists of Microsoft field engineers based in countries including Australia, New Zealand, Singapore, Malaysia, Indonesia, Philippines, and Thailand to name a few. This brings great benefits to this repository through a wide breadth of culture and diversity, resulting in greater resources to meet your needs.

All code is provided "as is" as per the MIT License.

Releases

This project uses SemVer for versioning. While the following is an overview of the offical releases, for the detailed changes, see the tags on this repository.

Unreleased

• Added
  • /AzureSQL/XEvents_ErrorTrap

0.5.0

• Added
  • /Scripts/AlwaysOn/ReplicaHealth.sql
  • /Scripts/Authentication/AuthenticationSummary.sql
  • /Scripts/Authentication/ProtocolSummary.sql
  • /Scripts/Authentication/README.md
  • /Scripts/Authentication/RemoteConnectionsUsingNTLM.sql
  • /Scripts/BackupRestore/NoRecentBackups.sql
  • /Scripts/Configuration/DbMirroring.sql
  • /Scripts/QueryPerformance/SystemHealthSession.QueryPlans.sql
  • /Scripts/QueryPerformance/ExtendedEvents_Get_DeadLocksFromSystemHealth_SingleServer.sql
  • /Scripts/VLFs/grow_transaction_log_by_desired_vlf_size.sql
  • /Scripts/QueryPerformance/OpenTransactions.sql
  • /Scripts/Security/DatabasePermissions.sql
  • /Scripts/Security/ExpiredCertificates.sql
  • /Scripts/Security/NestedDatabaseRoles.sql
  • /Scripts/Security/README.md
  • /Scripts/Security/SqlLoginPasswordExpirying.sql
  • /Scripts/Security/StartUpStoredProcedures.sql
  • /Scripts/Tempdb/TroubleShootFullTempdb.md
  • Used standard header across SQL files

0.4.0

• Added

  • /Scripts/AlwaysOn/AutomaticSeeding.sql
  • /Scripts/PolicyBasedManagement/PolicyFunctions.ps1

• Updates to

  • /Scripts/ExportAndMigration/ExportAgentJobs.ps1
  • /Scripts/VLFs/VLFsReport.sql

0.3.0

• Added the Scripts
  • /IO/AutoGrowth.sql
  • /QueryPerformance/SystemHealthSession.WaitInfo.SQL2016.sql

0.2.1

• Script updates
  • Improved Pipeline support in /Configuration/UserOptions.ps1

0.2.0

• Script Updates
  • Renamed /Export to /ExportAndMigration
  • Added /ExportAndMigration/README.md

0.1.0

• Added the Scripts
  • /Export/ExportAgentJobs.ps1
  • /IO/IOFileStats.sql
  • /IndexAndStatistics/StatisticsLastUpdated.sql
  • /QueryPerformance/ParallelQueries.sql
  • /QueryPerformance/Recompiles.sql
  • /QueryPerformance/WaitingTasks.byPaulRandal.sql

Contributing

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.