SQL Saturday 62 – Tampa FL – January 15th 2011
On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous...
2010-12-18
1,194 reads
Brian K. McDonald
Two Digit Year Cutoff
I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...
2010-12-15
1,670 reads
Group Level Page Numbering using Reporting Services 2008 R2
Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...
2010-12-14
18,143 reads
Adding Existing Reports to Reporting Services Solution
If you’re anything like me, you create a ton of objects and have them in various projects. And sometimes, you...
2010-12-13
543 reads
URL Based Images using SSRS
For header images, I typically embed an image into the report. However, there may be times when you need to...
2010-12-13
819 reads
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management...
2010-12-07
1,015 reads
Processing a Measure Groups Index Using SSMS
As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...
2010-12-02
1,257 reads
SQL Server Magazine’s Favorite Go-To Websites for SQL Server Solutions
While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting...
2010-11-30
3,966 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,769 reads
Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
925 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