PowerShell for the DBA

<img alt="" src="/images/0/6/3/c/7/063c716b36a76da976c538b0102848f3cb8520e0-compare1.png" />

Check IFI with PowerShell

04, Jul Klaas

In this article I show how to use the Where method with the Split option to quickly assign two variables. As an example we will check if our SQL Service Accounts have the Instant File Initialization Privilege.

Continue Reading...

<img alt="" src="/images/8/1/6/9/5/8169561a2c74fcf9ec9fc7e2dd6d3f9ce1513ad5-gcm1.png" />

The day History stopped repeating itself

29, May Klaas

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...

<img alt="" src="/images/1/1/b/e/0/11be0afeb1109fdfc402a8c6ec1c8cf283b5fc80-logsize.png" />

SSISDB Best Practices

22, May Klaas

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...

<img alt="" src="/images/3/1/e/7/0/31e70099c3afe03afd6ce8593835c136ae68a143-ntp.png" />

Time Synchronization

11, May Klaas

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...

<img alt="" src="/images/c/4/a/3/7/c4a37d2d40e618932009271c3a625953491c368a-get-dbaclientprotocol.png" />

Sql Protocols

07, May Klaas

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...