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

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

Aim: To use an SSIS Script Task to import csv files where the metadata is different for each file. Recently I had a task to do a one-off import of data from a large number of csv files where the metadata was different for each file. For example, the number of columns, names of column […]

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!