Upcoming Training
Databases
7 Buzzwords About Emerging Databases and What They Mean
A lot of buzzwords are frequently thrown around with emerging databases – partitioning, sharding, replication, consistency, caching, key/value pairs, distributed. Definitions of these terms are rapidly becoming cloudy, yet understanding them is critical to designing and building a new datastore. We are going to cut through the hype surrounding emerging database terminology and explore each one in turn. We will look at what these concepts mean, how they work, and how they apply to different database solutions.
Riak Training
Riak: An Overview
This presentation will lead you through an overview of Riak: a flexible, decentralized key-value store. Riak was designed to provide a friendly HTTP/JSON interface and provide a database that’s well suited for reliable web applications.
SQL Server Training
Fundamentals of SQL Server Internals
Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Session Goals
After this session, attendees will:
- Know how to query SQL Server to gain insight into its internal state
- Understand the primary components of SQL Server and how they relate
- Apply their understanding of internals to daily queries to improve application and database performance
Indexes and Other Free Performance Boosts
The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques includes simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.
Session Goals
Attendees will:
- Gain an understanding of how indexes are structured and how this affects performance
- Understand database design patterns and how they can be applied to simplify and speed up database and application development and performance
- Increase application performance by applying this knowledge
A Dynamic World Demands Dynamic SQL
Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so!
Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.
Session Goals
- Learn how to work effectively with diverse inputs.
- Learn how to avoid common pitfalls of dynamic SQL.
- Develop an understanding of real world uses for dynamic SQL.
From Tables to Objects: Making Your Database Work With You
Abstract
A database is far more than a persistent object store for your application; it is capable of data validation en masse, aggregations, and creating different projections of data. By working with your database, rather than against it, it is possible to leverage all of the capabilities of a relational database to provide rich, high performance interaction with your application through an ORM. This presentation will discuss the finer points of building a full-featured data access layer using an ORM and the features of a relational database.
Goals
- Teach attendees about database features that make development easier – including views, sparsely populated tables, and user-defined functions and types.
- Empower the audience to solve object relational impedance mismatch using data modeling techniques and database features.
- Demonstrate how to integrate the database and object oriented software using a custom designed data access layer.
