Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
541 reads
Blog Posts
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,449 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
842 reads
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
496 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,566 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
867 reads
MS Making .Net Framework Source Code Available
Scott Guthrie posted the announcement on his blog today. It's a 'read only' license with a few other limitations, but...
2008-01-17
766 reads
MVP Chat
My first MVP chat was today, a monthly hour long session where we have a Microsoft representative and we all...
2008-01-17
725 reads
Partitioning Part 4 Posted on SSC
Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series...
2008-01-17
566 reads
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers