SQLAdmin

This morning I had to find the total file size of backup files on a collection of databases for a given system. Actually the answer can be ...

I have a ongoing task of refining an automated collection (instrumentation) of computers in the organisation running a SQL Server database i...

With PowerShell v2 we were given a more complete exception handling than the trap-handling in PowerShell v1. This is a quick spike on throw...

For a long time I have checked the databases by DBCC CHECKDB , but I would like to check the database in PowerShell with SMO to include the...

I would like to compare the structure of two databases as in development vs production. The tool SQL Compare from Red-Gate I have used on ...