PASS Business Analytics Conference Presentation
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago...
2013-01-23
1,401 reads
James Serra's Blog
SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,241 reads
SSAS: One giant cube or many small ones?
When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but...
2013-01-15
7,708 reads
MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,268 reads
Master Data Management (MDM) Hub Architecture
The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in...
2013-01-08
8,821 reads
MDS: The Microsoft SQL Server license has expired
When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU),...
2013-01-03
2,554 reads
PASS Summit 2012 session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash...
2012-12-27
1,984 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter. The recording...
2012-12-21
1,179 reads
PASS SQLRally Nordic 2012 videos online
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
894 reads
Managing Schemas And Source Control For Databases
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for...
2012-12-18
4,952 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