(Edward Tanguay) Getting information about databases if essential if you want to write generic and scalable applications. This code shows you how to get information such as all databases on the server, all tables in each database and all field and field info for each table. Even if you do not need t
Author: SSWUG Research
Easily parse string values with .NET
(Tony Patton) Processing string values is an integral aspect of most application development projects. This often involves parsing strings into separate values. For instance, receiving data from an external data source such as a spreadsheet often utilizes a common format like comma-separated values.
Abstract Classes in PHP: Introducing the Key Concepts
(Alejandro Gervasio) An abstract class is a class that cannot (or should not) be instantiated. They are surprisingly useful for certain purposes. In this article, you will learn the important concepts related to abstract classes in PHP 4, and see many hands-on examples that will allow you to make us
Database Security and Patches – Part 5
(Steve Callan) Between Oracle’s critical patch updates and security alerts, perhaps a better phrasing of “Unbreakable” would be “Unbreakable (when patched).” Other articles exist which qualify and clarify what “unbreakable” actually means, and defining “unbreakable” is not the point of this particul
Simplify .NET Debugging with SmartInspect
(Paul Ferrill) Efficient software debugging is definitely an acquired talent. Most programmers have some ideas on how to do it when they first get started but typically can’t handle a large complex program that doesn’t work. Add multithreading to a complex program and you’re sure to lose most junior
It takes a long time for the SQL Server service to start on a Windows Server 2003-based computer
Consider the following scenario. You are running Microsoft SQL Server 2000 Service Pack 1 (SP1), Microsoft SQL Server 2000 Service Pack 2 (SP2), or Microsoft SQL Server 2000 Service Pack 3 (SP3) on a Microsoft Windows Server 2003-based computer. You try to start the SQL Server service. In this scena
DB2 UDB: Discover the power of SQL Stored Procedures
Stored procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedure language that is comparable with stored procedure language
Q&A: Making the jump to 64-bit SQL Server 2005
(Adam Machanic) Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the expensive Itanium line of pro
Better Collation Rule Markup: a critique of Locale Definition Markup Language
(GrahamAsher) Unicode, Inc., administers and maintains the Common Locale Data Repository (CLDR), in which are stored XML files containing locale information, including collation tailorings, for many different locales. The format of the XML files is called Locale Data Markup Language (LDML).
JavaScript SOAP Client
(Matteo Casati) A lot of talking about AJAX is taking place here and there; AJAX is the acronym of “Asynchronous JavaScript and XML”, a technology based on XMLHttpRequest, which is now supported by all main browsers. The basic idea is quite simple – and not actually a breakthrough – but it allows up