Managing Report Project Deployments & Version Control
What lessons have we learned about managing report projects and what are the best
practices?
Since each report is stored in a...
2010-03-11
1,237 reads
SQL Server BI Blog
MDX Datasets with Date Parameters
How should date type parameters be prompted? There are two common approaches
depending on how you want the parameter to appear. ...
2010-03-11
392 reads
Self-Service Reporting Best Practices on the Microsoft BI Platform
Article from the Architecture Journal ? 12-15-2009
by Paul Turley
Once upon a time, there was a big company whose IT department
wanted...
2010-03-11
861 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