T-SQL

Pillars of PowerShell: SQL Server – Part 1

Introduction This is the sixth and final post in the series on the Pillars of PowerShell, at least part one of the final post. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS PowerShell + SQL Server is just cool! You will see folks talk about the ability to perform a task…

Script to Collect Database Information Quickly

As a DBA there are occasions where we are required to collect details from a database which can be used for further analysis. For example, getting the status of the database (i.e. File Size, Free Space, Status of the database, and who is the current owner of the database). This kind of information is required,…