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 W. DeBetta | 6 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 . Read More... Posted Thursday, July 13, 2006 2:34 PM by Peter W. 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 W. DeBetta | 3 Comments

• Test Cross-Posting to WordPress

  This is a test to see if CS can cross-post to a WordPress blog... Read More... Posted Tuesday, July 11, 2006 1:50 PM by Peter W. 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. Read More... Posted Friday, July 07, 2006 1:02 PM by Peter W. DeBetta | 6 Comments