Last week I was asked to tackle a requirement by a customer adopting Analysis Services to enable data exploration and ad hoc analysis by their users. One of their...
2019-10-15 (first published: 2019-10-09)
582 reads
SQL Saturday South Florida is on Saturday June 8th and its just around the corner! The event is hosted at the Nova Southeastern University campus in Davie, Florida near...
2019-05-31
8 reads
With the 2019 NFL Draft upon us, of course I wanted to visualize some NFL draft data in Power BI. So I put together this interesting set of visualizations...
2019-05-07 (first published: 2019-04-26)
1,503 reads
Coming up in just a couple of weeks, I’ll be presenting my session, Power BI Governance 101, at SQL Saturday #820 in Jacksonville, Florida on May 4th. The event...
2019-04-22
13 reads
Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...
2019-03-11
547 reads
I’ve finally updated my Power BI Architecture Diagram to include some of the new features that are now available and...
2019-02-16
434 reads
Like many of my blog posts, this post is inspired by some work I was doing with a customer who...
2018-09-18 (first published: 2018-08-31)
2,109 reads
I’ve had a lot of people ask me for this over the past few months and its finally (mostly) ready!...
2018-09-03 (first published: 2018-08-21)
2,381 reads
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...
2018-06-09
336 reads
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
290 reads
With a little planning and care, we can find various ways to fulfill user...
By James-Serra
With two new relational database features (Result-set caching and Materialized Views) just GA’d in...
I was recently given the opportunity to speak at Pass Summit. As always (this...
I need help correctly formatting the following query to pull some date-related records: This...
Can you show me a better way to place hardcoded values into a sql...
Ask SSC