(Amit) Oracle 11.2.0.2 has introduced new column “REASON” to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which can cause multiple child cursors).
Other News
Working on Transaction in a Web Service
(Alok Pandey) In this article, I am performing a simple transaction to describe how to work with transactions in a web service application. I am using the SqlTransaction class in a web service application using C#. The SqlTransaction class is used for satisfying the ACID property of DBMS.
Using Q Replication with DB2’s HADR
(david t) About two years ago, I posted a video showing how to use SQL Replication with HADR. Lately, I’ve gotten a bunch of requests to do something similar for Q Replication and HADR. The good news is that I don’t have to 🙂 there’s now a white paper called Using Q Replication with HADR on IBM’
High-Performance ASP.NET Caching
(Peter Vogel) There are two separate places where your application can be slowed to a crawl: In the jump from the browser to the Web server; and at the server, from the Web server to the database server (see Figure 1).
How to sort the custom template column in DataGrid and Group the records of the DataGrid based on a column value?
(SheoNarayan) In this article, we are going to learn about DataGrid in silverlight and its related properties.
SQL Server – NOLOCK Hint & READ UNCOMMITTED Isolation level on table and Query/Session level
(Paresh Prajapati) When we created a new database it will be created with default isolation level and that is “READ COMMITTED”. If some update transactions are running in with table rows under READ COMMITTED isolation level, How can we get data from table in another session while running update tran
INFORMATION_SCHEMA Optimizations: still crashing my servers
(Shlomi Noach) INFORMATION_SCHEMA Optimizations are meant to make your INFORMATION_SCHEMA queries lighter and safer.
IBM Cognos Proven Practices: Enabling Browsing for Images in IBM Cognos Express Report Studio
The goal of this document is to outline the different ways in which the WebDAV HTTP extension can be enabled for use with the “Browsing for Images” feature in IBM Cognos Express Report Studio.
Database recovery model change notification report for SQL Server
(Rajendra Gupta) The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBA
OOP Basics Coupling
SSWUG-TV With Stephen Wynkoop Is your data out of control? Find some helpful tips in this edition of SSWUG-TV where we gather insights from data management experts Thomas LaRock, Sarah Barela and Malathi Mahadevan. Watch the Show OOP Basics – Coupling Yesterday we talked about the cohesion of functions in OO Programming. Cohesion defines how specific a function is to […]