Via this post, you can watch an interesting screencast, about Migrating to a Contained Database in SQL Server 2012 or later.
Introduction: What are Contained Databases in SQL Server?
Contained Databases is an exciting new feature, originally shipped with SQL Server 2012.
Among other, it introduces a more robust security model where you can access databases without using SQL Server Logins. You just need to use the Contained User and you can have full access to the database.
This allows you to easily migrate Contained Databases to other instances of SQL Server 2012 without having to worry about any SQL Server logins, orphaned users, etc., for the simple reason that SQL Server Logins are not necessary when using Contained Databases!
I have just prepared a screencast with live demos showing how you can migrate an existing database to a Contained Database and thus achieve portability.
I’m making the screencast available here as well as on “SQLNetHub TV“:
Wishing you Happy Holidays and a Happy New Year!!!
Watch the Screencast Here – Migrating to a Contained Database in SQL Server
Learn Essential SQL Server Administration Tips
Check my online course, titled “Essential SQL Server Administration Tips (Hands-On Guides)“.
Via this course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more.
Featured Online Courses:
- .NET Programming for Beginners: Windows Forms (C#)
- Essential SQL Server Development Tips for SQL Developers
- Boost SQL Server Database Performance with In-Memory OLTP
- Essential SQL Server Administration Tips
- SQL Server Fundamentals (SQL Database for Beginners)
- The Philosophy and Fundamentals of Computer Programming
- Introduction to SQL Server Machine Learning Services
- Introduction to Azure SQL Database
- SQL Server 2019: What’s New
- Entity Framework: Getting Started (Ultimate Beginners Guide)
- How to Import and Export Data in SQL Server
- Get Started with SQL Server in 30 Minutes
- A Guide on How to Start and Monetize a Successful Blog
Read Also:
- The TempDB System Database in SQL Server
- SQL Server 2016: TempDB Enhancements
- tempdb growth
- Introduction to SQL Server Machine Learning Services
- Essential SQL Server Administration Tips
- How to Update SQL Server Reporting Services (SSRS) 2017 or Later
- …more
Check our other related SQL Server Administration articles.
Subscribe to our newsletter and stay up to date!
Check out our latest software releases!
Check out Artemakis’s eBooks!
Rate this article:
Reference: SQLNetHub.com (https://www.sqlnethub.com)
© SQLNetHub
Artemakis Artemiou, a distinguished Senior Database and Software Architect, brings over 20 years of expertise to the IT industry. A Certified Database, Cloud, and AI professional, he earned the Microsoft Data Platform MVP title for nine consecutive years (2009-2018). As the founder of SQLNetHub and GnoelixiAI Hub, Artemakis is dedicated to sharing his knowledge and democratizing education on various fields such as: Databases, Cloud, AI, and Software Development. His commitment to simplicity and knowledge sharing defines his impactful presence in the tech community.