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
819 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,665 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,456 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers