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
681 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,536 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,710 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
676 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
580 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
644 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
678 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,738 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,485 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,310 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers