SQL Server External Tables : archivage et externalisation
L’archivage des données devrait être prévu dès le début des projets. Mais, il faut bien avouer que c’est […]
Azure
An Effective Approach for High Volume Data in Azure Synapse
Introduction Azure Synapse Analytics, previously known as Azure SQL Data Warehouse, is a widely utilized platform for storing […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Chiffrement des sauvegardes via clés extensible Azure Key Vault
Il est des situations où utiliser une clé de chiffrement asymétrique stockée dans un module de gestion de […]
How To Embed Your Azure Logic Apps in a Metadata-driven ...
In this article, I am going to explain how you can dial your productivity up to 11 […]
How To Use Managed Identities in your Azure Logic Apps
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
Getting Started with Azure CLI to Manage Azure Resources
The post Getting Started with Azure CLI to Manage Azure Resources appeared first on SQLServerCentral.
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
The signs of a new era: Prompt Injection
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance […]
Azure OpenAI and RAG Security
The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […]
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Top-Down and Bottom-Up Approaches in Microsoft Fabric
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Identify log write limits on Azure SQL Managed Instance using ...
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
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 […]
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, […]