BT
rss

Code First Migrations Updates Data Structure From Code

by Jenni Konrad on  Dec 02, 2011 2

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.

Visual Studio Gets Better SQL Server Tooling – ‘Juneau’

by Roopesh Shenoy on  Jul 30, 2011

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’s FileTable: Turn SQL Tables into Folders

by Jenni Konrad on  Jul 28, 2011

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.

SQL Server Denali: Microsoft Wants Your Feedback on Upgrade Paths and Supported Operating Systems

by Jenni Konrad on  Jun 16, 2011

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.

Visual Studio Database Development with SQL Server "Juneau"

by Jenni Konrad on  Jun 09, 2011 3

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.

Column-based Storage in SQL Server 2011

by Jonathan Allen on  Mar 07, 2011 4

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.

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT