Indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance. The rules are explained using a simple …
The last decade or so has seen exciting change in the world of databases, as new approaches have risen up to challenge the relational model. This presentation will look at the reasons why companies choose NoSQL databases, how they differ from the familiar RDBMS, and the categories of NoSQL databases.
This screencast will take you thought the in’s and out’s of the SQL SELECT statement, including using the FROM, WHERE and ORDER BY clauses. Additional topics such as the TOP and DISTINCT keywords, column aliasing with AS and date/time functions are also covered.
Learn how to convert your database mirroring and log shipping configurations to SQL Server 2012 AlwaysOn Availability groups, providing database availability and maximizing your investments by allowing read-only access to database replicas.
In order to meet the challenges of Big Data, you must rethink data systems from the ground up. You will discover that some of the most basic ways people manage data in traditional systems like the relational database management system (RDBMS) is too complex for Big Data systems. The simpler, …
Jim Erickson interviews Chris Adamson, data warehouse specialist & consultant, about Dimensional Models and Big Data Challenges.
