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,663 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
649 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,295 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
6 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,760 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
460 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
558 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,531 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
626 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,874 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers