Microsoft Team

Developing a Business Central Custom API for Power BI Integration – Resolving the ‘Could Not Download Symbols’ Error

Introduction Dear Readers, This article marks my first blog post. I am both excited and eager to share my experience of tackling a challenging issue encountered while developing a custom API for Microsoft Business Central to enable data extraction for(…)

Plotting SQL Server Performance counters with Python

As a consultant, I often use Performance Monitor (Perfmon) to collect performance metrics for SQL Server. After running Perfmon for, say, a week to capture a baseline of server activity, you can end up with a(…)

Make SQL Server services more secure with Managed Service Accounts

In the past years, I actively have been involved in securing MSSQL Instances (and other services).This lead me to use the Managed Service Accounts (MSA) and the grouped Managed Service Accounts (gMSA)The MSA have been introduced in Windows Server 2008(…)

Cześć polska! SQLDay2024 in Wrocław

Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their experiences and skills(…)

Attending SQLDay 2024 in Wrocław, Poland

Here’s a short post about a conference I’m attending right now. SQLDay is one of the biggest events in Europe dedicated to the Microsoft data platform, including databases, Big Data and Business Intelligence solutions, and advanced data analytics. The(…)

Sql Konferenz 2023 in Hanau, Germany

Introduction It was a very great pleasure to participate to the Sql Server konferenz 2023 in Hanau, Germany, the 12 and 13 September 2023. I went with my colleague Petar, of the same Microsoft Sql Server team by dbi services,(…)

SQL Konferenz 2023 in Hanau – Meet Tame, the data monster

After 2 years, or even 3 years? The organizers could not agree, the SQL Conference took place again in Hanau. 73 speakers have taught us in over 80 sessions with their experience as well as knowledge new. There were incredibly(…)

SQL Server: Is this ad hoc workload an issue?

I ran into an interesting scenario with a customer that I want to share in this blog post.This customer is running a data-loading activity on a monthly basis from his business application.He did not complain about the performance, the time(…)

SQL Server: How Correlation assumptions work for multiple predicates

SQL Server 2022 introduced “CE Feedback“, a feature that adjusts some Cardinality Estimation model assumptions at a query level by applying Query Store hints. In this blog post, I’ll use an example query from the(…)

Lost access to SQL Server. Now what ?

In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account by(…)