Creating GUID Derived Column in DTS
If you want to add a constant GUID to a table during a DTS transformation, it’s a little tricky. Here’s the solution.
Recent Posts
Monitoring a WCF Service Host
One problem I’ve been running into is my ServiceHosts failing out in my long running background services. I’ve written the following class to help monitor th...
Extracting The Date From a SQL DateTime In SQL Queries
Ever wondered how to quickly and easily get the date portion of a datetime field in a SQL query? Seems like it should be easy, right? Unfortunately, it isn’t...
SQL Server 2005 Service Broker Error Code 25 (Event ID 28054)
Another issue I’ve run into with the service broker and moving databases between servers is this error message:
Appending Text To The Titles Of All Web Pages
Have you ever wanted to add a text string, like an application name, to the title of all your web pages. It’s easy to do using the control adapters available...