(Sunil Agarwal) The primary goal of AlwaysOn technology is to provide High Availability for Tier-1 workloads. The ability to leverage secondary replica(s) to offload reporting workloads and database/transaction log backups is useful, but only if it does not compromise High Availability.
Other News
IBM Cognos Proven Practices: Securing the IBM Cognos 10 BI Environment
A set of proven practices and guidelines to be taken into consideration when securing the IBM Cognos 10 BI environment.
Exception Handling in SQL Server
(Senthilkumar) Handling errors in SQL Server became easy with a number of different ways. SQL Server 2005 introduced the new option that helps to handle the errors effectively. Sometimes we cannot capture the errors which occurred in the end user.
Should SQL Support Regular Expressions?
Should SQL Support Regular Expressions? One of my smaller goals for this year is to become more proficient using Regular Expressions. Spending a majority of the last two decades in pure SQL allowed me to miss this gem. As I use Regular Expressions more and more, I have come to appreciate the elegance of the utility, and wonder how it […]
The Page Adapter Pattern for Testing Web Apps
Goals for the New Year 2012 is here. So, what’s going to make it any better than 2011? Or, was your 2011 so great that you don’t think it can get any better? I’m curious what you are doing to change your world this year. I’d like to collect ideas from our readers to see if I can find any […]
Determination of a leap year in PostgreSQL
(Pasha Golub) From Wikipedia: A leap year (or intercalary or bissextile year) is a year containing one extra day (or, in the case of lunisolar calendars, a month) in order to keep the calendar year synchronized with the astronomical or seasonal year.
Network effect of Semantic Web
(Zilhaz Jalal Chowdhury) In brief, Semantic Web is a network of distributed databases as oppose to existing web which is more of a network of distributed webpages. According to Robert M Metcalfe (also known as Bob Metcalfe), the value of a network is proportional to the square of the number of node
The way you write your query matters: Performance comparison between CONNECT BY and recursive subquery factoring
(Iggy Fernandez) I was asked to compare the performance of traditional CONNECT BY syntax with recursive subquery factoring (recursive common table expressions) but I only have part of the answer.
Oracle instance memory usage.
(Marc Billette) How much memory does my Oracle instance use? How much memory do my database connections use?
A Simple F# DSL to Mimic XQuery and XPath
(Faisal) System.Xml.Linq provides a nice, functional way of querying XML however with F# operator overloading we can create a nice mini DSL to have even cleaner code for XML querying.