(azamsharp) Transferring data from one source to another is common practice in software development. This operation is preformed in many different scenarios which includes migration of the old system to the new system, backing up the data and collecting data from different publishers. ASP.NET 2.0 in
Author: SSWUG Research
Accessing Oracle Database from Microsoft.NET 2.0 using Oracle Data Provider for .NET
(John Charles Olamendy) This article is intended to show how to access the Oracle database using ADO.NET programming model and Oracle Data Provider for .NET (ODP.NET) that Oracle makes available.
Parsing in remote databases
(yas) I was trying to decrease the number of parses for a 9.2.0.7 production database when I realized that the top parsing sql was coming from another database through a database link. This sql has a parse/execute ratio of 1 meaning it is parsed every time it is called. I have searched the bug datab
Performance Impact of Frequent Logins (Actually Performance Impact of Frequently Calling SqlConnection.Open() with Connection Reset)
(Linchi Shea) Recently, a question came up regarding whether frequent logins from .NET applications–as observed with the prefmon counter SQLServer:General StatisticsLogins/sec–would have a significant performance impact. This is obvious an empirical question that is best answered with test data.
Planning to upgrade XSLT 1.0 to 2.0, Part 6: How to mix XSLT versions for a 2.0 processor
(David Marston and Joanne Tong) XSLT 1.0 anticipated future versions and made some provisions for them, but the advent of XSLT 2.0 really puts the compatibility features into practice. One feature that was greatly expanded from the original idea is the ability to set the XSLT version on every styles
Don’t overlook STATSPACK in Oracle 10g
(Bob Watkins) I had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas Oracle Users Group. One tip he gave us was just too good not to pass on, so here it is: STATSPACK is still alive and well in Oracle 10g.
Little Quirks in the VB.NET IDE
(Richard Newcombe) The VB6 IDE was jam packed with little quirks and bugs; many were fixed with the release of service packs. Almost any program, no matter how big or small, has bugs and quirks. I am going to cover a few that have been found and have personally checked. You also are going to look at
Rational Data Architect and DB2 9: The Database Explorer
(Paul Zikopoulos) In a previous series of articles, I’ve written about the tight integration of the IBM DB2 9 for Linux, UNIX, and Windows data server and its impressive integration with some of the world’s most popular integrated development environments (IDEs) such as IBM Rational Application Deve
Developing with Apache Derby — Hitting the Trifecta: Java database development with Apache Derby, Part 4
(Robert J. Brunner) Learn about SQL cursors and how you can use them to perform dynamic data modification in an Apache Derby database. You can use SQL cursors both explicitly by using the ij tool or implicitly by calling the appropriate Java methods. By mastering this functionality, you can write Ja
Is Your IT Department Ready for the Next Information Tsunami?
(Alan Schlukbier) Sometimes I really find it difficult to understand some of the attitudes of large IT shops. It seems that they never have enough time and money to do things right the first time but always have plenty of time and money to do it over and over and over again. Businesses don’t have th