Azure SQL Data Warehouse / Hybrid Data Solutions and Scenarios / SQL Azure
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.
DBCC CHECKDB Integrity Checks on SQL Azure
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
Learn how to reset the Admin account password of a SQL Azure Database using
How to connect to AdventureWorks on SQL Azure
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
- 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
How to enable the old cardinality estimator on
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
Learn how to install AdventureWorksLT database on a previously created SQL Azure
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
Learn how to troubleshoot the Query Store on SQL Azure Database
How to stop billing charges for a SQL Azure
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
Learn how to upgrade an Azure SQL Database server to the latest SQL Azure
Identifying individual query waits on SQL Azure
- Learn three easy ways to identify query waits for individual queries on
a SQL Azure Database.
- Max Sessions Azure SQL Database & Elastic
- How to monitor the number of sessions that count toward Azure SQL
Database limit of maximum concurrent sessions per database and per elastic
Open a SQL Azure Database in Visual Studio
Learn how to open a SQL Azure Database on Visual Studio 2015 from within
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
Learn how to configure database database-level replication for SQL Azure
Azure SQL Database.
How to restart an Azure SQL Database Managed
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
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
- 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
Grouping customers using Azure SQL DB Machine
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
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
Using Azure SQL Database Machine Learning Services to make price predictions.
Verify Machine Learning is enabled on Azure SQL
Learn how to verify whether Machine Learning is enabled or not on an Azure SQL
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
How to create an Azure SQL Server VM using CLI
Learn how to create an Azure SQL Server virtual machine (VM) using CLI.