Select Page

PowerShell: Monitoring Servers

I’m relatively new to PowerShell. I’ve known about it and have dabbled with it here and there but as of lately I’ve been digging in a bit deeper. One of my projects was to build a homegrown monitoring system. Being a DBA it’s natural that I...

Deleting a duplicate record

Recently a friend of mine asked me about deleting a duplicate record from a table without deleting both records. Having been in a situation I drafted up a sample script and emailed it to him. DECLARE @tbl1 TABLE ( id int, color varchar(50) ) INSERT INTO @tbl1 (id,...

Working with Sketch3

First off let me start by saying that this is a very easy to use and affordable editor. I actually learned about Sketch3 (developed by Bohemiancoding.com) from attending courses by BitFountain.io. I signed up for a few iOS development courses and the Sketch3 design...