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.

I will be speaking @ Tuga IT 2018

Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon! This edition will have: 4 full-day workshops 38 breakout sessions (1 hour) 5 deep dive sessions (2 hours) That is over 72 hours of content delivered by 44 awesome speakers,… Read more

2 comments, 108 reads

Posted in Cláudio Silva on 6 July 2018

Did you know…you can change the default file encoding for new query on SSMS?

If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules (Stored Procedures, functions, etc) and the steps I'm following (roughly speaking) for converting are: Open new query… Read more

1 comments, 252 reads

Posted in Cláudio Silva on 5 June 2018

SQL Saturday #731 Athens 2018

In less than two weeks (on 16th June) it's time for SQL Saturday Athens and I'm proud to announce that I will be speaking! This will be my first SQL Saturday ever both as speaker and attendee outside Portugal so I'm especially thrilled and excited to be part of it!… Read more

0 comments, 136 reads

Posted in Cláudio Silva on 4 June 2018

Learn, Evolve and Giving Back – TSQL Tuesday #102

This month’s T-SQL Tuesday is brought to us by Riley Major? (b | t) and he encourage us to talk about how we are helping by giving back to our community. This is the 102nd edition of TSQL2sDay - an Adam Machanic’s (b | t) brainchild. Let's go back for… Read more

0 comments, 178 reads

Posted in Cláudio Silva on 8 May 2018

Using CAST() function with User-Defined Data Types…Did you know…

I'm converting some Firebird database code to T-SQL and I'm seeing a lot of code that doesn't work in the same way that SQL Server. No surprise - I already expected that but for those that still say that "all engines/databases are equal"..."is SQL right?" here is another proof that… Read more

1 comments, 2,605 reads

Posted in Cláudio Silva on 2 May 2018

dbachecks – Going parallel – Cut off your execution times

On one of the last clients I have worked, I have implemented dbachecks in order to get the state of art and know how cool or bad the environments are before start knocking down the bad practices. This client has seven different environments with more than 100 instances and more… Read more

5 comments, 243 reads

Posted in Cláudio Silva on 26 April 2018

dbachecks – Setting temporary configuration values

dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more than 2600 downloads just from the PowerShell gallery. The module has about 110 configurable checks that make our live easier! Today I will write about an option that I think… Read more

1 comments, 1,716 reads

Posted in Cláudio Silva on 24 April 2018

Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I haven’t seen for some time. The error message is the following: Msg 206, Level 16, State 2, Line 4 Operand type clash: datetime2 is incompatible with int This ringed the… Read more

3 comments, 2,327 reads

Posted in Cláudio Silva on 6 April 2018

dbachecks – A different approach for an in-progress and incremental validation

dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't know dbachecks, we have released a good amount of blog posts that will help you: Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances by Rob Sewell introducing dbachecks… Read more

1 comments, 274 reads

Posted in Cláudio Silva on 22 February 2018

dbachecks – Using Power BI dashboards to analyse results

For the last couple of months, members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use dbachecks launch - the blog… Read more

9 comments, 424 reads

Posted in Cláudio Silva on 22 February 2018

Using dbatools to verify your SQL Server instances version compliance

One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service Packs, Cumulative Updates or Security Updates). Recently, dbatools added a new command that turns this validation a piece of cake. Thanks to Simone Bizzotto (@niphlod) for baking up the command… Read more

3 comments, 401 reads

Posted in Cláudio Silva on 23 January 2018

New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute

Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know about it, sp_WhoIsActive is a stored procedure that provides detailed information about the sessions running on your SQL Server instance. It is a great tool when we need to… Read more

2 comments, 2,249 reads

Posted in Cláudio Silva on 5 December 2017

Using Common Table Expression (CTE) – Did you know…

Today I will write just a short blog post to do a quick reminder! I still hear a lot of people suggesting CTEs because they think it works like a temporary table (you populate the table and then it can be/is reutilized). It doesn't! From de documentation: Specifies a temporary… Read more

0 comments, 392 reads

Posted in Cláudio Silva on 30 November 2017

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,365 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) and we will "Let’s get all Posh – What are you going to automate today?" Read more

4 comments, 504 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. Read more

1 comments, 982 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 Read more

0 comments, 1,321 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, 315 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, 204 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

10 comments, 3,196 reads

Posted in Cláudio Silva on 27 July 2017

Older posts