De tweede preview van Microsoft SQL Server 2016 “Mission-Critical Applications, Deeper Insights, Hyperscale Cloud” is te downloaden.
Read More »Data Warehouse – Waarom heb je er een nodig?
Het woord “Data Warehouse” klinkt behoorlijk spannend! Het doet vermoeden dat het een ingewikkeld gebeuren is, een soort pakhuis of verzameling met data. Eigenlijk is een data warehouse een database net als alle andere “gewone databases”. Men noemt het een “warehouse” omdat je er meer in bewaart dan in een …
Read More »Linked Server – Why and how use them!
A linked server is used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and discover the data or objects. You can write SQL queries from your SSMS directly on a database on another machine. In Oracle they call it DBLinks (Database Links).
Read More »Cool ASCII big text generator
I found this cool ascii text generator website today. You can use it to generate cool banners to use in your documentation or code comments.
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 »Create a KPI box with an image / text overlap in SSRS
A common wish in SQL Server Reporting is to create an image with a text inside the image. When you are a common user of SSRS, you know this is not so easy. You cannot simply insert an image and a text on top of it. Your layout will be …
Read More »Postcoderange opsplitsen naar losse records
SSRS – Subscriptions in pending status
I had some subscriptions staying in the “Pending” LastStatus. It took me a lot of time to fix this problem. This blog will give you the solution for the problem.
Read More »SSAS OLAP is returning wrong results
Like the title says; my SSAS OLAP cube (SQL 2008R2) was giving me wrong results when selecting a combination of a measure and a fact. I was struggling for days with this issue. I called old colleagues, reading a lot of articles online but no solution yet.
Read More »How to implement Dimension Security in SSAS
I know it was not difficult to implement dimension security in Analysis Services. While it’s not difficult, why did it cost me a lot of days to get this to work? Well, its because you have to do a lot of little settings and it’s easy to make a small mistake …
Read More »Prevent Divide by Zero in SSRS
In a previous post, I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the numbers is 0 or unknown.
Read More »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 »