The Code First approach means that the object model is created in code, and then the database structure is generated from that model. Code First Migrations allows developers to make changes to the database via code, many of which can be done automatically.
SQL Server Development Tools (SSDT) - ‘Juneau’ - brings testing, debugging, version control, refactoring, dependency checking, and deployment to database development in Visual Studio. It was previewed recently along with SQL Server ‘Denali’ CTP.
SQL Server Denali includes a new type of table called FileTable, which builds on FileStream functionality. FileTable is meant for storing and managing unstructured data in SQL Server, while also making it accessible via the file system.
Microsoft posted the proposed list of SQL Server Code Name Denali upgrade paths and operating systems, and is soliciting feedback on their selections. Windows XP and 2003 are excluded, and versions of SQL Server may require service pack updates before a new Denali installation.
SQL Server Development Tools (SSDT), codenamed "Juneau", provide a new Visual Studio-based development environment for SQL Server. Some of its features are already available in Visual Studio 2010 Ultimate, but SSDT includes some key new additions such as the close integration of Database and Application Projects.
Imagine ad hock data mining queries against a single table with 1 TB of data and 1.44 billion rows coming back in roughly a second. This is the scenario Microsoft intends to support using 32-core machines and their new column-based storage engine.