(Steve Jones) This is the second part in the Beginners series and a short one since I’m a little buried. However, it’s a common topic that I think many of you will run into. It’s something I’ve been asked more than a few times and answered questions for, but something that most people new to SQL Ser
Other News
SQL Server Service Broker (Sample Chapter)
(Bob Beauchemin, Niels Berglund, and Dan Sullivan) SQL Server Service Broker(SSB) is a new part of the database engine that is used to build reliable, asynchronous, message-based distributed database applications. Service Broker allows these applications to concentrate their development efforts on t
SQL Joins with Examples
(DotnetFreak) This article will explain about the basics of SQL joins.
How to use Reporting Services to configure and to access an Oracle data source
In Microsoft SQL Server 2000 Reporting Services, you can build and deploy a report that uses data from an Oracle data source. This article describes how to configure and access an Oracle data source for a report that you develop and deploy by using Reporting Services. You can use an Oracle data
Exchange Data More Securely with XML Signatures and Encryption
(Mike Downen and Shawn Farkas) The XML Signature and XML Encryption standards are being used extensively as building-block technologies. Microsoft Office InfoPath uses XML signatures to sign partial or whole forms. Web services use XML signatures to sign SOAP messages and XML encryption to encry
Implementing Web Applications with CM Information Integrator for Content and OnDemand Web Enablement Kit
(Wei-Dong Zhu) In this IBM Redbook, we deal with implementing Web applications using IBM DB2 Content Manager Information Integrator for Content Version 8 and IBM DB2 Content Manager OnDemand Web Enablement Kit. It is aimed at designers and developers of Content Manager systems. (pdf)
ADO.NET and Cloudscape
(Yip-Hing Ng and Ron Reuben) ADO.NET support is available for IBM Cloudscape Version 10.0 and Apache Derby databases with Microsoft’s Open Database Connectivity (ODBC), .NET Data Provider, and the IBM DB2 Run-Time client. This article is organized into sections describing Derby/Cloudscape’s ADO.NET
XQuery: Reporting XML Data
(Seshu Kumar Adiraju and Srinivas Thonse) Reporting is an important functionality in software business applications and is now increasingly required for XML data. Applications typically generate reports by extracting relevant information from a database.
Learn to Use the New Data Source Controls in ASP.NET 2.0
(Wei-Meng Lee) There’s no shortage of useful, new controls to investigate in ASP.NET 2.0. In my last article, I discussed the new GridView and DetailsView controls. In that article I also discussed the use of the SqlDataSource control, which allows you to declaratively connect to a SQL data source w
Submitting A Stored Procedure Asynchronously
(Gregory A. Larsen) Have you ever wondered if you could start the execution of a stored procedure (SP) asynchronously from some T-SQL code? What I mean is starting the SP in the background and continuing on with the next line of code in your T-SQL script without waiting for the execution of the SP t