PowerShell for the DBA

In this article I talk about how command history can fool us. So you think you're repeating that command with Up Arrow? Module precedence and Command precedence can cross our plans.

Continue Reading...

In this article I talk about how I transformed a blog post into a PowerShell script. More particular Koen Verbeeck's article on SSISDB Best Practices.
It checks some settings on a SSISDB catalog and SSIS server and reports what complies and what not.

Continue Reading...

In this article I talk a little bit about Time Protocols.
A DBA too might ran into trouble because of failing time synchronization. So this is what I learned a while ago about setting the protocol right.

Continue Reading...

In this article I talk about SQL Server Protocols.
You can take a look at both client and server side protocols, and you don't necessarily have to do it with SQL Server Configuration Manager.

Continue Reading...

In this article I talk about dates that sometimes do and sometimes don't exist.
Discover the difference between SQL Server and Excel, and PowerShell.

Continue Reading...