Business Intelligence Roles and Team Composition
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is...
2014-06-17
464 reads
pturley
SSAS Performance Logger Now Available
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you...
2014-06-03
476 reads
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This...
2014-05-17
983 reads
What’s Happening at the PASS Business Analytics Conference?
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week...
2014-05-07
445 reads
Creating a Dynamic, Parameterized Measure in DAX
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...
2014-04-20
882 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
733 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
366 reads
Showing a 100% Progress Gauge in Power View
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. ...
2013-08-01
792 reads
DAX: Returning the Nth Selected Value in a Slicer
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that...
2013-07-13
744 reads
We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
720 reads
Blogs
Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant
Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Forums
Varchar(max) to lines
I have an issue with a varchar(max) field with up to 7000 characters needing...
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers