Ronald

Microsoft SQL Server and Business Intelligence consultant, MCITP Certified. If you need a BI specialist for a freelance job, please contact me!

Quickly Reorder MDS Attributes Using SQL Updates

close up shot of colorful shapes on the white table

If you’ve ever used Microsoft Master Data Services (MDS), you’ve probably noticed one of its more annoying limitations: there’s no drag-and-drop interface to reorder attributes within an entity. Want to move 10 attributes from the bottom of a 100-column entity to the top? Get ready to click hundreds of times …

Read More »

AI als SQL-sidekick: hoe ChatGPT en Claude je code sneller en beter maken

Wie regelmatig SQL schrijft, weet dat er drie soorten queries zijn: De snelle één-regel-selects, De ‘even knutselen’-rapportqueries, En de echte hersenkrakers met 8 joins, subselects en performanceproblemen. Voor die laatste twee biedt AI tegenwoordig serieus bruikbare hulp. Tools zoals ChatGPT en Claude zijn steeds beter geworden in het begrijpen én …

Read More »

Advanced T-SQL Window Functions: A Comprehensive Guide with Examples

Title: Advanced T-SQL Window Functions: A Comprehensive Guide with Examples Introduction Transact-SQL (T-SQL), Microsoft’s proprietary extension of the SQL language, provides a rich set of tools for managing databases on SQL Server and Azure SQL Database. Among these, window functions have gained attention due to their ability to perform complex …

Read More »

Top 5 Ways to Optimize Your SQL Server CPU Usage

Introduction SQL Server is a powerful relational database management system developed by Microsoft. It is widely used in various industries for data storage, processing, and retrieval. However, like any other system, SQL Server can sometimes consume more CPU resources than necessary, leading to slower performance and reduced efficiency. This article …

Read More »

SQL Server Disk Performance Metrics: An In-depth Guide

SQL Server Disk Performance Metrics: An In-depth Guide Understanding your SQL Server’s disk performance metrics is crucial for maintaining an efficient, high-performing database. These metrics provide insights into how well your storage system is performing and where there might be bottlenecks or problems that need to be addressed. In this …

Read More »