Microsoft Team

Step-by-Step Guide to Enabling Copilot in SSMS

With the latest version of SSMS, SSMS 21, there is now integration with Copilot. In this blog post, we’ll go through the setup step by step, with screenshots, to get everything ready to use Copilot in SSMS.There is already(…)

Experiencing SQLBits 2025 in London

This week, I’m in London attending the SQLBits 2025 conference.Since joining dbi services as a consultant, this is my second time taking part in the event. The last time was in 2022, but I attended remotely due to the(…)

SQL Server 2025 Public Preview and SSMS 21 now available

This is a short blog post to share that the SQL Server 2025 public preview is now available for download. At the same time, SSMS 21 has also been released and is now generally available. The LinkedIn post by Bob(…)

Microsoft Foundry in Action: Building Smarter AI Solutions with Your Data

1        Introduction At the 2024 edition of Microsoft Ignite, two key themes dominated the stage: Artificial Intelligence (AI) and Security. These pillars reflect the current and future technological landscape. Staying true to its innovative legacy, Microsoft unveiled Microsoft Foundry, a(…)

Help yourself out with the ‘log_reuse_wait_desc’ column

A few days ago a customer called me to ask if I could help him with a problem with the log file. He tried to shrink it, but the system wasn’t doing anything and he didn’t know why. With the column(…)

Save Report to Power BI Report Server: Resolving the ‘Unexpected Error Encountered’

1        Introduction Hello, Readers! Recently, I was tasked with preparing a demo for Power BI Report Server. Everything proceeded smoothly until I reached the step of deploying a report to the server, where I encountered an interesting authentication challenge that(…)

Export Data to Azure Storage with SSIS: Solving the ‘Unable to Create Azure Blob Container’ Error

1        Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the “Unable to create Azure container” error. This article will guide you through a straightforward solution, aiming to save you time(…)

Ace Your Certification Exams with Confidence: A Proven Recipe for Success

1        Introduction Recently, a colleague approached me, saying, “Hey Nicolas, I’m thinking of going for the PL-300 (Microsoft Power BI Data Analyst Associate) certification. Do you have any advice on how to pass it with confidence?” As knowledge sharing is(…)

Mastering SSIS with Excel – Resolving the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ Error

1        Introduction Dear Readers, Recently, I encountered the ‘Microsoft.ACE.OLEDB.16.0 Provider is Not Registered’ error while working on a data extraction task using SSIS. In this article, I’ll share how to fix this issue and also guide you through: Migrating SSIS(…)

Mastering Custom Integration Runtimes in Azure Data Factory: An Introduction to Our Upcoming Series

Introduction Dear Readers, This post serves as an introduction to a six-part series focused on the Integration Runtime (IR) within Azure Data Factory (ADF). Over the course of these six articles, you’ll gain essential knowledge and practical skills to choose(…)