SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cláudio Silva

I am a SQL Server DBA working from SQL2000 to SQL2016. I love using PowerShell to make my life ridiculously easier! I contribute to dbatools PowerShell open source module.

Archives: January 2017

Analysis of DBA professionals salary’s 2017 using PowerBI

On the 5th of January,  Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional Salary Survey” blog post.

Today I bring some data analysis based on the Excel raw data.

I will be using Power BI Read more

0 comments, 352 reads

Posted in Cláudio Silva on 23 January 2017

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

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.

SSMS 2008 error opening database properties

I have seen this message before so I know that the problem is that the database does… Read more

0 comments, 377 reads

Posted in Cláudio Silva on 19 January 2017