Database Administration & Monitoring, SQL Server Step-by-Step Guide to Enabling Copilot in SSMS 23.06.2025 by Steven Naudet 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(…)
Azure, Business Intelligence, Database management, SQL Server Experiencing SQLBits 2025 in London 18.06.2025 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server SQL Server 2025 Public Preview and SSMS 21 now available 19.05.2025 by Steven Naudet 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(…)
Database Administration & Monitoring, Development & Performance, SQL Server Plotting SQL Server Performance counters with Python 10.06.2024 by Steven Naudet 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(…)
Business Intelligence, Cloud, Database Administration & Monitoring, Database management Attending SQLDay 2024 in Wrocław, Poland 14.05.2024 by Steven Naudet 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 Server SQL Server: Is this ad hoc workload an issue? 17.05.2023 by Steven Naudet 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 SQL Server: How Correlation assumptions work for multiple predicates 10.04.2023 by Steven Naudet 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(…)
Database Administration & Monitoring, SQL Server SQL Server: Heap page deallocation and IndexOptimize 23.01.2023 by Steven Naudet Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables.
Database Administration & Monitoring, SQL Server SQL Server Deadlock on UPDATE with Serializable isolation level 10.08.2022 by Steven Naudet Recently I spent some time on a recurring Deadlock problem on a customer’s site in a high concurrency environment. It was only after finding the solution on my own that I discovered that this particular problem is already well documented(…)
Database Administration & Monitoring, SQL Server First look at SQL Server 2022 Contained Availability Groups 09.06.2022 by Steven Naudet Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)