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

Archives: November 2017

Server Roles and Azure Active Directory in an Azure SQL Database

This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login a server roles and how to give an Azure Active Directory user permissions to an Azure SQL database.




You can download the free ebook: Putting Your Head in the Cloud:…

Read more

0 comments, 423 reads

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

An Introduction to Azure SQL Databases

This David's SQL Server Saturday talk titled an introduction to Azure SQL Databases


It does pretty much what is says on the tin. it gives an Introduction to Cloud Computing and Azure SQL Databases

Read more

0 comments, 2,112 reads

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

Monitoring and Alerts with Azure SQl Database

Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL database and build a dashboard to monitor the metrics of your Azure SQL database




You can download the free ebook: Putting Your Head in the Cloud: An Introduction to…

Read more

0 comments, 1,113 reads

Posted in The SQL DBA in the UK on 22 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, 525 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, 661 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, 284 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

1 comments, 1,233 reads

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