July 2006 - Posts

• context connection=slow?

  The subject of this post may be a little misleading. When writing CLR code in SQL Server 2005 that requires querying the data, you should connection back to the data using the connection string "context connection=true". However, there are occasions when Read More... Posted Friday, July 21, 2006 2:59 PM by Peter DeBetta | 2 Comments

• SQLblog.com Registration is now open...

  Just a brief post to let everyone know that you can now register on the site by clicking here . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Thursday, July 13, 2006 2:34 PM by Peter DeBetta | 1 Comments

• Using XML Data Type Methods to query SSIS Packages

  So a few weeks ago I was doing some work on SSIS Packages and I needed a quick way to get some information from the package. Although the Visual Studio (AKA SQL BI Dev Studio) Package Designer is nice, it can be cumbersome to fetch various pieces of information, Read More... Posted Thursday, July 13, 2006 10:26 AM by Peter DeBetta | 1 Comments

• Test Cross-Posting to WordPress

  This is a test to see if CS can cross-post to a WordPress blog... Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Tuesday, July 11, 2006 1:50 PM by Peter DeBetta | 0 Comments

• Anonymous Comments Enabled (Testing ReverseDOS)

  Anomymous comments have been enabled on the site. Thanks to Mike Campbell of AngryPets.com for his ReverseDOS tool and for helping me get it configured. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Friday, July 07, 2006 1:02 PM by Peter DeBetta | 6 Comments