Best Practices to Deliver BI Solutions
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need...
2013-08-08
1,530 reads
James Serra's Blog
Presentations slides for Best Practices to Deliver BI Solutions
Thanks to everyone who attended my session “Best Practices to Deliver BI Solutions” for Pragmatic Works. The abstract for my session...
2013-08-07
671 reads
Why use a SSAS cube?
What are the advantages of using SSAS Cubes over a regular data warehouse for reporting? Note I’m not asking why...
2013-08-06
1,685 reads
Best Practices to Deliver BI Solutions Presentation
I will be presenting a brand new session entitled “Best Practices to Deliver BI Solutions” tomorrow, August 6th, at 11am...
2013-08-05
835 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for 24 hours of PASS, PASS Summit Preview. The abstract...
2013-08-02
749 reads
PerformancePoint: Show Details greyed out
In PerformancePoint, when using a analytic grid or chart or a scorecard, if you are not able to use the...
2013-08-01
967 reads
SQL Server 2014: Columnstore Index improvements
In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements. In SQL...
2013-07-30
3,100 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for...
2013-07-29
1,169 reads
TechEd Europe 2013 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free! Some great videos...
2013-07-25
873 reads
SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton
What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...
2013-07-23
2,085 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers