(Lucas Jellema) Oracle 9i started introducing Flashback technology into the Oracle RDBMS. Flashback unlocks the UNDO data already available in the Oracle database for read-consistency, for other applications. Using Flashback queries for example, we can take a similar look in the past that Oracle tak
Other News
Database Design: Changing Attributes to Columns
(Buck Woody) In the last tutorial we completed our logical Entity Relationship Diagram (ERD) and began the process for creating a physical model from that logical diagram. We converted the entities to tables, and discussed the process of normalization as well as defining what a relationship is.
Simplify SQL Server replication
(Michelle Gutzait) Have your replication design practices gotten out of hand? You can simplify SQL Server replication management and monitoring by reducing the number of publications and subscribers in your database architecture. (R)
Optimizing Infrastructure for your SQL Server Environment
Watch the Latest SQLonCall All about your first month on the job – things to think about, things to consider, key points to address. A great show with lots of positive feedback! An all-new show will post tomorrow – catch the current show today! > Watch Here Featured Article(s) SQLCMD — Part III (Vadivel Mohanakrishnan) This is the last part […]
Columnar Databases, and Database Changes in General
Have You Watched The SQL Server Show Yet? SelectViews posted on Friday – here are the show notes; Software as a Service Issues, SQL Server Data Archive Challenge, Linking Access Tables to SQL Server. Also, BookLooks – Apress TSQL Recipes, the 60-Second SQL Server Tip of the Day and Much More. (Don’t forget the SQL Server Challenge – we’re looking […]
Windows CardSpace poised as core resource for Microsoft Identity Metasystem
(Neha Tiwari) Windows CardSpace is a new technology in the .NET Framework 3.0, which simplifies and improves the safety of shared resources and personal information on the Internet. It helps developers to build Software and Web sites which are more secured to the most commonly identity-related attac
DB2 Stored Procedures or Inline SQL?
(Konstantin Tadenev) Selecting the right technology building blocks for a new project can be a daunting task. In the world of distributed DB2 applications, the choice quite often is between inline SQL and stored procedures. This article offers a rationalized approach to this decision-making process.
Test Driving the ColdFusion 8 Beta Release
(Michael Markowski) You may have heard this before, but it’s truer now than ever – it’s a great time to be a ColdFusion developer. ColdFusion 8 is coming soon, and it will bring with it an array of new tags and features for developers who want to build sophisticated, feature-rich Web applications ea
Oracle Introduces an Integrated Approach
Oracle Communications has introduced a productized integration approach based on Oracle’s Application Integration Architecture (AIA). Claimed to be the first pre-integrated business application platform in the communications industry, it’s tailored to enable communications service providers to deliv
Configure Websphere Community Edition with Informix Dynamic Server
(Dhanashri Kudgavkar, Prasanna Alur Mathada and Amitava Chakraborty) Do you need a stable, easy to install and use application server for developing and testing J2EE applications with a robust, highly reliable, administration-free database with outstanding performance? Then WebSphere Application Ser