SQL Locking and Transactions
This video describes how SQL locking and transactions operate in concept, and in practice (the two are not the same).
Introduction to Hadoop
Enterprises today collect and generate more data than ever before. Relational and data warehouse products excel at OLAP and OLTP workloads over structured data. The open-source project administered by the Apache Software Foundation known as Hadoop, is designed to solve a different problem: the fast, reliable analysis of both unstructured …
Creating Primary Keys in SQL Server
In SQL Server, the Referential Integrity is governed by the fact that there is a defined primary key that will only ever allow unique values. That primary key is used to establish relationships with other tables. This article shows you how to create primary keys in SQL Server. The concept …
PostgreSQL 9.1 Grand Tour
What is new in the just released PostgreSQL 9.1? PostgreSQL core team member Josh Berkus gives you a whistle-stop tour of the top features of the new release, including live demos of several of them. Included: synchronous replication, new replication tools, unlogged tables, SSI, KNN-GiST, per-column collations and extensions.
MySQL Upgrade Best Practices
As MySQL powers business critical applications it is very important to be able to upgrade MySQL server with as low risk as possible. This presentation shows the best practices used by Percona to perform hundreds of MySQL upgrade projects as well as learn how to use Percona Toolkit to assist …
CouchDB with Node.js
The CouchDB document store is well suited to many CRUD style websites. However a particularly interesting aspect of Couch is the _changes feed which streams updates about what is going on inside the database. By using this feed with Node.js, Mikeal Rodgers shows how it’s possible to push data to …