MySQL 5.6 was released in February 2013. It is the largest release of MySQL in history (measured by code size increase) and contains a number of very useful enhancements to replication, performance and security. What I want to talk about however is how it’s now much easier to run in …
Many expert programmers who write complex SQL without a second thought still struggle with database design. Unfortunately, many introductory topics cause eyes to glaze over when we read “transitive dependencies” and “Boyce-Codd normal form”. When you’re done with this talk, you’ll understand the basics of creating a database that won’t …
Azure DocumentDB is a fully-managed NoSQL document database service. This video demonstrates how Azure DocumentDB can integrate with your modern applications to provide a highly-scalable, queryable, and schema-free JSON-based document database solution.
You know how to design indexes, but you’re not sure how good your skills really are. In this quiz-packed session you’ll get a chance to test your SQL Server index design skills!
Nothing gets DBAs more riled up than a developer infatuated with an Object-Relational Mapper. ORMs work great at mapping from relational to objects, but can be a crutch. If you want to make your DBA (and your users happy), you’ll want to use your ORM intelligently.
This presentation discusses how to get great MySQL performance while being practical – spending time on what gives you the best return. It covers the main areas for improving MySQL performance, pointing out the most important things you need to get right for each of them.
