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
678 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,530 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,679 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
671 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
575 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
632 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
674 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,732 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,478 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,305 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers