Twas The Week After Christmas - 2012 Edition
Season's Greetings and Merry Christmas! In the spirit of the holiday, I am rerunning my original parody on "Twas the...
2012-12-24
1,015 reads
Blog Posts
Generate MERGE Statements for Your Tables
Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply...
2012-12-23
1,562 reads
How About a PASS Holiday Ornament?
One of the simpler pleasures in life is having an idea and putting it up for discussion. Not all ideas...
2012-12-23
902 reads
How to drop all tables in a SQL Server Database whose name begins with a common value
Scenario
I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables...
2012-12-23
2,699 reads
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season.
Silver and Gold also...
2012-12-22
1,256 reads
On the Tenth Day…
Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We...
2012-12-22
3 reads
Tracking End of Support/Life Software
I wanted to save this link to the Microsoft Support Lifecycle page and thought I’d share as well. It’s a...
2012-12-22
1,175 reads
What Is Your Mindset?
Steve Jones sent me a link to this post about Intelligence vs Effort months ago, since then I’ve looked at...
2012-12-22
787 reads
A really simple Multiprocessing Python Example
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,753 reads
Dude Where Did my AD Account Go? Troubleshooting Duplicate SID's.
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,479 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers