Lesson Learned #392:Querying Extended Events and Sending Results via Email using PowerShell

In this article, we will explore how to leverage PowerShell to query extended events in SQL Server and send the results via email. Extended events provide valuable insights into Azure SQL performance and activity, and automating the process of querying… Continue reading Lesson Learned #392:Querying Extended Events and Sending Results via Email using PowerShell

Seamless API Development with Data API Builder for your Static Web Apps

frustrated person who forgot to buy something from the store
 
Have you ever walked into a store, did some shopping, and headed back home only to find that you forgot to buy 60% of the items you needed to get?
I struggle with this very same issue … Continue reading Seamless API Development with Data API Builder for your Static Web Apps

Enabling Microsoft Defender for Cloud for Arc Enabled SQL Server Machines

Welcome back to the third installment of our multi part blog series on enhancing the security and management of Azure Arc Enabled SQL Server machines. In our previous posts, we explored how to evaluate SQL Server configurations using Best Practices Ass… Continue reading Enabling Microsoft Defender for Cloud for Arc Enabled SQL Server Machines

Lesson Learned #391: Data Loading – Parallel BULK INSERTs with JDBC and Azure Blob Storage

Today, we got a service request that our customer is running in multiple threads using prepared statement. In this article, I would like explore a Java code snippet used to test a connection to a SQL Server database and execute load bulk data usin… Continue reading Lesson Learned #391: Data Loading – Parallel BULK INSERTs with JDBC and Azure Blob Storage

Mainframe Db2 Data Virtualization using SQL Server PolyBase

Introduction
In this technical blog, we will explore the technology of SQL Server PolyBase with the specific use case for seamless data integration between SQL Server and Db2 on a Mainframe using the ODBC option. PolyBase revolutionizes the way we… Continue reading Mainframe Db2 Data Virtualization using SQL Server PolyBase