Omid is a DBA with 12 years' experience and has been working with SQL Server since version 7.0. For the last 7 years he has been working in the finance industry in London and São Paulo, specialising in performance tuning. His SQL healthcheck is available at https://github.com/SpeedySQL.
PowerShell is an ideal tool for doing health checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid's health check allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories. … Read more