-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2017

SOS - Save Our Souls or SQL Operations Manager

On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry! Well I asked myself the same question and did some digging.



SQL Operations Studio a client tool for working with SQL Server... It was announced at the PASS summit last…

Read more

0 comments, 145 reads

Posted in The SQL DBA in the UK on 17 November 2017

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?


If you work in a hybrid environment with some databases stored on your on premises SQL Server instances and you also have deployed some databases to Azure SQL Database, maybe you have archived a bunch of data up…

Read more

0 comments, 182 reads

Posted in The SQL DBA in the UK on 15 November 2017

Connecting to an Azure SQL Databases

Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in order to safely and securly establish a connection.

In this short introductory video david shows you what you need to do,such as

  • Setting firewall rules 
  • Finding the connection string needed…

Read more

1 comments, 142 reads

Posted in The SQL DBA in the UK on 8 November 2017

Configuring Azure Data Sync

In this video David demonstrates how to configure Azure Data Sync 2.0 to synchronise an Azure SQL database with an "On premises" SQL server.

As the name suggests the Azure Data Sync tool allows you to synchronise data between Azure SQL databases and other databases both on Premises and in…

Read more

0 comments, 967 reads

Posted in The SQL DBA in the UK on 1 November 2017