Microsoft SQL Server: The Data and BI Platform for Today and Tomorrow

The Discussion

• 

  We had a lot of fun pulling this together.  I hope folks get some good info from it.  I wanted to point out a couple of things in my demo of the new SQL Server Developer Tools code-named "Juneau"  (SSDT) that we haven't talked about before.

  The first newsworthy item deals with the ship vehicles for SSDT which are:

  • With SQL Server Code Name "Denali" via stand-alone Visual Studio 2010 Shell or integrated with an existing Visual Studio 2010 installation.
  • On the web via Web Platform Installer (just announced)
  • With Visual Studio vNext

  I'm particularly excited about the Web PI distribution plans for SSDT.  This means you can get your hands on just our tools without having to install SQL Server or Visual Studio, which should be really popular with web developers.  You may be wondering whether the tools would be useful if you don't have SQL Server installed or a SQL Azure Database subscription. 

  That brings us to our second newsworthy item which deals with the new SQL Server Code Name "Denali" Express Local Database Runtime (LocalDb).  Here are the high points:

  • New deployment option for SQL Server Express.
  • Installs as a small shared component instead of a service.
  • Can be bundled with an app, like SSDT for example which uses it to test and debug SQL Server applications locally without having to install SQL Server.
  • Supports full Transact-SQL functionality, including Stored Procedures and Triggers.
  • Apps that use it simply open a file.  Once you do this you get SQL Server goodness when working with that file, including things like ACID transaction support.
  • Once a file is opened the app that opens it has exclusive use.  It's not intended for multi-user scenarios or to be used as a server.  If you need that stuff you should install SQL Server.

  I'll be blogging about these capabiliites in the months to come, please subscribe to feeds on my blog if you want to follow the news.

• 

  Can we do Merge Replication with this Local Database Runtime as a subscriber?

   

• 

  @rdoherty:Can we do Merge Replication with this Local Database Runtime as a subscriber?

• 

  There is some confusion about the SSDT and Denali projects.

  May be you should clarify that confusion.

   

  Regards

   

   

• 

  @ivan_:Ivan, LocalDb as far as I know LocalDb will not function as a Merge Replication subscriber.  You will need full blown express for that.

• 

  @tormenta:What confusion exactly?