Voice of the DBA

way0utwest avatar

AlwaysOn and Contained Databases in SQL Server 2012

·

way0utwest Avatar
way0utwest

This talk is mostly based on contained databases in SQL Server 2012. The first part of the talk goes over the problems with current database movement, the idea of containment, and the implementation in SQL Server 2012. There are demos that cover the user and collation scenarios. The second part of the talk goes into the basics of AlwaysOn. I talk about the architecture, the various scenarios you can have, and the advantages and drawbacks of the technologies involved. There are no demos of AlwaysOn mostly due to time.

Length: 60 minutes

Slides: downloadable after the SQL in the City 2012 tour.

Code: Demo code

VS Live San Diego

Currently Reading

Reshuffle
My current business book recommended by our CEO
The Current Family Book Club book

administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work

Comments

One response to “AlwaysOn and Contained Databases in SQL Server 2012”

  1. Creating a DDL Trigger « Voice of the DBA Avatar
    Creating a DDL Trigger « Voice of the DBA

    […] a quick example, perhaps you’re worried about new logins, as I talk about in my AlwaysOn and Contained Databases in SQL Server 2012 presentation. You want to capture when a new login is created. You can do this with a DDL trigger […]

    Like