PASS SQL Saturday in Chicago Presentation Slides
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
761 reads
James Serra's Blog
PASS Business Analytics Conference Presentation Slides
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
706 reads
PASS Business Analytics Conference Live Blog
Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...
2013-04-12
741 reads
PASS Business Analytics Conference
The PASS Business Analytics Conference is almost here! Check out the sessions to be presented at the conference and you will see...
2013-04-08
931 reads
Microsoft BI tools: How they use data sources
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,285 reads
SQL Server 2012 Business Intelligence Enhancements
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,579 reads
TFS vs SSIS project versioning
I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit...
2013-03-26
4,101 reads
Benefits of using views in a BI solution
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
743 reads
Why you need Business Intelligence
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,062 reads
Top BI Enhancements for SQL Server 2012 Presentation Slides
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
1,005 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