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 a module, written by the community, that makes SQL Server administration much easier using PowerShell. Today, the module has more than 260 commands. Go get it and try it! If you have any doubt you can join the team on the #dbatools channel at the Slack - SQL Server Community . – Quick note –

Continue reading

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 entries

all of this for every single host on my entire estate. Obviously (for me :-) ) I decided to use PowerShell!

Continue reading

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 it few days ago.

Important note: This tip is not (yet?) available for all Microsoft’s product suite. You should confirm if this tip applies to the product you need.

Continue reading

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?

If you haven’t seen before, now we have a pencil icon on the top right corner that makes possible to suggest a change.

Continue reading

Which better way could I have to launch my blog if not with great news ?!

I am so happy and excited to announce that I will be speaking at  PowerShell Conference Asia  in Singapore!

On 28th of October I will be presenting two sessions with the following titles:

• Next step to your script…turn it into an Advanced Function
• SQLServer Reporting Services administration new best friend - PowerShell

Also, on 26th there will be 2 precon:

Continue reading