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
- Azure SQL database auditing using Blob Storage
- Query Audit data in Azure SQL Database using Kusto Query Language (KQL)
- Server and Database Level Auditing for Azure SQL databases
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 Lake Storage
Azure Machine Learning
Bulk Insert
Calculations
Configuration
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2
- Migrate Azure SQL DB from DTU to vCore Based Purchasing Model
- 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
Cosmos DB
- Build real-time data pipelines with Azure Event Hub, Stream Analytics and Cosmos DB
- Cosmos DB Data Migration Between Containers using Databricks and PySpark
- Explore Azure Cosmos Databases with Azure Synapse Analytics
- Introduction to Azure Cosmos DB database and the SQL API
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
- Exploring Azure Table Storage with PowerShell
- Getting Started with Azure Purview for Data Governance
- 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
- Ingestion and Processing Layers in Azure Data Lakehouse
- 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
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
- Using PowerShell and Azure Blueprints to provision a Modern Data and Analytics Platform
Disaster Recovery
Email
Encryption
Export
- Options to Export of Azure SQL Database – Part 2
- Options to Perform backup of Azure SQL Database – Part 1
Financial
Functions
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
- Setup Microsoft SQL Server Failover Cluster Instance Behind an Azure Internal Load Balancer
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
- Azure Blob Storage Data Upload with SSIS
- 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
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
Logins
Machine Learning Services
Maintenance
Migration
- Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues when Migrating to Azure
- Determine correct Azure SQL DB SKU before migrating on premise SQL Server database
- 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 Cloud Data Resources
- Getting Started with Azure Databricks
- How to use Azure SQL Database features and settings
- 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 Azure SQL Data Sync to Replicate Data
- Using Snapshot Replication with an Azure SQL Database
- Using Transactional Replication with an Azure SQL Database
Reporting
Reporting Services
Scheduling
Scheduling Tasks
- Collecting Data with Elastic Database Jobs in SQL Azure
- Creating Lakehouse ELT Jobs with Apache Spark for Azure Pipelines
- How to Schedule T-SQL Statements to Run with Azure Functions
Scripts
Security
- Adding Users to Azure SQL Databases
- Azure SQL Database Ledger Getting Started and Examples
- 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
- Introduction to Azure SQL Database Ledger for Data Tampering Protection
Servers
Snowflake
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
- Manage TDE Keys On Premises with SQL Data Files Stored in Azure
U-SQL
Upgrade
Virtual Machines
Workflow
