“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands

On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...

SSRS Report Deployment Made Easy – 700 times Faster

Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...

Have you backed up your SQL Logins today?

Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...

It is possible to run scripts inside SSMS on multiple instances without using CMS? Yes, it is!

Today I will write about an option that is less known/used in the SSMS tool. The ‘SQLCMD Mode’ option.

What is...

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...

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].”....