Using PowerShell as a port scanner

I've been having a lot of servers lately that have been stood up for me by the hero's in our IT department (that is not sarcasm - these guys are awesome) without having the right holes poked in the firewall.

For instance, SQL Server listens, by default on port 1433. (NOTE: Best practice for server hardening is to change the default instance name and port)

To test this, I'd been using a clunky old port scanner that I wasn't happy with.

I therefore googled and found this excellent blog post by jblanchard.

The portion that I actually use is this:

PowerShell port scanner:

1..1024 | % {echo ((new-object Net.Sockets.TcpClient).Connect("10.0.0.100",$_)) "Port $_ is open!"} 2>$null

I usually change the first bit to 1433 (or whatever specific port I want to check )

1433 | % {echo ((new-object Net.Sockets.TcpClient).Connect("Myserver.MyDomain.com",$_)) "Port $_ is open!"} 2>$null

Dark Theme in SSMS

My Life Begins today!

Make DB2 work again after server name has changed

There is an excellent guide on the steps needed to change the name of a server that is hosting DB2 LUW database that can be found on the Filmore Group Blog..

Link to an interesting article on big data / data scientists

https://multithreaded.stitchfix.com/blog/2016/03/16/engineers-shouldnt-write-etl/

Azure Storage, How fast are disks?

GRS Plus has a great article on Azure Storage Speed. 

 

 

Scripting out existing database mail configuration

SQL Server Central Artical on Scripting out Existing database mail configuration
I wanted to save this here so I can easily find it. Sorry - I have no value to add ¯\_(ツ)_/¯
All credit to Subhash Chandra at SQL Server Central.com

Grant ability to execute sp_who and sp_who2 without granting sysadmin privileges

Subhash Chandra  over at Sql Server Central has written what appears to be a great little procedure for granting someone the ability to run sp_who and sp_who2 without granting them sysadmin privileges.

Grat sp_who2 & who3 without granting sysadmin privileges

I have literally nothing to add :-D  Posting it here mostly so I can easily find it later.  Thanks, Subhash.