Screencast: Migrating to a Contained Database in SQL Server 2012

Contained Databases is an exciting new feature 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 … Read more…

Screencast: Object Dependencies in SQL Server 2008

SQL Server 2008 introduces among other new features and enhancements for accurately tracking Object Dependencies. This is very useful especially in cases where the user wishes to programmatically modify database objects having dependencies and therefore, he/she needs to resolve these dependencies before being able to proceed with the database object modification. For efficiently tracking dependencies … Read more…

Screencast: Using Inheritance in the ADO .NET Entity Framework

Welcome to another screencast dedicated to SQL Server 2008 Programmability! This screencast again features the ADO .NET Entity Framework. The screencast demonstrates how the developer can create an entity data model in Visual Studio 2008, and goes one step further, thus demonstrating a simple way of using inheritance in the entity data model.   Check … Read more…

Screencast: How to Create an Entity Data Model

Welcome to my first screencast dedicate to SQL Server 2008 Programmability! This screencast features the ADO .NET Entity Framework; a new feature of Microsoft .NET Framework 3.5 providing the developer with fast, robust and scalable data access. SQL Server 2008 fully supports the ADO .NET Entity Framework, allowing developers to effortlessly create entity data models … Read more…