SQL Server MVP Randy Dyess webcast on SQL Server 2008 Security
SQL Server MVP Randy Dyess has a short webcast which provides the highlights of SQL Server 2008 security.He includes some...
2008-02-03
613 reads
Blog Posts
SQL Server MVP Andy Leonard on .NET Rocks!
SQL Server MVP Andy Leonard is on the latest edition of .NET Rocks! If you're not familiar with .NET Rocks!,...
2008-02-01
748 reads
The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...
2008-01-31
1,663 reads
A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,301 reads
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,561 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,395 reads
IT Transparency Posted on SSC
As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to...
2008-01-29
1,304 reads
Ken Henderson has passed away
I know I'm not the first in the SQL Server community to post this, but Ken Henderson has passed away...
2008-01-29
1,908 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,667 reads
The Long Tail
Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes...
2008-01-29
1,482 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