Pro-Center Video Programming for IT Professionals
Author: SSWUG Research
Glass half-full or half-empty?
(Antoni Wolski) This is, of course, about Pessimistic and Optimistic–the two concurrency control interfaces used in database products. The idea is simple–or not, depending whether you confuse it with something else or not. Very often it is being confused with another pair of alternative choices in
Maintaining a Log of Database Changes – Part 2
(Scott Mitchell) In Part 1 of this two-part article series we looked at the motivation behind maintaining a log of database changes and compared and contrasted different techniques for persisting historical data to “history” tables. In addition to creating the table (or tables) to store the historic
Oracle’s Little-Known Multi-Table Insert
(Babette Turner-Underwood) We are assisting one of our clients with a data conversion project and have used a feature that I was surprised so few people knew about. It is the multi-table insert.
Tools for Understanding and Working Effectively With the Windows Communication Foundation
(Craig McMurtry, Marc Mercuri, Nigel Watling and Matt Winkler) To properly understand and work effectively with the Windows Communication Foundation, one should be familiar with certain facilities of the 2.0 versions of the .NET Framework and the .NET common language runtime. This chapter introduces
Enhanced Oracle Explorer in C# and .NET using Windows Forms
(Sateesh Kumar) Oracle is commonly using database as a backend for .NET applications. But, the main problem with oracle is, there is no in-built easy-to-use GUI for accessing objects in it. So the only option is to use third party tools like TOAD or PL/SQL Developer for accessing objects without wri
What’s the difference between database version and database compatibility level?
(Paul Randal) I had a question this week from someone who’d heard me say at SQL Connections (paraphrasing) “database compatibility level is mostly about query parsing” and was having trouble trying to forcibly attach a 2005 or 7.0 database to a 2000 server.
Tracing Individual Users in Connection-pooled Environments with Oracle 10g
(Terry Sutton) Many of us have been using Oracle’s Extended SQL Trace, also known as a 10046 trace, for years. An Extended SQL Trace can provide the most detailed information about exactly what an Oracle session is doing, including which SQL statements the session is executing, how many logical and
Explanation SQL SERVER Merge Join
(Pinalkumar Dave) The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and that the joined columns have matching meta-data. User cannot join a column tha
XSD Tutorial – Part 5 of 5 – Other Useful Bits
(Simon Sprott) Elements and Attributes can be grouped together using and . These groups can then be referred to elsewhere within the schema. Groups must have a unique name and be defined as children of the element. When a group is referred to, it is as if it