We came across a scenario where database bak files being created from long time which are no more in use...  Read more...

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?   Read more...

How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.  Read more...

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...

This article provides a practical example of how Powershell can be used by DBAs.  Read more...

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...

Using Powershell with SMO, learn to alter or move indexes easily in this new article from Zach Mattson.  Read more...

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?   Read more...

Learn how to discover the TCP port for a SQL Server instance from the registry using Windows Powershell.  Read more...