SQL Server 2005 SP2 Available
And it is available today. Microsoft released SQL Server 2005 SP2 [http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx] .…
SQL Server 2005 SP2 later today?
Rumor [http://blogs.msdn.com/bimusings/archive/2007/02/16/sql-2005-sp2-most-likely-available-this-monday-2-26.aspx] has it we're going to see SP2 for SQL Server 2005 later today.…
Test Article
This is my test article. This is the second line. I want a paragraph! And another! First Header And some text. Second Header And some text. Let's see about some code. And some more code. Woot! Code rules! No!…
Using a Custom Field Delimiter in SSIS Text File Import
Recently I was writing an import in SSIS and needed to use a ASCII 127 as delimiter. I know you can type a custom delimiter into SSIS but ASCII 127 is the delete character. Steve Kass [http://www.users.drew.edu/skass/] reminded me that SSIS' .dtsx files are…
HP Media Vault (SOHO NAS)
I'm a self-employed consultant and spend quite a bit of time working out of my home. I was in the market for a small, cheap NAS with some fault-tolerance. I first consider the D-Link DNS-323 [http://www.dlink.com/products/?sec=0&pid=509] . Everything about it…
Blog Updates
I finally updated the software on this site to the latest SubText build. That has better software to prevent spam. I also updated the CAPTCHA to be case-insensitive and deleted over 40,000 pieces of spam from our comments. I still have a little ways to go on the spam…
PASS 2006: The Pre-Conference Seminars
One of my roles on the PASS Board of Directors is to develop the program for our annual Summit. Our next PASS Summit is in Seattle November 14th - 17th, 2006 [http://w3.sqlpass.org/summit06/BG]. The general sessions are broken into tracks for database administration, business intelligence, application…
Weblog Software Upgraded
I've upgraded the weblog software on the site to SubText [http://www.subtextproject.com]. All the feeds should stay the same. Most of the blogs will look nicer once the posters choose a new skin. We should also see less spam on the site. Please let me know…
ClearTrace Video
I created a small video [http://www.cleardata.biz/cleartrace/ClearTraceDemo.wmv] to demo ClearTrace [http://www.cleardata.biz/cleartrace/default.aspx]. It's only about two minutes long. This is also the technology we're planning to use at the PASS Conference to capture presentations.…