19Jan

Find and fix SQL Server databases with empty owner property using dbatools PowerShell module

0 Comments
PowerShell, SQLServer, SSMS, syndicated

A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”. The following image shows the error message. I have seen this message before so I know that the problem is that the database does not have a defined owner. We can confirm this by running […]

04Jan

New MVP @ Redglue – Cláudio Silva

0 Comments
mvp, PowerShell

What a start of 2017 for us and for Cláudio Silva, as he is now a MVP (Most Valuable Professional) for Powershell. On top of Cláudio contributions for Powershell community there is dbatools project (https://dbatools.io) and speaking events like SQLPort, PowerShell Portugal communities and SQLSaturday. You can find his MVP profile here: https://mvp.microsoft.com/en-us/PublicProfile/5002259?fullName=Cl%C3%A1udio%20%20Silva Congratulations Cláudio! twitter: @ClaudioESSilva linkedin: https://www.linkedin.com/in/claudioessilva […]

19Dec

[PowerShell] Write-Progress can slow down your scripts – Performance Tip

2 Comments
performance, PowerShell, Write-Progress

As SQL Server Data Architect who works everyday with PowerShell, I’m used to writing my own scripts and every time I need to go through a list of items I like to have a progress bar which tells me where I am and how far I am from the end of the execution. We have some scenarios […]

Page 2 of 212