HTTP 403 error – PowerShell Remoting, Different Domains and Proxies

On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...

Offline Microsoft Documentation? Download it!

On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...

Contribute to Microsoft Documentation

Times have changed and Microsoft has changed the way we can contribute for documentation!
We already have access to the source...

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