This article describes how to determine the version of Microsoft SQL Server 2005 Integration Services (SSIS) that is installed on a computer.
Other News
Sending Email in ASP.NET 2.0: Reply-To, Priority, and Read Receipts
(Scott Mitchell) Email serves as a ubiquitous, asynchronous notification and information distribution system. Not surprisingly, there are many web development scenarios where server-side code needs to generate an email and scuttle it off to the intended recipient. Previous articles here on 4Guys hav
An Introduction to XML Data Binding in C++
(Boris Kolpackov) XML processing has become a common task that many C++ application developers have to deal with. Using low-level XML access APIs such as DOM and SAX is tedious and error-prone, especially for large XML vocabularies. XML Data Binding is a new alternative which automates much of the t
The Lead Manager application in IBM Lotus Notes V8: An overview
(Susan Bulloch) IBM Lotus Notes V8 brings the power and benefits of composite applications to the Lotus Notes user community. These composite applications, called business style mashups by some, can be accessed from the local Lotus Notes data directory, the IBM Lotus Domino V8 server, or even a serv
mysql – ENUMs and sql_mode
(Mark Robson) I’ve been doing a few experiments with ENUMs and SQL_MODE.
Using Named Parameters within SQL
(Pawe³ Barut) One of the Oracle 11g new feature that I like is ability to use Named Parameter syntax in functions calls inside SQL.
SQL Server Management Objects: Lessons from the Wild
(Michael S. Jones) Prior to SQL Server 2005, Microsoft’s SQL Distributed Management Objects (SQL-DMO) offered the most efficient way to manage SQL Server programmatically. SQL-DMO supported a COM-based interface that you could use to discover and manipulate SQL Server objects. With SQL Server 2005 M
New SQL Server Show Live Now
New SelectViews Show Posted (and a new format!) We’re experimenting with releasing the show in segments, so you’ll be able to watch different portions of the show at different times during the week (we’ll be releasing a segment every day now). OR, you can tune in on Fridays (starts next week) to watch the entire program all at once automagically. […]
Astoria: REST Web services extensions from Microsoft
(Daniel Rubio) Major trends are clearly drawn in the Web services landscape by now. Take for instance the use of the enterprise service bus (ESB) as an SOA enabler, or the widely debated SOAP vs. REST design approach, or how the WS-* stack addresses many enterprise scenarios. The point is that the i
Using T-SQL Stored Procedures with ASP.NET 2.0
(Michael Youssef) If you haven’t used T-SQL stored procedures before with SQL Server and in your ASP.NET 2.0 pages then you need to read this article. Today I will answer questions like the following: what is a stored procedure? How can I create a stored procedure? How can I use it from within my AS