Ronald
Power BI
5,069
Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the know, spot trends …
Read More »
Ronald
SQL Server
7,978
I was struggling with my SQL Server 2016 database mail after installing the Free Developer edition of Sql Server 2016. My server contains Microsoft Windows Server 2012 and I enabled the SMTP server. The SMTP server (local) was working fine but database mail refuses to work!
Read More »
Ronald
SQL Server
125,027
Inleiding De Nederlandse Postcodetabel bevat informatie over alle postcodes die in Nederland bekend zijn. Dit is erg handig als je meer informatie wilt over een bepaalde postcode zoals een geografische locatie of de plaats die bij een postcode hoort. We laten in dit artikel zien wat je met deze postcodes …
Read More »
Ronald
Power BI
36,009
See how easy it is to add your reports to your public websites and blogs with Power BI Publish to web. Now you can craft your data story and tell it online in minutes. Here’s how!
Read More »
Ronald
T-SQL
18,237
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 »
Ronald
SQL Server
8,766
De tweede preview van Microsoft SQL Server 2016 “Mission-Critical Applications, Deeper Insights, Hyperscale Cloud” is te downloaden.
Read More »
Ronald
BI en Datawarehousing
16,265
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 »
Ronald
SQL Server
34,048
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 »
Ronald
Data Visualisation
10,981
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 »
Ronald
T-SQL
9,930
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 »
Ronald
Reporting Services, T-SQL
5,899
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 »
Ronald
Reporting Services
12,090
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 »
Ronald
T-SQL
6,411
Ronald
Reporting Services
21,254
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 »
Ronald
Analysis Services
5,504
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 »
Ronald
Analysis Services
479,670
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 »
Ronald
Reporting Services
9,755
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 »
Ronald
T-SQL
4,786
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 »
Ronald
T-SQL
3,717
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 »
Ronald
T-SQL
3,435
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 »
Ronald
Reporting Services, SQL Server, T-SQL
44,238
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 »
Ronald
T-SQL
5,153
Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this: 00:36:53 OR 02:13:45 This can easy be done using a T-SQL Statement like this: CONVERT(nvarchar(64), EindDatum-StartDatum, 108) AS DurationCONVERT(nvarchar(64), EindDatum-StartDatum, 108) AS …
Read More »
Ronald
Analysis Services
10,747
I was looking for a method of formatting a dimension attrbibute in SSAS2008R2 to, for example a currency symbol €. In search of this question, I found out this is not possible within the default SSAS settings (format column). I thougt this was possible just like the measures settings with …
Read More »
Ronald
Architectuur, Excel, PowerPivot
3,474
Ik kwam vandaag een leuke pagina tegen op de Microsoft site over de architectuur van Microsoft Powerpivot.
Read More »
Ronald
Reporting Services
3,169
Als je in SSRS2008R2 een rapport maakt en je wilt dat de bovenste header vast blijft staan als je naar beneden scrollt dan zal je normaal gesproken verwachten dat de optie “Keep header Visibile While Scrolling” dit regelt. Niets is minder waar.
Read More »