Category Uncategorized

Customise SSMS query tab information

Aim: To remove unnecessary information from SSMS query tabs, to make them more useful & easier to read. I was reminded of this very useful customisation in SSMS the other day while reviewing Brent Ozar training notes. By default, SSMS includes the file (query), server, database & login names in the query tab. Unless these […]

Apparent Back Up Database Task Failure

Some time ago, I encountered an apparently failing backup job on a SQL Server 2008 R2 instance. The job used the Back Up Database Task in a maintenance plan to back up multiple databases & the apparent failure was due to the removal of one of the databases from the instance without it being removed […]

Azure Portal: Security Rules

As of early 2016, I find the new Azure portal very unintuitive to navigate & unfortunately the Microsoft documentation seems to be work-in-progress, so I’m starting a chain of blog posts to help me remember where useful settings are. Inbound & outbound security rules: In Resource groups, click on the appropriate resource group (e.g. testRG) to expand the […]

Kevin Kline

Career and Technical Advice for the IT Professional


Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert


A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!