Tag Archives: Database Administration


JIRA SQL Server Network error IOException

JIRA SQL Server

Was running into the following error while installing JIRA: “Network error IOException: Connection refused”. It seems that the SQL Server Express installer doesn’t enable the TCP/IP protocol by default.

Read More →

SQL Remote Access Azure VM’s

SQL Remote Access Azure VM’s

Opening up SQL Server instances hosted on Azure VM’s is just one of those manual, repetitive and error-prone tasks. Given that I’m spinning up new VM’s in a daily basis, I’ve decided to automate the process using PowerShell and SQL Server Management Objects (SMO). This makes setting up SQL Remote Access on Azure a simple task.

Read More →

Scripting SQL Server installations

Scripting SQL Server installations

I was addressing performance issues onsite just a couple of weeks ago and while waiting for the right authorizations, access tokens and whatever you need nowadays to just run some scripts…, one of the developers approached me and asked for some insights on how to Scripting SQL Server installations.

Read More →

SQL Emergency maintenance PowerShell

SQL Emergency maintenance PowerShell

Moving SQL server data files just isn’t something I do very often. And I therefore tent to forget which actions are involved. To solve this, I’ve prepared a Powershell script to automate the steps

Read More →

Management Studio Custom Shortcuts

Management Studio Custom Shortcuts

A DBA recently attended me on the “Query Shortcuts” option within Management Studio. Now, I have to admit that I’m lazy from time to time and a horrible typist on Monday mornings and therefore using the option a lot, especially while debugging.

Read More →

SSMS color code your environments

SQL Server SP_what

Ever executed a script on the wrong environment? Neither do I… but for those who do need a visual queue as to which server you are on, I’ve included some helpful steps below:

Read More →

Group Server Queries: ad hoc management

Group Server Queries: ad hoc management

Recently, I worked on a project which involved auditing a dozen of SQL server instances. A process I usually script upfront however, due to constraints on my time and some local challenges (a very “opinionated” customer) wasn’t able to do so. Fortunately I discovered this somewhat unknown “Group Server Queries” option a while ago, so gave it a try and was pleasantly surprised.

Read More →