Microsoft SQL Server 2012 has many new features and enhancements. With a focus on manageability,this session video tours new features including Contained Databases,Distributed Replay Utility,User Defined Roles,SQL Management Studio enhancements,and PowerShell. The session is demo-intensive and provides you clear guidance and strategy in the upcoming release of SQL Server.
This session discusses an open source OLAP environment using Firebird as the relational backend. Answering analytical and/or business questions based on existing business data becomes more and more important for management, key users etc. Established data warehousing (DWH) and OLAP techniques allow just-in-time multi-dimensional ad-hoc queries on a set of …
Why are customers choosing to replace or augment their legacy RDBMS with NoSQL big data platforms? This video provides the answer. Billy Bosworth, CEO of DataStax, examines how to assess where NoSQL is right for your business, what factors to consider when selecting a big data platform, how to start …
As operational database schemas become complex, users resort to denormalization to handle performance issues. This includes a range of techniques from materialized views to using MySQL as a key-value store for blobs containing full objects.
As MySQL powers more and more business critical applications it is very important to be able to upgrade MySQL server with as low risk as possible. In this presentation we will go into details of best practices used by Percona to perform hundreds of MySQL upgrade projects as well as …
This vides describes and discusses MongoDB’s data format (BSON), the insert path, the query optimizer, auto-sharding, replication and more. The talk will interest to developers interested in MongoDB and looking to learn more about what’s going on “”under the hood””, as well as anyone interested in distributed systems and the …
