Azure Data Studio – A First Look
Introduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing […]
Azure
Creating an Azure PostgreSQL cluster and connecting to it
One of the technologies that my new job brought with it was learning about all the various […]
Backup and Restore SQL Database to Azure Blob Storage
SQL databases are crucial for businesses, so it’s critical to back them up. A dependable and affordable option […]
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
Creating an Azure SQL Database Using Azure Cloud Shell
Introduction Azure Cloud Shell is a browser-based tool that allows the creation, configuration, and management of Azure resources […]
Supervise the use of Microsoft Fabric
Already one month since the official announcement of Microsoft Fabric and his public Preview: https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/ Since then, […]
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.
Microsoft Fabrics Monitoring Tenant Settings
I am sure you have heard about all great announcements from last Microsoft Build. If it’s not the […]
Data Intelligence on light speed: Microsoft Fabric
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
SQL Server et la redondance de zone sur Azure
L’actualité récente nous a encore montré que même un grand nom des acteurs du cloud public n’est pas […]
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 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 […]
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 […]