SQL Server Azure Tips

• Azure SQL Database - Table Partitioning
• Creating backups and copies of your SQL Azure databases
• Getting started with SQL Data Sync
• Getting Started with the SQL Azure Database Manager
• Guide to Getting Started with SQL Azure
• How to connect to SQL Azure using SQL Server Reporting Services 2008 R2
• Move an On-Premises SQL Server Database to the SQL Azure Cloud
• Moving your database to the cloud with SQL Azure
• Read and write data from SQL Azure using SQL Server Integration Services 2008 R2
• SQL Azure enhancements with SQL Server 2008 R2
• SQL Azure Migration Wizard
• Understanding SQL Data Sync for SQL Server
• Using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio to move to the Cloud

• Access SQL Server instance on Azure VM using local copy of Management Studio
• How to use SQL Database Query Editor in Azure Portal
• Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1
• Introduction to Azure PowerShell Modules for the SQL Server DBA Part 3
• Locking Resources in Azure with Read Only or Delete Locks
• Simplify Your Azure Bill by Resource Group
• Troubleshoot SQL Azure Bacpac Import Failures
• Using the Microsoft Azure Mobile app for remote administration

• Azure SQL database auditing using Blob Storage

• Azure Automation and PowerShell Runbooks

• Getting Started with SQL Server Azure Container Instances ACI

• Azure Data Catalog Register Data Source - Part 2
• Azure Data Catalog Register Data Source Through Application - Part 3
• Azure Data Catalog Register Tabular Data Model and Enriching Data Assets - Part 4
• Azure Data Catalog Tutorial and Overview - Part 1

• Azure Data Factory Control Flow Activities Overview
• Azure Data Factory Data Transformation with U-SQL
• Azure Data Factory Filter Activity and Debugging Capabilities
• Azure Data Factory ForEach Activity Example
• Azure Data Factory If Condition Activity
• Azure Data Factory Lookup Activity Example
• Azure Data Factory Mapping Data Flow for Datawarehouse ETL
• Azure Data Factory Mapping Data Flows for Big Data Lake Aggregations and Transformations
• Azure Data Factory Overview
• Azure Data Factory Pipeline Email Notification – Part 1
• Azure Data Factory Pipeline Variables
• Azure Data Factory Stored Procedure Activity Transformation Activities
• Azure Data Factory Until Activity Example
• Azure-SSIS Integration Runtime Start-up and Shutdown with Webhooks - Part 2
• Build Azure Data Factory Pipeline Dependencies
• Change Capture Alternatives with Azure Data Factory
• Configuring Azure Data Factory Data Flow
• Create an Azure Function to Connect to a Snowflake Database - Part 1
• Create an Azure Function to execute SQL on a Snowflake Database - Part 2
• Create Azure Data Factory Pipeline
• Create Azure Data Lake Linked Service Using Azure Data Factory
• Create Event Based Trigger in Azure Data Factory
• Create Schedule Trigger in Azure Data Factory ADF
• Create Tumbling Window Trigger in Azure Data Factory ADF
• Refresh Power BI Dataset using Azure Logic Apps – Part 2
• Send Notifications from an Azure Data Factory Pipeline – Part 2
• Transfer Data to the Cloud Using Azure Data Factory
• Transfer On-Premises Files to Azure Blob Storage
• Transfer On-Premises Files to Azure SQL Database
• Using Files Stored in Azure File Services with Integration Services - Part 1
• Using Files Stored in Azure File Services with SQL Server Integration Services – Part 2

• Azure Data Studio Step By Step Tutorial
• Create Azure Data Studio Extension with TypeScript
• Create SQL Server Notebooks in Azure Data Studio
• Creating Dashboard Extensions for Azure Data Studio
• Customize Azure Data Studio with Dashboard Widgets
• SandDance for Azure Data Studio

• Azure Boards for Project Management
• Azure DevOps for Agile Projects
• Continuous database deployments with Azure DevOps
• Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File

• Introduction to Microsoft Azure Machine Learning

• Automate Retrieving SQL Azure Bacpacs With PowerShell
• Automatically upload SQL Server Database Backups to Azure with Integration Services
• Azure SQL Database Backup and Restore Overview
• Backup SQL Server Databases using Azure Backup - Part 1
• Copying SQL Server Backup Files to Azure Blob Storage with AzCopy
• Create Database Copies in Azure SQL Database
• How to use Azure Blog Storage for SQL Server Backup and Restore
• Long Term Storage for Azure SQL Database Backups
• Perform on-premises SQL Server database backups using maintenance plans to Azure Blob Storage
• SQL Server Backups and Restores Directly with Windows Azure Blob Storage Service
• SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands
• SQL Server managed backups to Azure
• Windows Azure SQL Database Backup and Restore strategy

• Bulk Insert Data into a Azure SQL Database with PowerShell

• How to use the Azure SQL Database DTU Calculator

• Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2
• SQL Azure Create Database Tutorial
• What's in a DTU? Choosing the right resource model and service tier for Azure DB

• Different Ways to Connect to SQL Azure databases

• Transfer Files from SharePoint To Blob Storage with Azure Logic Apps

• Cross-database query performance in Azure SQL Database

• Azure Data Lake Analytics using U-SQL Queries
• Create Azure Data Lake Database, Schema, Table, View, Function and Stored Procedure
• Deploying Azure SQL Data Warehouse Using Resource Manager
• Exploring Azure Table Storage with PowerShell
• How to setup and use a SQL Server Stretch Database
• Managing Azure Data Lake Storage with PowerShell

• Automatically Create and Anonymize Downstream Databases from Azure DB

• Design and Manage Azure SQL Data Warehouse

• Change collation of an Azure SQL database by hacking the BACPAC file
• How to change an Azure SQL Database Collation

• Deploying Azure Analysis Services using PowerShell cmdlets

• Microsoft Azure Analysis Services Web Development Tools
• Microsoft Azure Analysis Services Web Development Tools - Part 2
• Using Azure Databricks to Query Azure SQL Database
• Using Azure For Testing POCs and Designs With Lessons Learned

• SQL Azure Geo Replication Configuration and Testing

• Enabling Active Geo-Replication For Azure SQL Database

• Leveraging PolyBase to load data into Azure SQL Data Warehouse
• Update an Azure SQL Data Mart with ADLS files

• How to import data from Azure Blob Storage to a local file with SQL Server Integration Services
• Learn how to Migrate a SQL Server database to SQL Azure server
• Move Azure SQL Databases using the Export and Import PowerShell cmdlets

• Setup an Azure Virtual Machine and Contoso Sample Database for SQL Server Testing

• Automate the Azure-SSIS Integration Runtime Start-up and Shutdown - Part 1
• Configure an Azure SQL Server Integration Services Integration Runtime
• Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime - Part 1
• Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime - Part 2
• Customized Setup for the Azure-SSIS Integration Runtime
• Executing Integration Services Packages in the Azure-SSIS Integration Runtime
• Parallel package execution in Azure-SSIS Runtime
• SSIS Catalog Maintenance in the Azure Cloud
• Using Azure Storage and Azure SQL Database for SSIS Development

• Microsoft Azure Key Vault for Password Management for SQL Server Applications

• Create a SQL Server Linked Server to Azure SQL Database
• Creating SQL Server Linked Servers with Azure
• System Stored Procedures for SQL Azure Linked Servers

• Azure Vision Service and Face API Example with Python

• Index Maintenance in Azure SQL Database with Ola Hallengren's Scripts and Elastic Database Jobs

• Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues when Migrating to Azure
• Migrate database to Azure SQL Database using SQL Server 2016 Upgrade Advisor
• Migrating On-Premises Microsoft SQL Server Business Intelligence Solution to Azure
• Use Data Migration Assistant (DMA) to migrate on-premises SQL Server database to Azure
• Using the Data Migration Assistant (DMA) tool to migrate from SQL Server to Azure SQL database

• Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
• Create a SQL Server Performance Monitor Dashboard in the Azure Portal
• Easy Way to Build an Azure Log Analytics Query
• Monitoring Azure Health Status Using Azure Portal - Part 1

• Configure Service Health Alerts using Azure Service Health - Part 2
• Create an Alert in Microsoft Azure Log Analytics
• Enabling alerts for Azure SQL database via PowerShell cmdlets

• How to use Azure SQL Database features and settings
• Introduction to Azure Cosmos DB database and the SQL API
• Introduction to Azure SQL Database Managed Instances
• Overview of Basic Configuration Options for SQL Azure
• Write Federated U-SQL Queries to Join Azure Data Lake Store Files to Azure SQL DB

• Azure SQL Database Table Partitioning Example

• Manage Secrets in Azure Databricks Using Azure Key Vault
• Securely Manage Secrets in Azure Databricks Using Databricks-Backed

• Solutions for Azure SQL Database Throttle Log Wait of HADR_THROTTLE_LOG_RATE_GOVERNOR
• Solutions for AzureSQL LOG_RATE_GOVERNOR Waits

• Deploying Azure SQL Database Using Resource Manager PowerShell cmdlets
• Getting Started Querying your Azure SQL Database in PowerShell
• Introduction to Azure PowerShell Modules for the SQL Server DBA Part 4

• Setting Up Geo-Replication in SQL Azure
• Using Snapshot Replication with an Azure SQL Database
• Using Transactional Replication with an Azure SQL Database

• Caution - Azure SQL Version 12 Restore Times Take Longer
• Migrating SQL Server Databases to Azure Managed Instances with Native Backups
• Restore an Azure SQL Database from one server to another server
• Restore Azure SQL Database to Local SQL Server
• Restore SQL Server Databases on Azure VM (IaaS) using Azure Backup - Part 2
• Using PowerShell to Restore an Azure SQL Database

• Introduction to Azure Elastic Database Jobs

• Collecting Data with Elastic Database Jobs in SQL Azure
• How to Schedule T-SQL Statements to Run with Azure Functions

• Automate Azure File Uploads and File Deletes With PowerShell

• Adding Users to Azure SQL Databases
• Configure and Customize SQL Azure Dynamic Data Masking
• Configuring SQL Server Endpoint and ACL Access in Windows Azure
• Improve Security with an Azure Service Principal

• Azure Storage Explorer Overview
• Securing Azure Storage Account with Shared Access Signature
• Transfer files between a Data Science Virtual Machine and Azure Data Lake Storage
• Using Azure to store and process large amounts of SQL data
• What's new in Azure Data Lake Storage Gen2

• SQL Azure Cross Database Querying

• Using Azure Quickstart Templates

• Add and Monitor Transparent Data Encryption to Azure SQL Databases

• Example Using C# Code with U-SQL Scripts

• Three Useful Features In Azure-SQL For Growing Environments

• Start an Azure Logic App Workflow on Demand or by an Event