Featured Database Articles
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.
Discover how to do both in one SQL Server statement: Verify that a SQL Server object exists and drop the object.
Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. Read on to learn more!
The latest two versions of Oracle can throw an error when columns are set as unused and then dropped. Learn about this issue and how to address it.
Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures. Read on to see how Oracle's expand_sql_text can help solve such issues.
Learn of possible scenarios to monitor changes when replicating Oracle. Read on to discover the best course of action for moving forward!
Get a high-level understanding of how object-relational and object-oriented database management systems differ from traditional relational database management systems.
Some of the more useful features of Db2 and SQL that have been delivered as new functionality are reviewed. Read on to learn more!
Learn about several techniques which, taken together, allow you to configure your critical production data so that it is efficient (and non-disruptive) to execute analytical queries against it in real time. No need for a separate hybrid appliance, no need for a massive data warehouse. Read on....