[Database Edition 08] Understand SQL Execution Plans! Essential Knowledge for Finding the Cause of Slow SQL

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...
Visual Studio Magazine

Retrieve Multiple RecordSets in a Single Trip to the Database

I know that I keep going on about this, but the best way to speed up your application is to retrieve all the data you need on each trip to the database and make as few trips to your database as you ...
InfoWorld

What is NoSQL? Databases for a cloud-scale future

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...
techtarget

RDBMS (relational database management system)

What is an RDBMS (relational database management system)? A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update ...