Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

Home
Home This is where you can find all the blog posts throughout the site.
Categories
Categories Displays a list of categories from this blog.
Tags
Tags Displays a list of tags that has been used in the blog.
Bloggers
Bloggers Search for your favorite blogger from this site.

Posted by Stephane Haby on Friday, 09 December 2011 in Technology Survey

Hits: 2248
1 Comment
Subscribe to this entry
Print
PDF

SQL Server 2012 Express LocalDB RC0 is Available

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 !

Tagged in: Command lines Denali Microsoft SQL Server 2012

Rate this blog entry:

Oracle SQL Developer & SQL Data Modeler on Ubuntu
Forefront Endpoint Protection (FEP) 2010 and datab...

Stéph@TechEd 2012: Episode 3 – SQL, SQL & SQL - Technology Survey Jun 27
SQL Server 2012 ‘Denali’: a new panel of DMVs - Database Administration & Monitoring Nov 17
SQL Server 2012 ‘Denali’: the Release Candidate is available - Technology Survey Nov 21
Forefront Endpoint Protection (FEP) 2010 and database policies - Database Administration & Monitoring Jan 01
SQL Server 2012: How to create a Server Role? - Database Administration & Monitoring Mar 15

Stephane Haby

Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.

http://www.dbi-services.com