Auto Scale Azure SQL DB using Azure Logic Apps
In this article we look at how to auto scale the size of Azure SQL Database to add and reduce resources on a set automated schedule.
Azure
Solve your SQL Server SQL Azure issues with these valuable tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
Databricks and Azure Data Lake Storage Gen 2: Securing Your Data Lake for Internal Users
Learn the benefits of using Data Lake Storage Gen 2 for housing sensitive data securely in your Azure cloud infrastructure.
Azure Logic App to Extract and Save Email Attachments
Learn how to extract attachments from emails and save them to the file system where they can then be loaded to SQL Server.
Reading and Writing data in Azure Data Lake Storage Gen 2 with Azure Databricks
Learn how to read and write data in Azure Data Lake Storage using Databricks for efficient data management and analysis.
Terminate Long Running Azure Analysis Services Refresh Using Logic App – Part 4
Learn the Logic App steps and JSON code to terminate a long running Azure Analysis Services Refresh.
Getting Started with Azure Databricks
Learn about the power of Azure Databricks as a single interface for your Data Engineers to write ETL, your Data Analysts to write ad hoc queries, your Data Scientists to build machine learning models, and much more. This is all done using the languages th
Azure SQL Cross Database Query
In this article we look at how you can setup a query that uses multiple databases when using Azure SQL Database.
Automate Azure Analysis Services Model Refreshes – Part 3
Learn how to Automate Azure Analysis Services model refreshes with Logic Apps for large tables, many small tables and for models with complex queries.
Automate Azure Analysis Services Model Refresh with Logic App – Part 2
Learn the step by step process to automate Azure Analysis Services Management Tasks using Logic App including the scripts, parameters, logging, looping and calling stored procedures.
Business Critical Tier of Azure SQL Services
Learn about the Azure Business Critical tier of services to help with mission critical SQL Server applications that have high transaction rates and require low latency response times.
Migrate SQL Server database to Azure VM
In this tip we look at a simple process to move an on-premises SQL Server database to an Azure VM with SQL Server.
Overview of Azure Analysis Services and Logic App Tasks – Part 1
In this tip we look at how to automate Azure Analysis Services model refresh tasks using Azure Logic App.
Azure VM Deployment Best Practices
Learn about the options to deploy Azure VMs including location, sizing, costs, operating systems, name, network, storage and tips to help you with your daily SQL Server administration tasks.
Workflow Orchestration with Azure Logic Apps to Move Data
In this section of the tutorial we look at how you can use Azure Logic Apps to move data using the built-in functionality without having to write code.
Building Data Pipelines with Azure Data Factory to Move Data
In this video we look at how you can use Azure Data Factory to build a workflow to load and move data in Azure.
Introduction to Dataflows and SSIS Integration in ADF to Move Data
In this video we look at some additional features of using Azure Data Factory to build a workflow to load and move data in Azure.
Conclusion to Moving Data Around in Azure
In this last video we summarize the different options for moving data around in Azure.
Big Data Analytics with Azure Databricks to Move Data
In this video we look at how you can use Azure Databricks as a unified data analytics platform using different languages such as Python, SQL, Scala, Java, etc. to handle large volumes of data for analytic processing.
Introduction to Moving Data Around in Azure
In this video tutorial series we will look at how to move data around in Azure. We will look at various tools and options to move data in the cloud in each of the different videos in this tutorial. This first video provides an overview of what we will a
Scheduling with Azure Automation to Move Data
In this video we look at Azure Automation (aka runbooks) which is a way to schedule tasks on Azure to do things like run PowerShell scripts or other things you want to set on a automate.
Serverless Scripting with Azure Functions to Move Data
In this video we look at Azure Functions and how they can help you expand your ETL functionality in Azure and assist with moving data around in Azure.
Redeploy Azure Windows VM
In this tip we walk through the steps to redeploy a Windows virtual machine running on Azure.
Azure VM High Availability and Disaster Recovery Option for SQL Server
In this article we look at the High Availability Disaster Recovery and Backup options available in Azure for virtual machines.
Unable to delete Azure Recovery Services Vault
In this article we walk through the steps you need to take to be able to delete an Azure Recovery Services vault after you have decommissioned SQL Server and the Azure VM.