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…
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…
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…
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…
Screencast Series Announcement
We all know the saying: “A picture is worth a thousand words”. Well, what about a video? A screencast maybe? 🙂 Today I am initiating a series of screencasts dedicated to SQL Server Development and Administration – mainly for SQL Server 2008. Blogging is great of course and I will…