Multimedia Library - Video

May 14, 2014
Education

Session 1: SQL Server 2014 New Features, Editions, and Licensing

Running Time: 49 This introductory session provides an overview of all of the major new features in SQL Server 2014. You’ll learn which features are included in which editions of SQL Server 2014. Finally, you’ll get a look at some of the common licensing scenarios for SQL Server 2014 with virtualization and AlwaysOn....More
May 14, 2014
Education

Session 2: Getting Started with In-Memory OLTP

Running Time: 59 minutes In this session you'll learn how the new In-Memory OLTP engine works. You’ll see how to use the new AMR (Analyze, Migrate, Report) tool to analyze your tables and stored procedures and then migrate them to the new memory-optimized format. Finally, you’ll see how to track the performance of your memory-optimized databases....More
May 14, 2014
Education

Session 3: AlwaysOn and Backup Integration with Windows Azure

Running Time: 56 minutes In this session you’ll learn about the new AlwaysOn Availability Groups and backup features in SQL Server 2014. You’ll see how to use the compression and encryption features in SQL Server 2014’s backup. Next, you’ll see how the new AlwaysOn Availability Groups can leverage on-premise replicas for high availability (HA) and Azure replicas for disaster recovery (DR)....More
Mar 20, 2014
Video

SQL Server Evolution

Michael Otey discusses the evolution of SQL Server, all the way to SQL Server 2014....More
Feb 19, 2014
video

Documenting Code

Michael Otey believes that as long as programmers still write code, there’s a need for code comments....More
Feb 14, 2014
video

Is the PC Dying?

Michael Otey opines that the PC will do just fine against the rising juggernaut of tablet and PC sales....More
Jan 6, 2014
Video
SQL Server Pro

Session 3: Handling Corruption  

Presented by: Robert Davis Running Time: 59 min Corruption can happen no matter how much care we take to prevent it. It’s inevitable, so the best course of action is to be ready for when it does happen. We will learn in the earlier sessions how to detect corruption, and now it’s time to learn what to do once you have identified it. We will explore the different types of corruption and the options for handling each type … without data loss....More
Jan 6, 2014
Video
SQL Server Pro

Session 2: Recovering Lost Data  

Presented by: Robert Davis Running Time: 51 min What do you do when someone forgets the WHERE clause on a delete statement or if a table gets accidentally dropped? We will look at ways to proactively prepare for the recovery of lost data and techniques for recovering the data after it has been lost, including techniques for mining the transaction log for the offending transactions....More
Jan 6, 2014
Video
SQL Server Pro

Session 1: Data Integrity and Recovery  

Presented by: Robert Davis Running Time: 37 min Data integrity forms the basis for building a disaster recovery strategy. We’ll take a look at the built-in mechanisms for protecting integrity and detecting corruption. We will cover standards and best practices everyone should follow and demonstrate how and why the practices will protect against and prevent data loss....More
Michael Otey
Dec 27, 2013
Video

Database Industry Trends

Michael Otey discusses hot new trends in the database industry....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×