Development of SQL 2008 SSIS Packages Requires SSIS Service
Unlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation.
Its time for a code freeze again
Its the holidays again, and that means its time for a code freeze. Code freeze’s are handy for a few reasons. People like to take vacations this time of year for some reasons. With a code freeze in place everyone can spend the holidays with family rather than with the servers. With everyone taking time […]
SQLServerPedia.com Webcast Archived
I’ve been informed that the webcast I did last week with some of the other editors for SQLServerPedia.com has been archived for offline viewing. Denny
Back To Basics: Getting Data from an XML Document
One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using […]