(Aleksey Shevchenko) This article is designed to introduce you the concepts of isolation levels—the concepts that every database programmer needs to know to develop applications that allow multi-user access to the database.
Other News
Using Oracle 10g Tuning Utilities
(Alex Bubernak) Oracle is always improving life for DBAs and developers with each release of the RDBMS. 10g has many new features to help troubleshoot and tune the database. Starting with 10g, Oracle has introduced Advisors. These Advisors are part of the ADDM (Automatic Database Diagnostic Monitor)
The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?
(Simon Greener) Questions are often raised about the significance of the SDO_LB and SDO_UB fields of the SDO_DIM_ELEMENT structures that define the spatial extent of the dimensions (SDO_DIM_ARRAY) of a table/column in Oracle’s metadata tables (accessed via the USER_SDO_GEOM_METADATA and ALL_SDO_GEOM
The Easy Way to Quick Data Access
(Rafael A. Coss, Stephen A. Brodsky and Vijay Bommireddipalli) Despite the perky name, Java Database Connectivity (JDBC) programming methods can be somewhat less than stimulating. IBM is taking the drudgery out of the process with an integrated language that queries relational databases as well as J
How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult
The Microsoft SQL Server 2005 Setup program creates a local Windows group for each service that you install. The SQL Server 2005 Setup program adds the service account for each service to its respective group. For a SQL Server failover cluster installation, Windows domain groups are used in the same
APPLY Operator in SQL Server 2005
In SQL Server 2005, Microsoft introduced the APPLY operator. We have used that in some of our previous blog posts to demonstrate some code – you can read about those examples here and here. In this post, we will cover what this operator really does. The APPLY operator allows one to invoke a table va
Geek City: Detecting Overflowing Columns
(Kalen Delaney) SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum row size of 8060 bytes. I previously posted about row-overflow columns, and discussed the maximum number of such columns that you could have in a single table. You can read that po
Is Web 2.0 Calling You?
New Videos Posted: Watch: SelectViews: Noise and News in the Database World …from Yesterday: Watch: SQLonCall: How to Hire a DBA – Reading (really reading) the resume and knowing what to look for, what to *watch out* for. Watch: SelectViews: Book Looks: SQL Queries for Mere Mortals Featured Article(s) Finding the CPU/DISK IO most consuming session procedure The following procedure […]
Noise and News in the Database World
Pro-Center Video Programming for IT Professionals
Repost: Call for comments – images in the database?
New Videos Posted: Watch: SQLonCall: How to Hire a DBA – Reading (really reading) the resume and knowing what to look for, what to *watch out* for. Watch: SelectViews: Book Looks: SQL Queries for Mere Mortals …From yesterday: Watch: Food for Thought: Direct SQL Good Idea/Bad Idea? What is it?!? Find out why you should avoid direct SQL. Watch: Upcoming […]