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 …
Read More »Unlocking the Potential of Power BI: Top 10 Features for 2023
In the age of data-driven decision-making, organizations require powerful tools to transform raw data into actionable insights. Microsoft’s Power BI has become a go-to solution for businesses looking to leverage data visualization and business intelligence capabilities. With continuous updates and improvements, Power BI offers a plethora of essential features to …
Read More »Revolutionize Your Data Analytics with Power BI’s May 2023 Update: What to Expect?
2023: New Features and Enhancements In May 2023, Microsoft announced a series of updates and new features to its Power BI platform, aiming to improve user experience, accessibility, and performance. As a skilled blog writer, I will provide you with a comprehensive summary of these updates, covering all areas from …
Read More »Top 5 ETL Tools of 2023: Which Ones Should Your Business Be Using?
As data continues to become a more valuable asset for businesses, the need for effective and efficient Extract, Transform, and Load (ETL) tools has only increased. With a wide variety of ETL tools on the market, it can be difficult to determine which one is the best fit for your …
Read More »Actieve bold buttons maken in Power BI
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 …
Read More »DAX Set column to Zero based on Username()
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint
Using Microsoft SQL Server, you cannot truncate or drop a table with a foreign key constraint. For example, when you have a client table and a country table. When the client table has a foreign key constraint to the country table, you cannot truncate the country table in this situation …
Read More »Setup sp_send_dbmail attachment included!
I need to setup a weekly report for one of my customers. The report can be manually run by executing a T-SQL statement and copy the result to Excel. After copying, it’s emailed to the client. By using sp_send_dbmail attachment options, you can automate this process.
Read More »Calculate Age in SQL Server
In my daily work, I need to calculate and report the age of people very often. There are a couple of ways to calculate the age and will give you the right result. I do not recommend a SQL Function to to this. SQL Functions are performing very slow, especially …
Read More »T-TSQL – Create 4 week Moving Total
This article will offer you a way to calculate a 4 week moving total in SQL using SQL Server. There are more ways to Rome but this is a way you can use to calculate it using a date dimension.
Read More »Postcoderange opsplitsen naar losse records
Calculate Lost Customers using T-SQL
A common question in the Business Intelligence world from customers is “how many customers did we lose this year” ? Businesses wants to know this so they can act faster to keep customers doing business with them. In this article, I will help you to create SQL to calculate this …
Read More »How To Find the slowest SQL Queries
This stored procedure displays the top worst performing queries based on CPU, Execution Count, I/O and Elapsed_Time as identified using DMV information. This can be display the worst performing queries from an instance, or database perspective. The number of records shown, the database, and the sort order are identified by …
Read More »Interesting Course about data visualisation from Google
Making Sense of Data Do you work with surveys, demographic information, evaluation data, test scores, or observation data? Are you interested in making the data you collect more useful by organizing it, analyzing it, and applying it in different ways? This self-paced, online course is intended for anyone who …
Read More »How to Refresh Reporting Services Cache?
I am working for a client which uses a Datawarehouse in which the data is loaded once a day during the night. During the rest of the day, nothing changes in the datawarehouse. After a couple of years, the database grows and grows and reports are getting slower and slower. …
Read More »