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,686 reads
Blog Posts
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
659 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,409 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
15 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,761 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
461 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
566 reads
SQL Server Policy Based Management by Example
What steps do you go through to validate SQL Server configurations after a server build? Even a single server can...
2015-06-16
1,558 reads
The Company Meeting
I’m leaving today for a trip to Cambridge, UK. I do this 2-3 times a year, but this one is...
2015-06-16
629 reads
T-SQL Tuesday #67 – Extended Events
This month’s T-SQL Tuesday topic is about extended events and comes from Jes Borland (B|T).
Like in most environments, we utilize...
2015-06-16 (first published: 2015-06-09)
1,882 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers