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
737 reads
James Serra's Blog
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,057 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,004 reads
Parallel Data Warehouse (PDW) Version 2
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,717 reads
Top BI Enhancements for SQL Server 2012 Presentation
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
841 reads
Profisee Master Data Maestro
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,124 reads
Visual Studio 2012 now supports BI!
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does...
2013-03-06
2,797 reads
Microsoft Data Explorer
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
1,996 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter. There were over 200 attendees! The recording of...
2013-02-28
1,628 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual...
2013-02-26
947 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers