This tutorial shows how to improve your SQL Server database performance. Faster hardware can improve application performance to a certain point, but for truly great performing systems, there is no substitute for properly written queries and well-designed indexes.
This short tutorials explains the usage and importance of indexes in relational databases like SQL Server, Oracle or MySQL.
This video explains how you can use MongoDB as a persistent store for your domain classes in a Grails application. It presents all the important aspects of the MongoDB plugin and how it provides GORM-like behaviour.
MarkLogic is a database for unstructured information. Built from the ground up for performance and scale, it includes ACID transactions and real-time search. MarkLogic 5 offer advances in transactions, real-time search, ease of deployment and connectivity to Hadoop.
This video discusses the types of constraints you can use in SQL Server and how they can be use to maintain data integrity. SQL Server constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity. Using constraints is preferred to using DML Triggers, …
This video discusses how to integrate database constraints into your application, including how to use polymorphism in your ruby application without sacrificing database integrity.
