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

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

This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services.

 
This module, as of today, provides 28… Read more

3 comments, 234 reads

Posted in Cláudio Silva on 12 July 2017

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 corrupted
  • you need to rollback a password change
  • know the list of permissions on a specific day (the scenario: “yesterday was OK, today is not working” due permission changes)

 

Do you see…

Read more

0 comments, 20 reads

Posted in Cláudio Silva on 22 June 2017

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 SQLCMD mode in SSMS?

First let me say that sqlcmd has a command line utility called sqlcmd.exe which allows to connect and run scripts from the command line.… Read more

3 comments, 19 reads

Posted in Cláudio Silva on 14 February 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, 22 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, 19 reads

Posted in Cláudio Silva on 19 January 2017