(Karen Coyle) With the newly developed enthusiasm for RDF as the basis for library bibliographic data we are seeing a number of efforts to transform library data into this modern, web-friendly format. This is a positive development in many ways, but we need to be careful to make this transition clea
Other News
How to quickly identify queries with pt-query-digest and pt-query-advisor from rules ?
(Cédric PEINTRE) Today I’m working on integrate the Percona toolkit (instead of maatkit) in my own tools and I’m playing with pt-query-digest and pt-query-advisor.
Failover to Snapshot Standby
(Uwe Hesse) In a recent Data Guard course that I tought, the question came up whether it is possible to failover to a Snapshot Standby if the Primary is lost. My answer was that this is of course possible but will take a longer time, because first the Snapshot Standby need to be converted back to Ph
SharePoint Online in a hybrid environment
(Andre Kieft) Recently I got into a discussion on how to implement SharePoint Online in a hybrid environment with SharePoint 2010 on-premise. How does this exactly work and how should we implement it?
DB2 security audit
(Jack Vamvas) The SYSIBM.SYSDBAUTH maintains user privileges on databases.
Exporting Selected tables from a SQL Database
Many times we run into a requirement when we have to export few tables from a database. Now it could be for sharing that information with someone else or sending it to the support guys. One of the easiest way to achieve same is by using SQL Import and Export Wizard.
Working With SqlDataReader Class in ADO.NET
(Alok Pandey) In my previous article, I have explained the SqlConnection and SqlCommand classes with thes methods ExecuteNonQuery and ExecuteScalar. Here I am describing the ExecuteReader() method of the SqlCommand class and th SqlDataReader class.
Walkthrough: Creating and Using an ASP.NET Web Service in Visual Web Developer
This topic pertains to a legacy technology. XML Web services and XML Web service clients should now be created using Windows Communication Foundation.
Trying To Mimic LET Functionality In JavaScript Using Self-Executing Functions
(Ben Nadel) Last night, I was listening to the Lately In JavaScript podcast. Among the many items discussed, one topic that was brought up was the emergence of the LET keyword in the next version of ECMAScript (the language on which JavaScript is based).
On complex optimizations and optimizer hints
(Sergey Petrunia) In an ideal world, you should never need to use optimizer hints. In the real world, hints are necessary. We needed hints even before we’ve made a release. The first requests came from our Quality engineer who complained about it being difficult to hit particular join orders while u