Wednesday, 29 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: An Introduction to Cloud Computing and Azure SQL Database

As always if you have a question, please leave a comment

Tuesday, 28 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

Wednesday, 22 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 Cloud Computing and Azure SQL Database

As always, if you have any questions please leave them in the comments.

Friday, 17 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 week and it hit public preview on Wednesday.

"ARE THEY GETTING RID OF MANAGEMENT STUDIO?????" I hear you scream, well  that was my initial thought too.

Fear not though, Management Studio is hear to stay, at least for now, according to this interview  in visual studio magazine of Microsoft executive  Rohan Kumar.

https://visualstudiomagazine.com/blogs/data-driver/2017/11/sql-operations-studio.aspx

Q: Will this tool replace SSMS?
A: It is not in our roadmap.

It's not a No. So not necessarily conclusive. "It is not in our roadmap" - I keep adding a "yet" to the end of that sentence. Road-maps do change overtime but I think we can assume that SQL Operations Manager will be around for a while yet.

I downloaded SQL Operations Studio earlier today and from the download page I can instantly how this differs from SQL Server Management Studio. Its cross-platform! Download SQL Operations Studio

You can run SQL Operations Studio  on Linux, Mac OS and Windows - Management Studio  only  runs on Windows.

SQL server 2017 can run on non-windows operating systems, its stands to reason that Microsoft might want a client tool that can connect and work from SQL Server on non windows operating system too. SQL Server is now multi-platform!

I have heard SQL Operations Manager being  described as SSMS lite - I have also heard and seen questions asked on social media such as, "is SQL Operations Manager for Devs?" The official answer according to the interview is  "it's for Developers and Ops" 
Hmmm Dev Ops maybe? - everybody's favourite buzz word at the moment.

From the quick look around SOS I have managed to squeeze in this week it has a different look and feel to Management Studio.

Anyway we'll have a look at SQL Operations Studio in a  more detail and report back in a few other posts and maybe a video

Wednesday, 15 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 to the cloud to free some space on your on premises servers but you still want to query that data.  You might want to query the azure SQL Server databases from your on-premises SQL Server instances for a whole bunch of other reasons too. Then you might want to create a Linked Server to your Azure SQL Database

In this short video David talks you through the process of creating a linked server to an Azure SQL databases


You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

If you have any questions, please leave them in the comments

Wednesday, 8 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 to connect to your Azure SQL database from SQL Server management Studio. 


It also shows at how to create and configure an Azure SQL database from SSMS.





You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

Feel free to leave a comment if you have any questions

Wednesday, 1 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 the Azure cloud.

If you are looking to manage a 'hybrid' environment where you have data and on premises data then this might be a useful tool for you.



You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database


Any questions feel free to ask them in the comments

Featured post

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 ...