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

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

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!