dbi services Blog

Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

SQL Server 2012 Express LocalDB RC0 is Available

Friday, 09 December 2011 Posted by Stephane Haby Category Technology Survey 1 comment

Since a few days, Microsoft® SQL Server® 2012 Express LocalDB Release Candidate 0 is online.

What is SQL Server 2012 Express LocalDB?

This is a dedicated version of SQL Express for developers.

By using the SQL Server Express 2012 LocalDB, developers connect directly to a SQL Server database without the requirement of an installed SQL Server instance like Developer Edition or SQL Server Express.
Programmers can easily write to SQL database files and read from SQL Server database tables without dealing with the management of a SQL Server instance on their local machine.

For more information, see here

It is very easy to install (Next > Next > Next > Finish).

install

How to download it?

Microsoft introduced such a small and streamlined installer for LocalDB that the MSI (SqlLocaLDB.MSI) has a size of 27.6 Mo (28,946,432 octets) only and it gets installed in less than a minute.

LocalDB

You can get the Installer MSI from here

A few words about SqlLocalDB utility

Developers that use SQL Server LocalDB as database for their application's storage needs can use SqlLocalDB.exe over CMD Windows.

The SqlLocalDB utility (SqlLocalDB.exe) is a simple command line tool to create and manage an instance of SQL Server Express 2012 LocalDB. The tool is installed in the Tools\Binn subfolder like the other SQL Server Express files.

sqllocaldb_utility
Type "SqlLocalDB -?" in the CMD to display help documentation in order to see available options.
localdb-command-line-tool

For more information about SqlLocalDB, see here

Have fun !

Tags: SQL Server 2012, Denali, Command lines, Microsoft

SQL Server 2012 ‘Denali’: a new panel of DMVs For a few months, I have been testing the new SQL Server 2012 (codename Denali) and I was very surprised from the DMVs of this version. Dynamic ...
SQL Server 2012 ‘Denali’: the Release Candidate is available We were looking forward to it and it has finally arrived... Since Friday, 18 November, Microsoft® SQL Server® 2012 Release Candidate 0 is online. ...
Forefront Endpoint Protection (FEP) 2010 and database policies I have seen at a customer that SQL Server's policy doesn't follow Microsoft's recommendations about antivirus and databases (kb 309422), such as exclu...
SQL Server 2012: How to create a Server Role? Recently, during one of my missions, a client asked me to give him access rights to the SQL Server logs from SSMS to his application managers. As you ...
SQL Server 2012: New Licensing Since the commercial version of SQL Server 2012 is due to be released in April, a little posting about the changed licensing costs seems appropriate....

About the author

Stephane Haby

Stéphane Haby is Consultant at dbi services.

He has more than ten years of experience in Microsoft solutions.

He is specialized in SQL Server technologies (installation, best practices, performance analysis, etc.) and Microsoft Business Intelligence solutions.

Stéphane Haby is Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) : SQL Server 2008, Implementation and Maintenance.

Futhermore, he has also many years of .NET development experience in the banking sector and other industries.

http://www.dbi-services.com