DBAs! We all know the pain of creating new data or log files at new location when files on old location are about to full. Post that we have to restrict growth of files on old location. This does not seem like big thing, but it becomes are big challenge when number of databases grow from just few to hundreds, and when the size of databases varies greatly.
Well, no need to worry anymore. Now, you can use my Space-Capacity-Automation solution. I created this procedure to reduce the SQL Server DBAs problems in Database and Space Management. This solution can be used with below parameters to accomplish variety of tasks:-
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.