Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.
2026-09-09 (first published: 2025-05-27)
5,811 reads
Master advanced DAX in Power BI and Microsoft Fabric to build scalable semantic models, solve complex business problems, and deliver high-impact analytics using real-world scenarios and proven techniques.
2026-08-05 (first published: 2026-06-22)
511 reads
In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.
2026-04-17 (first published: 2025-03-26)
2,499 reads
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.
2025-08-18 (first published: 2025-05-27)
1,923 reads
Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007.
2022-04-27 (first published: 2009-02-10)
5,282 reads
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
2022-04-27 (first published: 2009-02-10)
7,584 reads
Best of SQLServerCentral vols 1-4 pulls together some of the best contributions to SQLServerCentral.com between 2002 & 2006.
2022-04-26 (first published: 2009-04-16)
5,961 reads
The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.
2009-11-12
6,481 reads
Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.
2009-06-03
3,428 reads
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers