![](https://mssql.fr/wp-content/uploads/2024/07/word-image-103148-4.png)
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
This is the second part of my series on auditing SQL Server. In the first part, I […]
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance […]
The most watched videos on my youtube channel are related to security. Azure SQL Networking Secrets and […]
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some […]
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Nikola Ilic, best known as Data Mozart, published a great article and video about how to make […]
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
The post Identify log write limits on Azure SQL Managed Instance using QPI library appeared first on SQLServerCentral.
Introduction Azure Data Studio is the next iteration in Microsoft’s development of a cross-platform client tool for developing […]
One of the technologies that my new job brought with it was learning about all the various […]
SQL databases are crucial for businesses, so it’s critical to back them up. A dependable and affordable option […]
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
Introduction Azure Cloud Shell is a browser-based tool that allows the creation, configuration, and management of Azure resources […]
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, […]
The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.
I am sure you have heard about all great announcements from last Microsoft Build. If it’s not the […]
This article is based on exciting information just released at Microsoft’s Build conference on May 23, 2023. […]
L’actualité récente nous a encore montré que même un grand nom des acteurs du cloud public n’est pas […]
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Introduction Azure Automation is a cloud-based service that provides consistent management capabilities across Azure and non-Azure environments. Visual […]
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many […]
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The […]
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Introduction I was recently working on a data pipeline project where I had to check data quality for […]
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]
Synapse is a great data lake house tool. This means in a single tool we have resources […]
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]
Introduction I recently worked on a data pipeline project where I had to process JSON files and transform […]
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […]
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
Introduction In this article, we will learn how to monitor Azure Blob Storage. Azure monitoring provides powerful reporting […]
Introduction You may want to provide access to the files from your Azure storage account container, there are […]
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
The post Advanced Databricks Lakehouse Capabilities appeared first on SQLServerCentral.
Après une certaine absente (peut-être parce qu’en France, nous n’en organisions plus), j’ai eu un vrai plaisir […]
Introduction Azure Data Factory recently introduced a new activity, called the Script activity. We can use the Script […]
Azure Data Factory is used for ELT (Extract, Load, Transform) operations in Azure. We do have multiple activities […]
Introduction Flowlets is a new feature of Mapping data flows introduced in Azure Data Factory and Azure Synapse […]
Introduction In this article, we will discuss the pricing of the Azure data factory data pipeline. It will […]
Dans cette série d’articles, nous verrons comment accéder aux documents contenus dans une bibliothèque SharePoint comme source […]
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk […]
Introduction While working in Azure Data Factory a user can delete a resource unknowingly. We can implement Azure […]
Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big […]
Dans cette série d’articles, nous verrons comment 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 […]
The post Eight Azure SQL configurations you may have missed appeared first on SQLServerCentral.
Introduction Chaos engineering is all about breaking your application! It sounds counterproductive; however, it is the exact opposite. […]
Introduction In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure (OCI) and Google […]