A Precarious Balance

This post falls into the category of ''Solution for a technical issue for which I found no help on the Internet''. Overview If you're using adhoc SqlParameters with a SqlDataAdapter and notice that calls to the SqlDataAdapter's Fill method take longer than expected, try using a typed SqlParameter instead of an adhoc ...

This last Tuesday, Phillip and I drove up to Denver for a Microsoft launch event. The launch event, like all the others this past month or so, premiered Visual Studio.NET 2005, SQL Server 2005, and the beta of BizTalk Server 2006. It was the first time I've been to a launch event. It felt good to be in the presence of 3,000 to 4,000 folks who are ...

In my current project, we're playing with SQL Server Log Shipping to see if it can be used to maintain a relatively fresh backup database. We haven't switched over to SQL Server 2005 yet, so we have not yet tried Data Mirroring. I ran into an interesting situation when putting the monitor server on the secondary server (i.e., the SQL Server ...