Dear reader, before continue please open a PowerShell console and run the following command: Install-Module -Name dbatools If you are doing this on the date of this blog post, you have just installed dbatools v1.0! After more than 200 commits, the work of more than 20 contributors and 20 days since the last published version, dbatools v1.0 is live! To all of you that have contributed direct or indirectly to the module a big thank you!

Continue reading

This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I have raised on my blog post Don’t cutoff yourself with dates in T-SQL – Did you know… . As you could see from that blog post, my screen shots were from VSCode and in this case using mssql extension, but this happens also on SQL Server Operations Studio . “But why are my datetimeoffset values on VSCode being showed in that format?

Continue reading

This month’s T-SQL Tuesday is brought to us by Ewald Cress ( blog | twitter ) and is all about “folks who have made a difference” in our careers. Thank you, Ewald! This is a great topic! Here is my short list Paulo Silva ( in ) He was my first boss in the IT world! I was his apprentice when I started my internship. He was going to move to a manager position and I had to continue his work.

Continue reading

Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using. Let me introduce to you the PowerShell Modules Central PowerShellModulesCentral is a GitHub repository that was founded as a central hub to a list of PowerShell modules that people know/use. Each module has a file describing its name, basic information about the module, as well as one or more blog posts/videos from people that have written about or used them.

Continue reading

Author's picture

Cláudio Silva

Data Platform Architect and PowerShell lover.

Data Platform Architect

Portugal