Rationalisation of Database with Powershell and T-SQL part two
In the previous post I showed the script to create an Excel Workbook, colour coded showing the last used date for all of the databases on servers in my sqlse...
Rob Sewell
Rob was a SQL Server DBA.
Now he just helps people with PowerShell, Azure, Automation, and Data.
He is a Cloud and Data Center MVP and a Data Platform MVP, co-leader of Data South West UK user group and PSConfEU organiser. One of the Admins for Data Saturdays https://datasaturdays.com
He is a proud supporter of the Data and PowerShell communities.
He has a fabulous beard
Recent Posts
Rationalisation of Database with Powershell and T-SQL part one
I have recently been involved in a project to rationalise databases. It is easy in a large organisation for database numbers to rapidly increase and sometime...
Why You Should Visit the Sponsors at #SQLSatExeter and Other Community Events
SQL Saturdays and other community events rely on sponsors and you know that you will often get entered into a raffle for a prize in exchange for your contact...
Viewing SQL Endpoint Permissions with PowerShell
A quick and simple post today as I have been very busy. I needed to list the users with permissions on mirroring endpoints today so I wrote this script and f...
Using PowerShell to get Azure Endpoint Ports
A quick blog today. I was reading this blog post about How to read the SQL Error Log and I thought I would try some of the examples. I started my Azure VM us...