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
875 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
518 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,048 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,023 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,873 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
476 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
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Marketing Analyst: The Data-Driven Superhero Your Company Needs
Want to blend your love of marketing with the power of data? Becoming a...
Can You See Table Valued Parameters in Extended Events?
I live for questions and this was an interesting one. Can you see Table...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How Can Programmatic Ads Benefit Insurance Businesses?
Programmatic advertising offers numerous advantages for insurance businesses advertising looking to enhance their marketing efforts efficiently....
Create managed identity on Azure SQL MI/ Azure SQL DB using sql login
I am able to successfully create managed identity on Azure SQLMI & Azure...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers