New SSIS Book to be Released
If you've noticed a significant drop in my blogging I apoligize but I've been working on an exciting project with...
2009-04-06
682 reads
Devin Knight
SQL Agent Job failure with FTP connection
There are hundreds of post on this topic but I just ran into this problem recently so I thought I...
2009-03-04
1,538 reads
Cube Processing Error HY008
If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing...
2009-03-02
34,713 reads
PASS BI SIG
Yesterday I participated in my first BI SIG live meeting. This special interest group is led by Amy Lewis who...
2009-01-15
679 reads
Thanks to PASS - Free Laptop
It seems like the benefits of being involved in PASS just never stopped. If you didn’t see the PASS newsletter...
2009-01-15
581 reads
Windows 7 Beta Delayed
Looks like the Windows 7 beta download has been delayed while Microsoft adds additional infrastructure support. A little disappointing but I...
2009-01-09
647 reads
Windows 7 Beta Release Friday
Tomorrow Microsoft will make Windows 7 beta available for download. I’m a little skeptical but I think just about anyone...
2009-01-08
680 reads
SSIS – CHECKSUM Transformation
CHECKSUM is a TSQL function that computes a hash value over a list of arguments. The great thing about creating...
2009-01-05
20,741 reads
Review of Seadragon: Microsoft’s iPhone application
So I’ve spent the last couple of weeks playing around with the Seadragon application and have come to some conclusions.
Usefullness...
2008-12-29
1,486 reads
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2008-12-29
14,311 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers