Consider the following scenario. You delete some rows from a table in Microsoft SQL Server 2000. You run the sp_spaceused stored procedure against the table. In this scenario, the result of the sp_spaceused stored procedure shows that lots of space in the table is not released. This problem is not r
Other News
To log or not to log, could this even be a question?
(Willie Favero) For the first time in DB2’s 24 years, you are being given the option to shot yourself in the foot for just about any user table space defined to DB2.
Validating Incoming Data by Using Polymorphism with Objects in PHP 5
(Alejandro Gervasio) If you’re a PHP developer who wants to learn how to take advantage of polymorphism to build more efficient and robust object-oriented applications, then this group of articles might be what you need. Welcome to the final part of the series that started with “Using Polymorphism w
How to alert on system errors
(Simon Sabin) Alerts in SQL server rely on the error being logged to the event log. Not all system messages are logged which means you can’t alert on them. In SQL 2000 you could hack the sysmessages table, however in SQL2005 you can’t.
Building a PreserveProperty Control in ASP.NET 2.0
(Rick Strahl) ASP.NET provides a couple of page-level state persistence mechanisms in ViewState and the new ControlState.
Simplify XML reads and writes
(Cameron Laird) XPath can dramatically simplify and speed applications with even modest XML involvement. If XPath isn’t already in your toolkit, now’s the time to add it. Concrete examples coded in brief Python make the appeal of query idioms apparent.
Scaling out with distributed partitioned views in SQL Server 2005
(Tim Chapman) I have examined the differences between scaling up and scaling out your SQL Server environment and explained how to scale out your system with either horizontal data partitioning or vertical data partitioning. In this final installment of the series, I provide a more in-depth look at s
Integers in PHP, running with scissors, and portability
(Andrew Aksyonoff) Until recently I thought that currently popular scripting languages, which mostly evolved over last 10 years or something, must allow for easier portability across different platforms compared to ye good olde C/C++.
Configuring MQ from Oracle App Server
(Antony Reynolds) I have just been fighting to get MQ Series working with OC4J as a stand alone resource provider with the minimum of effort and in the most easy to understand way. Thought I would share with you the results of my travails.
Introducing RDFa, Part Two
(Bob DuCharme) In part 1 of this article, we saw that RDFa, a new syntax for representing RDF triples, can be embedded into arbitrary XML documents more easily than RDF/XML. RDFa is particularly good for embedding these triples into XHTML 2, which has a few new attributes that make it easier to use