Imagine a MySQL query that barely fits your monitor screen such as a 7 table join. This video discusses filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations are hared, while pointing out common mistakes organizations often make.
Columnstore indexes and a new, vector-based query execution method called “batch mode”, can speed up query processing in data warehouses and data marts using SQL Server 2012 by a breathtaking 10X to 100X. This talk describes how to tune indexes, queries, and load processes to help your customers get the …
This video shows off the fault tolerance and recovery properties of FoundationDB under some nasty conditions (single & multiple machine failures, network partition, full cluster power loss) on a live demo database cluster.
Postgres has long been known as a stable database product that reliably stores your data. However, in recent years it has picked up many features, allowing it to become a much sexier database.
SQL Server has some settings which sound like a great idea but can cause major problems for performance and availability when used improperly. This video takes you on a tour of SQL Server’s most dangerous settings, from priority boost to lightweight pooling.
This talk will introduce the Spring Data MongoDB project. Spring Data MongoDB provides a feature rich library for writing MongoDB applications in Java. It builds upon the Spring Framework and as such promotes a POJO programming model with a strong emphasis on productivity.
