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
680 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,533 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,701 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
674 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
579 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
642 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
676 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,736 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,484 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,309 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers