Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
2,997 reads
Blog Posts
Extreme Work
"The Productivity Pro" Laura Stack posted in her blog today about jobs where long hours are the norm:
'Extreme' jobs...
2006-12-05
1,484 reads
Guidance on Microsoft Certified Architect Submissions
For those considering the Microsoft Certified Architect program, some guidance on what to submit as documentation has been posted to...
2006-12-05
1,453 reads
Bad weather and Power Outage
After years of mild weather in the St. Louis area, this is the second time we have been hit hard...
2006-12-02
1,332 reads
Excellent post on encryption
Laurentiu Cristofor has an excellent blog post, Who needs encryption?, which presents some point blank facts about encryption and the...
2006-12-01
1,645 reads
Professional Association of SQL Server - Midlands Chapter First Meeting
If you are in South Carolina or a nearby location (Charlotte, Augusta, etc.) and are interested in participating in an...
2006-12-01
1,577 reads
TechEd 2007 tracks announced
The Microsoft TechEd tracks have been released early here:
Sneak Peak at the 2007 Tracks
For those who are interested in attending...
2006-12-01
1,484 reads
Data Dude
I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The...
2006-11-30
1,581 reads
ApexSQL SQL Server VIP/MVP Offer
ApexSQL has an offer to anyone who is a SQL Server MVP or VIP for a gratuity of their ApexSQL...
2006-11-29
1,741 reads
Measuring pi by throwing frozen hot dogs?
I saw this today on my Google front page under the How To section:
How to Calculate Pi by Throwing Frozen...
2006-11-29
1,624 reads
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
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...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers