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.

DELETE data on SQL Server HEAP table – Did you know…

Before I complete my question let me provide context.

I’ve received an alert saying that a specific database could not allocate a new page (disk was full)

The message that you will see on the SQL Server Error log is:

Could not allocate a new page for database ” because…

Read more

5 comments, 2,013 reads

Posted in Cláudio Silva on 26 September 2017

Someone is not following the best practices – dbatools and Pester don’t lie!

This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t). Together “Let’s get all Posh – What are you going to automate today?”

I have written some blog posts on how I use PowerShell to automate mundane tasks or some other… Read more

3 comments, 263 reads

Posted in Cláudio Silva on 12 September 2017

“Invalid class [0x80041010]” error when trying to access SQLServer’s WMI classes

I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm if they are in “running” state.

— Quick note —
For those who don’t know, dbatools is… Read more

1 comments, 329 reads

Posted in Cláudio Silva on 7 September 2017

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 to enrich the monitoring, and to accomplish this I will need to:

  • Find a folder
  • Create a sub folder
  • Copy bunch of file
  • edit a ini file to verify/add new…

Read more

0 comments, 295 reads

Posted in Cláudio Silva on 4 September 2017

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 on Microsoft Documentation!

Download Microsoft Documentation

Did you know that we can download PDF files with Microsoft Documentation?

I did not know until my colleague called my attention to… Read more

0 comments, 66 reads

Posted in Cláudio Silva on 30 August 2017

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 code from some programs. One example is PowerShell, that has an GitHub repository where anyone can contribute!

Now anyone can contribute to the documentation too!

How and where?

Read more

2 comments, 48 reads

Posted in Cláudio Silva on 28 August 2017

“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 Microsoft PowerShell module ReportingServicesTools to automate several steps that otherwise would be a big time consumer.
After a couple of shares and re-tweets, my friend Rob… Read more

9 comments, 1,906 reads

Posted in Cláudio Silva on 27 July 2017

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

7 comments, 505 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, 82 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, 73 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, 65 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, 61 reads

Posted in Cláudio Silva on 19 January 2017