Azure SQL Data Warehouse / Hybrid Data Solutions and Scenarios / SQL Azure Databases.

Azure SQL Database.


Alert when Azure SQL SQL Database is deleted
Learn how to create alerts for events you find on Azure SQL Database activity log and that you want to get notified or want to take specific actions when they occur.

Autoscaling up the tier when a database is running out of space
Learn how to automate autoscaling the tier of your SQL Azure Database if the size of it is reaching the tier limit.

Azure SQL - Hardware Sizing - Capacity Planning
How to do hardware sizing, DTU sizing, capacity planning or right-sizing for Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs.

DBCC CHECKDB Integrity Checks on SQL Azure Databases
Do SQL Azure Database customers need to perform regular integrity checks using DBCC CHECKDB?

Deploy Azure SQL Databases using Terraform
This is a quick tutorial to learn how to use Terraform to provision Azure SQL logical servers and datatabases.

 

How to change Server Admin password on SQL Azure
Learn how to reset the Admin account password of a SQL Azure Database using Azure portal.

How to connect to AdventureWorks on SQL Azure using C#
Learn how to connect to an AdventureWorks sample database installed on SQL Azure server using Visual C#.

 

How to create a Linked Server to a SQL Azure Database

Learn how to create a linked server to SQL Azure Database on a SQL Server 2016 instance.

How to create a new SQL Azure Server
Learn how to create a new Azure SQL Database server.

How to enable Query Store on SQL Azure
Learn how to enable on a SQL Azure database to help query performance troubleshooting.

How to enable the old cardinality estimator on SQL Azure
Know how enable the legacy cardinality estimator on SQL Azure Database at the database level and at the query level.

How to get the size of all Azure SQL databases.
Learn how to use PowerShell to have a list of all your Azure SQL databases and the size of each one of them.

How to install AdventureWorks database on SQL Azure
Learn how to install AdventureWorksLT database on a previously created SQL Azure Database server.

How to refresh development and test databases
Learn how to sync test and development databases to the changes made to production Azure SQL database.

How to repair the Query Store on SQL Azure Database
Learn how to troubleshoot the Query Store on SQL Azure Database

How to stop billing charges for a SQL Azure database
Learn how to stop billing charges for an unneeded, unused or infrequently used SQL Azure database.

How to upgrade SQL Azure server to the latest version
Learn how to upgrade an Azure SQL Database server to the latest SQL Azure database version.

Identifying individual query waits on SQL Azure Database

Learn three easy ways to identify query waits for individual queries on a SQL Azure Database.

 

Max Sessions Azure SQL Database & Elastic Pools

How to monitor the number of sessions that count toward Azure SQL Database limit of maximum concurrent sessions per database and per elastic pool.

Open a SQL Azure Database in Visual Studio
Learn how to open a SQL Azure Database on Visual Studio 2015 from within Azure portal.

Querying AdventureWorks database on SQL Azure
Learn how to query an AdventureWorks sample database installed on SQL Azure server using Visual C#.

Temporary Tables on SQL Azure & Error 40544
Changes on behavior on temporary tables on SQL Azure Databases and what to do when Error 40544 appears.

Using Full-Text Search with Azure SQL Database
Learn how to use Full-Text Search with Azure SQL Database in just 5 minutes.

Using Geo-Replication for setting up database-level replication
Learn how to configure database database-level replication for SQL Azure databases.

 

Azure SQL Database Managed Instance.

How to restart an Azure SQL Database Managed Instance.
How to restart or stop/start an Azure SQL Database Managed Instance using SSMS or Azure Portal.

Azure SQL Data Warehouse.


Azure SQL Data Warehouse Limitations.
The article contains some current limitations of Azure SQL Data Warehouse and changes of behavior of instructions/features on Azure SQL Data Warehouse compared with SQL Server.

Using SQL Azure and Tableau for creating reports.
Learn how to create Tableau reports from data stored on SQL Azure Database and SQL Azure Data Warehouse. We create reports with SQL Azure data including a map display with latitude and longitude data.

Using SQL Azure and Power BI for creating reports.
Learn how to create Power BI reports from data stored on SQL Azure Database and SQL Azure Data Warehouse.



Hybrid Data Solutions and Scenarios.
 

Backing Up SQL Server Databases to Azure.
Learn how to backup SQL Server databases to a Window Azure BLOB Storage and take advantage of the hybrid cloud capabilities of SQL Server 2014.

Getting Started with Windows Azure Platform

Learn about SQL Azure, some of its benefits and limitations. Learn how to create a Windows Azure Platform account and subscribe to services.

 

Azure SQL Data Sync.


Manually remove SQL Data Sync DSS schema objects
Learn how to manually remove SQL Data Sync schema and objects by using the deprovision tool or using a T-SQL script.

 

Troubleshooting Azure SQL Data Sync - Classic Portal

Learn how to troubleshoot most common issues with Azure SQL Data Sync and what is not supported by Azure SQL Data Sync.


 

 

 

Azure SQL Database Machine Learning Services.

Comparing Microsoft Machine Learning products.
Let's briefly compare 3 Microsoft Machine Learning products: Machine Learning Services, Azure SQL Database Machine Learning Services, and Azure Machine Learning Services.

Grouping customers using Azure SQL DB Machine Learning.
Learn how to make use of Azure SQL Database Machine Learning Services to group customers using K-means (clustering).

Predicting flight arrival delay using Azure SQL Database ML.
Using Azure SQL Database Machine Learning Services to make predictions of airplane flight delays using rxLinMod algorithm.

Predicting the Price of Used Cars using Azure SQL ML.
Using Azure SQL Database Machine Learning Services to make price predictions.

Verify Machine Learning is enabled on Azure SQL Database.
Learn how to verify whether Machine Learning is enabled or not on an Azure SQL Database.

 

Azure SQL Server Virtual Machines.


Automated backups for SQL Server on Azure VMs
Learn in this article how to configure Automated Backups for a SQL Server VM on Azure. Learn how to encrypt backups. Learn about types of schedules for Automated Backups.


How to create an Azure SQL Server VM using CLI
Learn how to create an Azure SQL Server virtual machine (VM) using CLI.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.