(Roger Sanders) This tutorial introduces you to embedded SQL programming and walks you through the basic steps of constructing an embedded SQL application. The tutorial also introduces you to the process used to convert one or more high-level programming language source code files containing embedde
Other News
Using SQL Server Yukon’s .NET CLR Features Practically
(Kent Tegels) When I was first introduced to Peanut Butter Chicken, I had many questions: What does it taste like? Why would one want to mix Peanut Butter and Chicken? How do you prepare it? Who thought this up? I was hooked for life with the first bite. When I first heard that the next version o
SQL Server 2000 for Experienced DBAs
There are a lot of SQL Server books designed for beginning DBAs, but not a lot for the experienced DBA. In this book, Brian Knight has helped to fill this gap with this book, aptly called, SQL Server 2000 for Experienced DBAs. This book covers many topics not covered, or just barely covered in other
Review of ApexSQL Report v4.3
(Mike Pearson) ApexSQL Report is designed for flexibility and fast turnaround of reporting in a dynamic Rapid Application Development environment. The current version (v4.3) is ASP based, with v5 coming out soon in ASP.NET. (R)
XML for Client-Side Computing
(Coach Wei) XML is a simple, flexible text format initially designed for large-scale electronic publishing. It is flexible, open, and human-readable, and can be learned easily. XML can also be generated, parsed, analyzed, and transformed easily. It’s no wonder that XML has been widely used for serve
Turbo-Charged Data Warehousing
(David Beulke) The improvements in DB2 Universal Database (UDB) for z/OS version 8 have enhanced DB2’s data warehousing capabilities on the z/OS platform. Like a high-performance car, DB2 has been turbo-charged with SQL enhancements, new table-design options, and new indexing choices. These features
SQL Server 2005: Late but Loaded
(Brian Moran) Two weeks ago, I wrote about the delay of SQL Server 2005, formerly code-named Yukon. Microsoft has pushed back commercial availability of SQL Server 2005 to the first half of 2005, presumably closer to June than January. In my earlier article, I asked you to share what effect SQL Serv
Thinking Big – Java Development with LOBs in DB2 Universal Database
(Kulvir Singh Bhogal) This article uses a real-world example to show you how to use large object data types with DB2 Universal Database in your Java development.
Using XSLT and .NET to Manipulate XML Files
(Cynthia Carolina) XML Stylesheet Transformations (XSLT) is defined as a language for transforming source XML documents into another document formats using XML Path Language (XPath) as a query language. This is particularly useful when incoming or outgoing XML documents do not match the document typ
FIX: You may receive an Internal SQL Server error error message when you run a Transact-SQL SELECT statement on a view that has many subqueries in SQL Server 2000
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this