(Edmon Begoli) I first wrote an XML-over-HTTP web service almost a decade ago. At that time, it seemed a completely natural solution to a practical business problem: provisioning web-based, product-pricing quotes. As web services became a formal technology with numerous standards, I became somewhat
Other News
Manage Recordsets in ADPs
(Danny Lesandrini) Much has been written about managing recordsets for forms, controls and reports in Microsoft Access databases, but recently I was obliged to develop an application with a slightly new twist that required some creative recordset manipulation. The requirements were as follows: 1
Maintaining a Log of Database Changes – Part 1
(Scott Mitchell) One of the benefits of using Source Code Control (SCC) software like SourceSafe, Perforce, Subversion, Vault, and others is that the software keeps a detailed history of all changes to the source code. With SCC, you can see how the code for a particular file has changed over time, a
Handling multiple data sets in stored procedures from Perl
(Giuseppe Maxia) MySQL stored procedures can use SELECT statements in their body, returning a data set to the caller. The manual also explains that multiple data sets can be returned from such a stored procedure.
Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipulation
(Tony Rogerson) If you are splitting a CSV that just contains numbers, for instance surrogate key id’s that you are passing in because of a multiple select checkbox or something and you know the values range then why split the string? It’s simpler than that – no splitting required, just use dynamic
Alert-based Transaction Log Backups – Automate your database Maintenance Part 2
(Allen White) Having a well thought-out, and tested, backup strategy is important to your disaster recovery plan. Your regular database backups and transaction log backups will allow you to recover from system failure or user error. However, one thing that even the best strategy cannot anticipate is
SQL Server Interview Questions and Answers – Part 2
(Pinalkumar Dave) What is the difference between clustered and a non-clustered index?
Journey to the Center of Fusion
(David A. Kelly) Making the pieces of your enterprise infrastructure work together wasn’t always easy. Proprietary and best-of-breed systems were cobbled together with proprietary, best-of-breed, and custom in-house middleware solutions. The result of this assembly was often a messy patchwork of app
SQL Server 2005 Waiting and Blocking Issues
(Ken Henderson) I will start this chapter on blocking by talking about waiting. Why would I start a chapter on blocking with waiting? Well, the two are very much related, and they are often treated as synonyms. Because they are so related, the SQL Server concepts and tools related to each are interm
Which XML Technologies Are Beautiful?
(Michael Day) XML is everywhere, and XML technologies are proliferating across all spheres of IT. Naturally, some XML technologies are more successful than others. However, which XML technologies are beautiful?