How to Install the AdventureWorks Sample Database in Azure SQL ...
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Azure
Azure Automation With Visual Studio Code
Introduction Azure Automation is a cloud-based service that provides consistent management capabilities across Azure and non-Azure environments. Visual […]
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many […]
Migrate Azure Analysis Services to Power BI Premium
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The decision […]
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Assert Transformations in Azure Data Factory
Introduction I was recently working on a data pipeline project where I had to check data quality for […]
Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]
Synapse Analytics: When you should use (or not use) Synapse
Synapse is a great data lake house tool. This means in a single tool we have resources […]
Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]
Data Flow Formatters – Flatten, Parse and Stringify in Azure ...
Introduction I recently worked on a data pipeline project where I had to process JSON files and transform […]
Creating Azure Policy to setup Virtual Machine Auto-Shutdown
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […]
Accéder aux documents contenus dans une bibliothèque SharePoint comme source ...
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Monitoring Azure Blob Storage
Introduction In this article, we will learn how to monitor Azure Blob Storage. Azure monitoring provides powerful reporting […]
Understanding Shared Access Signature and Access Policy in Azure Storage
Introduction You may want to provide access to the files from your Azure storage account container, there are […]
Accéder aux documents contenus dans une bibliothèque SharePoint comme source ...
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Advanced Databricks Lakehouse Capabilities
The post Advanced Databricks Lakehouse Capabilities appeared first on SQLServerCentral.
SQL Saturday Haïti 2022, Débuter avec Azure pour les DBA
Après une certaine absente (peut-être parce qu’en France, nous n’en organisions plus), j’ai eu un vrai plaisir […]
The Script Activity in Azure Data Factory
Introduction Azure Data Factory recently introduced a new activity, called the Script activity. We can use the Script […]
Understanding the Mapping Data Flow Activity in Azure Data Factory
Azure Data Factory is used for ELT (Extract, Load, Transform) operations in Azure. We do have multiple activities […]
An Introduction to Flowlets in Azure Data Factory
Introduction Flowlets is a new feature of Mapping data flows introduced in Azure Data Factory and Azure Synapse […]
Understanding Azure Data Factory Pricing
Introduction In this article, we will discuss the pricing of the Azure data factory data pipeline. It will […]
Accéder aux documents contenus dans une bibliothèque SharePoint comme source ...
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Monitoring Azure SQL Databases
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk […]
Prevent Accidental Resource Deletion Using Locks in Azure Data Factory
Introduction While working in Azure Data Factory a user can delete a resource unknowingly. We can implement Azure […]
Exploring Knowledge Center in Azure Synapse Analytics
Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big […]
Accéder aux documents contenus dans une bibliothèque SharePoint comme source ...
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Accéder aux documents contenus dans une bibliothèque SharePoint comme source ...
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Eight Azure SQL configurations you may have missed
The post Eight Azure SQL configurations you may have missed appeared first on SQLServerCentral.
Chaos Engineering in Azure
Introduction Chaos engineering is all about breaking your application! It sounds counterproductive; however, it is the exact opposite. […]
Running SQL Server on Oracle and Google Cloud
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google […]
Working with Fail Activity in Azure Data Factory
Introduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is […]
Prevent Accidental Data Deletion in Azure Storage Container with Soft ...
Introduction While working with Azure Storage, data might be accidentally or erroneously deleted. We can prevent the total […]
Choosing Between SQL Server Integration Services and Azure Data Factory
The post Choosing Between SQL Server Integration Services and Azure Data Factory appeared first on SQLServerCentral.
Azure Policies and Management Groups
The post Azure Policies and Management Groups appeared first on SQLServerCentral.
Adding Users to Azure SQL Databases
The post Adding Users to Azure SQL Databases appeared first on SQLServerCentral.
Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping ...
The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral.
Did you know SQL Monitor supports Azure databases, too?
The post Did you know SQL Monitor supports Azure databases, too? appeared first on SQLServerCentral.
Raw Data Ingestion into Delta Lake Bronze tables using Azure ...
The post Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow appeared first […]
Ma session au Power Platform French Summit 2021
Le 19 novembre 2021, j’ai animé une session lors de la Power Platform French Summit 2021. C’est […]
PASS Data Community Summit keynote: a bridge to a new ...
It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data […]
Azure SQL Migrations using Azure Data Studio
Database migrations to the cloud can be a daunting proposition for many database administrators and data stewards. A […]
The Azure SQL portfolio
The post The Azure SQL portfolio appeared first on SQLServerCentral.
Mount an Azure Data Lake Storage Gen2 Account in Databricks
The post Mount an Azure Data Lake Storage Gen2 Account in Databricks appeared first on SQLServerCentral.
Move SQL Server licenses without Software Assurance to Azure
Migrating your on-premises infrastructure and architecture to the cloud may seem like a daunting task, especially if you […]
Schedule Azure SQL DB Processes using Azure Functions
The post Schedule Azure SQL DB Processes using Azure Functions appeared first on SQLServerCentral.
Azure Data Factory Incremental Pipeline from Azure SQL Database to ...
The post Azure Data Factory Incremental Pipeline from Azure SQL Database to Databricks appeared first on SQLServerCentral.
Working with Get Metadata Activity in Azure Data Factory
Introduction While working in Azure Data Factory, sometimes we need to retrieve metadata information, like the file name, […]
How to query private blob storage with SQL and Azure ...
The post How to query private blob storage with SQL and Azure Synapse appeared first on SQLServerCentral.
Using Multiple Azure DevOps Organizations with SQL Source Control
The post Using Multiple Azure DevOps Organizations with SQL Source Control appeared first on SQLServerCentral.
How to query blob storage with SQL using Azure Synapse
The post How to query blob storage with SQL using Azure Synapse appeared first on SQLServerCentral.