In my years of software development, I’ve found that there are a few topics that seem to elude many programmers. Some of the topics are pretty complex (compiler design comes to mind); others are just plain foreign compared to traditional programming (Regular Expressions comes to mind). Others just s
Other News
A surfeit of caches
(Rex Baldazo) A cache is useful in theory. By storing a temporary copy of some page or image, the servers can deliver it faster to the client computer. But if you’ve ever been stuck trying to debug a problem related to caches, you quickly realize that computer science types have gone overboard and p
Oracle 11g: Extended Statistics
(Greg Rahn) In the Real-World Performance Roundtable, Part 2: The Optimizer, Schema Statistics, SQL Tuning at Oracle OpenWorld 2006, I worked an example of how the optimizer can have difficulty estimating the correct cardinality when there is data correlation. (The Zodiac example can be found on pag
Oracle BI EE 10.1.3.3/2 – IQY and Auto Generation of GO URL
(Venkatakrishnan J) I would like to write today about two interesting but un-noticed features of Oracle BI EE. The first one is called as IQY or intelligent Web Query which will generate an export of the data in Excel that can be refreshed from within Excel. Of course, now that we have BI EE Office
Write REST services
(J. Jeffrey Hanson) This tutorial discusses the concepts of REST and the Atom Publishing Protocol (APP) and shows how they apply to services. It also shows how to use Java technology to implement REST/APP-based services. (R)
On managing a .NET Framework 1.x migration
(George Lawton) Managed code environments like the .NET Framework bring important capabilities to application development such as policy enforcement and separation of the different aspects of business software development. (R)
Understanding State Management
You need to maintain state-level and page-level information of an ASP.NET Web application because Web pages and ASP.NET Framework use HTTP protocol to communicate between a Web browser and a Web server. HTTP is a stateless protocol. Therefore it can not automatically indicate whether the sequential
Optimizing the Silverlight Install Experience
(Scott Guthrie) One of the things that is important to think about when you start using Silverlight in your sites/applications is to make sure you handle the “what if the end user doesn’t have Silverlight installed yet?” scenario. Ideally you want to make sure that the installation experience for S
Make sure your .NET applications perform
(James Moore) In today’s world of high processor speeds, and vast amounts of available memory, many programmers seem to ignore the limitations on these resources in applications.
Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: ‘ERROR Selected writer ‘Microsoft Writer (Service State)’ is in failed state’
Consider the following scenario. In Microsoft SQL Server 2005, you create a snapshot backup of many databases at the same time. To do this, you use the Volume Shadow Copy Service (VSS), or you use the Virtual Backup Device Interface (VDI). In this scenario, the snapshot backup operation fails. Addit
