SQL Server Azure Tips
All 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
Administration
- 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
- Redeploy Azure Windows VM
- Simplify Your Azure Bill by Resource Group
- Troubleshoot SQL Azure Bacpac Import Failures
- Using the Microsoft Azure Mobile app for remote administration
Analysis Services
- Automate Azure Analysis Services Model Refresh using Logic App - Part 2
- Automate Azure Analysis Services Model Refreshes with Small, Medium and Large Tables using Logic App - Part 3
- Overview of Azure Analysis Services and Logic App Tasks - Part 1
- Terminate Long Running Azure Analysis Services Refresh Using Logic App - Part 4
Auditing
Automation
- Auto Scale Azure SQL DB using Azure Logic Apps
- Auto Scaling Azure SQL DB using Automation runbooks
- Azure Automation and PowerShell Runbooks
- Azure Logic App to Extract and Save Email Attachments
- Execute Databricks Jobs via REST API in Postman
Azure Container Instances
- Connect to and Monitor SQL Server Azure Container Instances ACI
- Create Azure Container Instances for SQL Server
- Start, Stop, Delete and Monitor Azure Container Instances for SQL Server
Azure Data Catalog
- 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 Studio
- 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 DevOps
- Azure Boards for Project Management
- Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project
- Azure DevOps for Agile Projects
- Continuous database deployments with Azure DevOps
- Deploy Azure Data Factory CI/CD Changes with Azure DevOps
- Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File
- Getting Started with Azure Blueprints
- How to Add SQL Server Integration Services Projects to Azure Devops for Version Control
- Managing Azure Blueprints with PowerShell
- Securing Secrets in Azure DevOps
- Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
- Using Azure DevOps CI CD to Deploy Azure Data Factory Environments
- Using PowerShell and Azure Blueprints to provision a Modern Data and Analytics Platform
Azure Machine Learning
Backups
- Automate Retrieving SQL Azure Bacpacs With PowerShell
- Automatically upload SQL Server Database Backups to Azure with Integration Services
- Azure Recovery Services Vault to Backup File Shares
- 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
Calculations
Configuration
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2
- SQL Azure Create Database Tutorial
- Unable to delete Azure Recovery Services Vault
- What's in a DTU? Choosing the right resource model and service tier for Azure DB
Connectivity
- Different Ways to Connect to SQL Azure databases
- How To Connect Remotely to SQL Server on an Azure Virtual Machine
Conversions
Cross Database
Data
- Azure Data Lake Analytics using U-SQL Queries
- Azure Event Hub Service Telemetry Example with PowerShell
- Create Azure Data Lake Database, Schema, Table, View, Function and Stored Procedure
- Deep Dive in Azure Databricks Cluster Creation Options
- Deploying Azure SQL Data Warehouse Using Resource Manager
- Explore Spark databases with Azure Synapse Analytics
- Explore SQL databases with Azure Synapse Analytics
- Explore Your Data Lake Data Easily with Azure Synapse Analytics
- Exploring Azure Table Storage with PowerShell
- How to Apply Pivot Transformations to Spark Streams
- How to Capture IoT Data in Azure
- How to setup and use a SQL Server Stretch Database
- Managing Azure Data Lake Storage with PowerShell
- Real-Time Anomaly Detection Using Azure Stream Analytics
- The tale of two Azure Hubs - IoT Hub and Event Hub
- Using COPY INTO command to load Azure Synapse Analytics from Azure Data Lake Storage Gen2
Data Masking
Database
Database Configurations
- Change collation of an Azure SQL database by hacking the BACPAC file
- How to change an Azure SQL Database Collation
Delete
Deployment
Development
- 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
Disaster Recovery
Financial
High Availability
- Azure VM High Availability and Disaster Recovery Options for SQL Server
- Building SQL Server Cluster on Azure with Storage Spaces Direct - Part 1
- Enabling Active Geo-Replication For Azure SQL Database
Import
- Leveraging PolyBase to load data into Azure SQL Data Warehouse
- Process Blob Files Automatically using an Azure Function with Blob Trigger
- Update an Azure SQL Data Mart with ADLS files
Import and Export
- 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
Installation
Integration Services
- Automate the Azure-SSIS Integration Runtime Start-up and Shutdown - Part 1
- Azure-Enabled Integration Services Projects in Visual Studio
- 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
- Deploy SSIS Catalog to Azure Cloud - Part 1
- Execute SSIS Package in Azure with DTEXEC Utility
- Executing Integration Services Packages in the Azure-SSIS Integration Runtime
- Parallel package execution in Azure-SSIS Runtime
- SQL Server Integration Services Flexible File System Task with Azure Blob Storage
- SQL Server Integration Services Flexible File Task with Azure Data Lake Storage
- SSIS Catalog Maintenance in the Azure Cloud
- Using Azure Storage and Azure SQL Database for SSIS Development
Keys
Linked Servers
- 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
Machine Learning Services
Maintenance
Migration
- 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
- Migrate SQL Server database to Azure VM
- 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
Monitoring
- 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
- Monitor Azure Resources with Azure Monitor
- Monitoring Azure Health Status Using Azure Portal - Part 1
- Setting up Azure Log Analytics to Monitor Performance of an Azure Resource
MySQL
Notifications
- 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
Overview
- Azure Synapse Analytics Overview
- Getting Started with Azure Databricks
- 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
Partitioning
Passwords
- Manage Secrets in Azure Databricks Using Azure Key Vault
- Securely Manage Secrets in Azure Databricks Using Databricks-Backed
Performance
- Business Critical Tier of Azure SQL Services
- General Purpose Tier for Azure SQL Database
- Solutions for Azure SQL Database Throttle Log Wait of HADR_THROTTLE_LOG_RATE_GOVERNOR
- Solutions for AzureSQL LOG_RATE_GOVERNOR Waits
PowerShell
- 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
Replication
- Setting Up Geo-Replication in SQL Azure
- Using Snapshot Replication with an Azure SQL Database
- Using Transactional Replication with an Azure SQL Database
Reporting
- Creating Azure DevOps Analytics metrics in Power BI using Pre-Built Analytics Views
- Visualizing Azure Resource Metrics Data in Power BI
Reporting Services
Restore
- Azure VM Backup File Restore
- Caution - Azure SQL Version 12 Restore Times Take Longer
- How to Restore Azure SQL LTR Backup After Azure SQL Instance Deleted
- Migrating SQL Server Databases to Azure Managed Instances with Native Backups
- Restore an Azure SQL Database from one server to another server
- Restore an Azure SQL VM using Recovery Services Vault
- Restore Azure SQL Database to Local SQL Server
- Restore File Shares using Azure Recovery Services Vault
- Restore SQL Server Databases on Azure VM (IaaS) using Azure Backup - Part 2
- Using PowerShell to Restore an Azure SQL Database
Scheduling
Scheduling Tasks
- Collecting Data with Elastic Database Jobs in SQL Azure
- How to Schedule T-SQL Statements to Run with Azure Functions
Scripts
Security
- 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
Servers
Storage
- Azure Soft Delete Option for Blob Storage to Recover Deleted Files
- Azure Storage Explorer Overview
- Databricks and Azure Data Lake Storage Gen 2: Securing Your Data Lake for Internal Users
- Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks
- 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
T-SQL
Template
Transparent Data Encryption
- Add and Monitor Transparent Data Encryption to Azure SQL Databases
- Azure SQL Database TDE Customer Managed Keys
U-SQL
Upgrade
Workflow
