Windows 2000 Resource Kit Tools Available
If you're like me and rely a lot on the resource kit tools, you may have found that it's relatively...
2006-12-09
1,855 reads
Blog Posts
Log Buffer #22: A Carnival of the Vanities for DBAs
Welcome to the 22nd edition of Log Buffer, a
weekly compendium of postings and news from database-related blogs across the...
2006-12-08
1,588 reads
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,949 reads
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,483 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,452 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,331 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,642 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,575 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,483 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,580 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers