Azure

Learn how to write more complex U-SQL scripts by integrating more intricate C# code in U-SQL scripts by using inline C# in U-SQL jobs.

In this tip we look at how to register a data asset with Azure Data Catalog.

In this tip we look at how to create a database in Azure Data Lake and create schemas, tables, views, table-valued functions and stored procedures.

In this tip learn about the concepts of Azure Data Catalog and how this could be used to document your data assets.

Learn different ways to start a Logic App Workflow for running tasks on Azure.

This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.

In this tip we will use Azure Logic Apps to fetch files from SharePoint, dump them into Azure Blob Storage and then copy the data into the database using the Copy Activity in ADF.

In this tip we will learn about creating Databricks-backed secret scopes.

In this article I will create a solution which will join files that reside in Azure Data Lake Store Azure with Azure SQL DB Data using federated U-SQL queries in Azure Data Lake analytics.

Learn how to use the Azure Key Vault to manage passwords for SQL Server using PowerShell cmdlets.

Learn now to automate processes on Azure using PowerShell runbooks.

In this tip we learn how to update the Azure SQL Data Mart in an automated way.

Learn how to use the tools that are available in the Azure Portal to manage SQL Server databases.

Learn how to use some of the tools in the Azure portal to support your development efforts for Azure Analysis Services.

Learn how you can download, install and use the Microsoft Azure Mobile app for remote administration of your servers including SQL Server.

In this follow-up article we look at how to configure service alerts to be sent directly to you using Azure Service Health.

In this tip we look at how to automatically anonymize data in your databases to create test and development databases from your production databases.

In this tip we look at how you can monitor Azure health to know if there are any issues that may interrupt your services running on Azure.

In this tip we look at how to create custom dashboard in the Azure Portal for monitoring SQL Server and other metrics.

In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.

In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.

In this tip we take a look at the query editor tool that is available in Azure to execute queries against a SQL Server database on Azure.

In this tip we look at how to use Ola Hallengren's database maintenance scripts on Azure using elastic database jobs.

In this tip we cover how to programmatically create a storage account, define a storage folder, and manage files within the data lake. Storing the data in the cloud is the first step in creating a Modern Data Platform.