(Mahendra) The previous post talks about one issue occured during configuration of DB auditing in Oracle Access Manager. This post also talks about another issue of same feature.
Other News
Massive Deletes Vs Truncating Partitions
(Asif Momen) This is not a revolutionary post, everything I discuss here has been discussed numerous times. Massive deletes are nothing new in a DBA’s life.
DB2 10 New Catalog Tables
(Troy Coleman) After I wrote about the changes with existing catalog tables, a reader asked me for a list of new catalog tables.
One day DB2 pureScale workshops in Ehningen (Stuttgart) and Paris coming up
(Henrik Loeser) Workshops covering DB2 pureScale are coming up on March 17th in Ehningen (Stuttgart area, Germany) and in Paris (France) on May 6th.
Geek City: What gets logged for index rebuild operations?
(Kalen Delaney) This blog post was inspired by a question from a future student. Someone who was already booked for my SQL Server Internals class in June asked for some information on a current problem he was having with transaction log writes causing excessive wait times during index rebuild operat
SQL Server Service Broker – External Activation
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and SQL Server 2008 R2) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applicat
Using Dynamic SQL in Stored Procedures
(Bill Graziano) Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional se
Creating XML from Relational Databases
(DaveMcG) Sometimes following an example someone else created is a good way to get a quick start on a project. The downside is you might miss a better, more efficient solution.
Output Caching Actions Gotcha in ASP.NET MVC 3
(Malcolm Sheridan) This is a gotcha I had to write about. Everyone knows the benefits of caching data when working with the web. Be it file caching, donut caching or SQL Server caching, the benefits are obvious; retrieving data from memory instead of a data store means a more performance.
Is 2011 The Year for Semantic Technology?
(Luca Scagliarini) Consider the following facts: –79 percent of American adults use the Internet, according to a May 2010 survey. –38 percent of Internet users log onto an online networking site like Facebook or LinkedIn each day. –8 percent of Americans on the Internet use Twitter. –28