(Pinal Dave) During my recent visit to customer site for a session on backups, they asked me to find the cause of the error while restoring a differential backup.
Other News
Analyzing Historical Performance Data
(Lockwood Lyon) Let’s assume that as a DBA you are given the assignment of performance tuning in the DB2 z/OS environment. Is there more than one way to do this?
WPF Data Display Controls Class Hierarchy
(Richard Carr) The one hundred and seventeenth part of the Windows Presentation Foundation Fundamentals tutorial looks at the base classes of the WPF data display controls. This article includes the inheritance hierarchy of all of the WPF controls seen in the tutorial so far.
Using Variables Into XPath Queries In ColdFusion
(Ben Nadel) In ColdFusion 10, xmlSearch() added support for XPath 2.0 syntax and passing variables into XPath queries. Using variables can make the query more readable; but, since XML is case-sensitive, it took me a few minutes to get it working.
ProData Freshens Up Database Access with RDB Connect 4
(Alex Woodie) The days when all the data you needed to access resided in DB2/400 have long since passed, and today, being able to access data on other systems is a fact of life. One vendor helping IBM i shops get the most out of their disparate data sources is ProData Computer Services, which recent
Percona XtraDB Cluster: How to run a 2-node cluster on a single server
(Fernando Laudares) I reckon there’s little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes – but doing so is still useful in those cases. The most popular way of achieving this seems to be with server virtuali
Namespaces in JavaScript
(Himanshu Dora) This tip describes basic information on how to use namespaces in JavaScript and their role. Why should we use namespaces and finally Aliasing Namespaces.
Noding and building a polygon from single, overlapping linestrings
(Simon Greener) The Spatial Companion 4 Oracle (SC4O) package (built using Java Topology Suite components) contains a method called ST_PolygonBuilder that can then form polygons from linestrings.
Please sp_help My System Stored Procedure
(Tony Davis) SQL Server provides a large number of built-in stored procedures that can tell us all sorts of useful information about what’s going on in our SQL Server databases.
Webforms to MVC: Handling the User Control Transition
(Peter Shaw) Many of the newer breed of .NET developers have entered a world where they only know ASP.NET MVC as a way of developing complex web applications; there are, however, still a great many of the slightly older generation out there who are stuck in Webforms land.