Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,485 reads
Samuel Vanga
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
820 reads
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
784 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from...
2013-01-15
559 reads
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from...
2013-01-15
498 reads
Every ebook from Apress for $15
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
979 reads
PASS SQL Saturday World Map
I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday...
2012-11-20
1,001 reads
PASS Summit 2012 Twitter Dashboard
As a business intelligence developer, my skills include taking the raw data, shaking it to remove all the junk, and...
2012-11-12
1,533 reads
Create Several Shell SSIS Packages In Minutes Using BIML
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,666 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,467 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