Measure Twice, Cut Once

TweetG’day, As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open the relevant firewall port – normally 1433 for a…

TweetG’day, Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement. It’s true, you can! Mostly I never see this done. Maybe it…

TweetG’day, Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance using SQL SERVER Management Studio (SSMS) Now, I could…

TweetG’day, Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this often results in simply delivering code that works –…