Color Themes for Power BI
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration...
2016-03-22
1,149 reads
SQL Server BI Blog
Annual Business Intelligence Survey
This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research. I’ve been participating in...
2016-03-15
456 reads
Article Series: Power BI Solutions for the Enterprise
I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published...
2016-02-28
876 reads
Gartner Magic Quadrant for BI/BA and the Lone Three Leaders
History clearly confirms that good things come in threes. As far as I know this is the first time that...
2016-02-05
502 reads
Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016
Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ...
2016-01-26
521 reads
Tabular Models, Multiple Data Sources and Unknown Members
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from...
2015-12-29
1,051 reads
Complete DAX Function Reference
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for...
2015-11-26
1,025 reads
SQL Server 2005 End of Support and Business Intelligence
How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...
2015-12-02 (first published: 2015-11-24)
1,876 reads
The Resurrection of Reporting Services & The Maturing of Power BI
Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal...
2015-11-12
477 reads
Oregon SQL Saturday 2015 Keynote
This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th. ...
2015-10-02
465 reads
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
Has the PK been used --
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers