• Posts
    SQL Server PowerShell
  • About

Cláudio's Blog


SQL, PowerShell, and more from a SQL Server DBA

dbatools - Exceptions

Posted on June 7, 2022

Who doesn’t like a good red and verbose exception? [Read More]
Tags: dbatools Exceptions Logging PowerShell SQLServer syndicate

dbatools - Rich Datatypes

Posted on June 2, 2022

Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. [Read More]
Tags: dbatools PowerShell SQLServer syndicate

A (big) SQLPackage caveat

Posted on December 29, 2021

Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just have played a handful of times with FTS, mostly in a didactic way, and not so much in the perspective of... [Read More]
Tags: SQLServer syndicated DACPAC IndexedViews FullTextSearch FTS SQLPackage

Recover database encrypted modules code with dbatools

Posted on September 22, 2020

This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it’s simple to overcome this when we have the right permissions. [Read More]
Tags: Automation dbatools Decrypt PowerShell Scripting Security SQLServer syndicated WITH ENCRYPTION

When one of your DBA colleagues leaves the company, what is your checklist?

Posted on September 3, 2020

Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. [Read More]
  • Older Posts →

Grab your copy from Manning

  • RSS
  • GitHub
  • Twitter
  • LinkedIn

Cláudio Silva  •  2022

Theme by beautiful-jekyll