SQL Server Pro Article: Custom Programming to Enhance SSRS Reports
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...
2013-07-02
915 reads
SQL Server BI Blog
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
590 reads
Time to Complete the 2013 BI Survey
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take...
2013-06-10
499 reads
Taking the Tabular Journey
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services....
2013-06-02
783 reads
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
794 reads
Visual Studio 2012/SSDT Addition for BI Project Version Compatibility & Themes
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past,...
2013-03-08
1,086 reads
SQL Server Community World Tour with GeoFlow
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This...
2013-03-06
703 reads
Speaking at the Business Analytics Conference, April 1-12 in Chicago
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...
2013-02-06
685 reads
Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,930 reads
Reporting Services 2012 BI Training
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert...
2012-12-10
1,534 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers