[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 ...

[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 ...
techtarget

What is Azure SQL Data Warehouse?

Azure SQL Data Warehouse is a managed Data Warehouse-as-a Service (DWaaS) offering provided by Microsoft Azure. A data warehouse is a federated repository for data collected by an enterprise's ...
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 ...
Network World

What’s better for your big data application, SQL or NoSQL?

One of the critical decisions facing companies embarking on big data projects is which database to use, and often that decision swings between SQL and NoSQL. SQL has the impressive track record, the ...