SQLBlog Nederland Business Intelligence & Datawarehousing

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 …

Introduction If you’ve ever wondered why your perfectly tuned SQL query suddenly starts crawling at a snail’s pace, the culprit might be stale statistics. In SQL Server, statistics are like the GPS system for your query optimizer – they help it choose the fastest route to your data. When they’re …

We kennen het allemaal: je hebt jaren aan kennis opgebouwd over je datawarehouse, de logica van procedures, de structuur van je rapporten en het hoe-en-waarom van allerlei kolomnamen. Maar dat zit óf verspreid in documentatie die nooit klopt, óf in je hoofd. En dat is precies waarom MyGPT zo handig …

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 …

De afgelopen jaren zijn Large Language Models (LLM’s) zoals GPT van OpenAI en Claude van Anthropic steeds beter geworden in het begrijpen en genereren van code. Waar je vroeger zelf zat te puzzelen op ingewikkelde joins of edge cases in je where-clausule, kun je nu simpelweg tegen een AI zeggen: …

Streamlining Data Warehouse Testing with Efficient Table Management When testing a data warehouse, a common challenge is managing large datasets effectively. Often, you need to reset tables to a clean state, ensuring consistent testing environments. The most efficient way to clear a table is using the SQL command TRUNCATE TABLE. …

Introducing the RANK Window Function in DAX: An Overview and Example Introducing the RANK Window Function in DAX: An Overview and Example Introduction: Data Analysis Expressions (DAX) is a collection of functions, operators, and constants used in Microsoft’s Power BI, Analysis Services, and Power Pivot in Excel. Among its suite …

In the world of data management, there are several data storage and processing models that organizations use to handle their ever-growing data needs. Three of these models, which have risen to prominence over the past few years, are data warehouses, data lakes, and more recently, data lakehouses. Each of these …

In the world of data visualization and business intelligence, Microsoft Power BI continues to evolve and introduce powerful new features that enhance data reporting and analysis. One of the standout updates in recent times is the Zebra BI Cards 1.6 update, which introduces a myriad of features that will revolutionize …

Excel, a widely used tool in the world of finance, has been the go-to platform for data analysis for decades. The formula-based structure of Excel allows analysts to manipulate, aggregate, and analyze data with relative ease. However, with the advent of more complex datasets and the need for more advanced …

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 …

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 …

Wat is een Postcodetabel? Een postcodetabel is in wezen een database van alle postcodes in een bepaald land, in dit geval Nederland. Het omvat niet alleen de postcodes zelf, maar vaak ook andere nuttige gegevens zoals straatnamen, huisnummers, coördinaten en andere relevante informatie. Deze informatie kan worden gebruikt om klantgegevens …

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 …

Sure, here is a draft for the blog post: 10 Common Mistakes in SQL Server Performance Optimization and How to Avoid Them Microsoft SQL Server is a powerful, robust and feature-rich relational database management system (RDBMS). Despite its capabilities, improper usage or configuration can lead to suboptimal performance. Here are …

Introduction Microsoft Power BI is a suite of business analytics tools that enables organizations to analyze data and share insights. Through its comprehensive dashboards, interactive reports, and compelling visualizations, businesses can transform raw data into meaningful information to drive strategic decisions. Industry leaders across various sectors are harnessing the power …

From Excel to Power BI: Transitioning to Advanced Analytics Over the past few decades, Excel has firmly established itself as a cornerstone of data management, manipulation, and visualization. However, in the evolving world of data analytics, tools like Microsoft Power BI have emerged as powerful alternatives, offering advanced functionalities that …

Making Sense of Time: An Introduction to SQL Server’s DateTime Functions When it comes to managing and manipulating data, there’s no doubt that SQL Server is one of the most popular choices. One of the reasons for its popularity is the rich set of functions it provides for a variety …

In de wereld van gegevensanalyse en business intelligence is het essentieel om niet alleen cijfers en statistieken te begrijpen, maar ook de geografische context van die gegevens. Hier komt de postcodetabel in beeld. Een postcodetabel is een krachtige manier om geografische informatie, zoals postcodes, te koppelen aan andere bedrijfsprestaties, en …

Wanneer je met buttons werkt in Power BI om bijvoorbeeld met bookmarks te werken is het handig om te zien welke “view” actief is in je rapport. Het lijkt een beetje op het principe van een web navigatie. Door de actieve bookmark op de button zichtbaar te maken wordt het …

Power BI Pro licentie kopen en koppelen aan een gebruiker.Korte handleiding hoe je een power bi pro licentie kunt kopen en koppelen aan een externe gebruiker. Stap 1:Deel het powerbi rapport alvast met de externe gebruiker. Nu wordt het account ook bekend in de azure directory. De link zou ik …

In een vorig artikel bespraken we kort wat je met de postcodetabel van Nederland kunt doen.  Een postcodetabel kun je gebruiken om automatisch gegevens op je website in te vullen. Klantgegevens verrijken behoort ook tot de mogelijkheden. In dit artikel geven we voorbeelden vanuit Microsoft SQL Server 2016 hoe je klantgegevens kunt …

One thing that is definitely taking the world by storm is Big Data. It is considered highly imperative for big to small industries and businesses. Companies have started to embrace the fact that big data is of utmost significance to them. WHAT IS BIG DATA AND WHAT ARE ITS BENEFITS? …

It’s pretty hard to say “best etl tools” or “single best etl tools”  to recommend. ETL-tools are very often closely related to the ERP or database product in use at an organization. As an IT professional, you just use what is provided at the company you are working for. This …