SQL Server Infernals – Circle 1: Undernormalizers
There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....
2015-06-17
887 reads
Blog Posts
Analyzing Baby Names using Power BI
Me and my wife are contemplating names for our first baby we’re expecting in a couple of months! We don’t...
2015-06-16
830 reads
Announcing Workshops – Columnstore Deep Dive
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it...
2015-06-16
464 reads
Creating a Date Dimension with Power Query
A date dimension or table can be extremely important when working on a Power BI project, or BI projects in...
2015-06-16
5,704 reads
Demystifying Power BI – slidedeck
ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the...
2015-06-16
662 reads
Excel BI Tip #27: CUBESET and CUBESETCOUNT Functions
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-06-16
1,444 reads
Hello GETDATE() My Old Friend...
So you’ve decided that your new web application needs to record some page load time metrics so you can keep tabs on performance. Terrific! You set up a couple page load/complete...
2015-06-16
20 reads
Installing and upgrading default scripts automation – part one – Introduction
First I must say thank you to all of the wonderful people who have put time and effort into providing...
2015-06-16 (first published: 2015-06-08)
1,766 reads
Publicizing Mistakes
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
463 reads
SQL Code Guard - developer builds
Hi all
Unfortunatelly I'm pretty busy now and will be busy till end of the year
So I have not so much...
2015-06-16
584 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers