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 […]

Aim: To script multiple database objects using the Object Explorer Details window in SQL Server Management Studio (SSMS). It’s not possible to script multiple objects at the same time from the Object Explorer window in SSMS. However, by opening the Object Explorer Details window from the View menu, you can navigate to the relevant folder […]

Aim: Schedule daily backups of an on-premises SQL Server database & copy it to an Azure virtual machine as part of a Disaster Recovery process. In the previous post, I set up a virtual network & machine in Azure that on-premises SQL Server databases can be backed up to as part of a Disaster Recovery process. If the on-premises […]

I recently encountered this error when attempting to run Add-AzureAccount using Azure PowerShell on a Windows 8.1 machine. The error occurred regardless of whether I was running PowerShell as a regular user or as Administrator. The browser based authentication dialog failed to complete. Reason: The server or proxy was not found. The error message gives […]

Aim: Create a virtual network & machine in Azure to which on-premises SQL Server databases can be backed up as part of a Disaster Recovery process. Create the virtual network: In the Azure portal, scroll down through the list of resources on the left-hand side & select Networks. In the Virtual Networks tab on the main pane, click “Create […]

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 […]

Aim: To allow remote connections to a SQL Server named instance. These steps are useful as a basic troubleshooting guide when you are experiencing problems connecting to a named instance from another computer. Open SQL Server Services in SQL Server Configuration Manager & start the Browser if it is stopped. If the Browser is disabled, enable it via […]

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!