(Arunsp16) How to give Xml as input to Stored Procedure.
Other News
Nested Loop and Consistent Gets
(Hemant K Chitale) DBAs with a few years of experience and/or having read some material on performance tuning know that eliminating physical reads and achieving a high buffer cache hit ratio isn’t necessarily a tuning goal.
Here is a nasty problem in 11.1 environments
(John Hurley) This can occur in both an 11.1 RAC environment as well as a 11.1 single instance non clustered environment.
User not found in Identity Store : Webcenter Integration with External LDAP like OID (or AD)
(Atul Kumar) I recently integrated Oracle WebCenter 11g with Oracle Internet Directory (OID) 11g using steps here (For OID integration with WebLogic Domain click here ). I also added an OID user to WebCenter Administrator role as mentioned here
ASP.NET Internals : ‘Clearing ASP.NET Session Variables’ a in-depth look
(Abhijit Jana) ASP.NET Session is one of most common state management technique for any ASP.NET Web Application. If you want to do a quick refresh or want to know some thing more, please go ahead and read one of my article “Exploring Session in ASP.NET” published at Code Project. ASP.NET provides
Passing ASP.NET Session Variables to WCF Service
(Pravinkumar Dabade) There are multiple ways of passing the Session variables to WCF service. We will pass the session variables to WCF service using SOAP Message header.
SQL Server 2008 and 2008 R2 Integration Services – Consuming Web Services Using Script Task
(Marcin Policht) The omnipresent nature of Web-based technologies expanded the concept of distributed environments with the ability to utilize services hosted on remote servers accessible via standard Internet protocols. This capability can be easily leveraged in SQL Server 2008 R2 Integration Servi
Fearless Database and Application Performance Management from Cradle to Grave
(Laura) This Webinar is based on DBI’s IDUG DB2 Tech Conference presentation in Anaheim California. Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, will be the presenter. The session description provided to IDUG is as follows:
DB2 Performance Lessons Learned on the Treadmill, Part 2
(Scott Hayes) What can over 103 hours of running teach you about DB2 performance? A lot! Here’s Lesson #2 packed with more free advice. Read Lesson #1 first if you missed it.
Why SQL_MODE is important
(Ronald Bradford) Today was another example of where a correct SQL_MODE saved customer data from being corrupted. By default, MySQL does not enforce data integrity. It allows what is called silent truncations where the result of what you INSERT or UPDATE does not represent truth. NOTE: I see very fe