(Teodor Zlatanov) In this installment, the author looks at Perl and databases. Specifically, he works with the Class::DBI CPAN module and MySQL to introduce you to embedding Perl in database tables.
Other News
Introduction to SQL (Sample Chapter)
(Sanjay Mishra and Alan Beaulieu) In this introductory chapter, we explore the origin and utility of the SQL language, demonstrate some of the more useful features of the language, and define a simple database design from which most examples in the book are derived.
SQL Profiler Tips and Tricks
(Mike Gunderloy) If you’re a developer who works with SQL Server, you probably already know about SQL Profiler, the graphical tool that lets you capture and analyzer SQL Server events in real time. If you’re not familiar with this tool, check out my previous article, “Introduction to SQL Profiler”.
An Introduction to Microsoft SQL Server 2000 Reporting Services
(Don Franke) As programmers, when building data-driven Web sites we typically focus our energies on defining what information needs to be accepted by the end user, and ensuring that this data is properly entered into some backend data store properly via a Web interface. After all, if a Web appli
Why it’s OK to have more latches than CPUs
(Craig A. Shallahamer) We have all heard that it doesn’t make sense to have more latches than the number of CPUs. Why? Because you can never use more latches simultaneously than the number of CPUs. While this appears to make perfect sense, it conceals a hidden lie. And here’s why… (R)
MSDN Webcast: Managing XML Data on the Database with SQL Server 2005 and Visual Studio 2005
This session explores advanced concepts and techniques for working with XML data types using Microsoft SQL Server 2005 and Visual Studio 2005. Topics covered include casting to and from CLR types, working with XML on the provider level, and integrating with SQLXML 4.0. Learn how to pass XML into CLR
Security is the catch word for SQL Server’s sequel
(Margie Semilof) Improved security in SQL Server 2005 is the No. 1 reason database professionals will tell their senior managers why they need to start planning a move up to Microsoft’s newest database management platform when it becomes available later this year. (R)
Develop Enterprise Solutions With UML
(Hal Hayes) “My kingdom for a … good book that covers UML modeling with Visual Studio .NET!” Was this the anguished cry of Shakespeare’s Richard III? More likely it is the frustrated diatribe of project managers, team leaders, and even new developers who face the sometimes daunting task of creating
Migrating from ASP to ASP.NET
Learn some of the differences when moving from VBScript-based ASP pages to Visual Basic.NET-based pages running inside of ASP.NET. Stefan Schackow demonstrates dealing with changes in variable declaration syntax, subroutine usage and inline code, data access with ADO, and VB-style error handling.
Intro to WebSphere Information Integrator OmniFind Edition
This tutorial provides a guided tour through the WebSphere Information Integrator OmniFind Edition. It starts with an overview of the product that will focus on its main features. The intent is to give you enough information to understand the subsequent steps. Then, it describes the installation and