The Flexible Workspace
Microsoft SQL Server: The Data and BI Platform for Today and Tomorrow
Download this episode
Description
Foundational Sessions bridge the general topics outlined in the keynote address and the in-depth coverage in breakout sessions by sharing the company’s vision,strategy and roadmap for particular products and technologies,and are delivered by Microsoft senior executives. Attend this session for a demo-intensive visual tour through the new SQL Server and discover what’s possible for end users,developers and IT alike to help organizations unlock the value of exploding data volumes,create business solutions fast,and deliver mission critical capabilities at low TCO in their enterprise and in the cloud.
Share
Format
Available formats for this video:
Actual format may change based on video formats available and browser capability.
Event Homepage
Tech·Ed North America 2011More episodes in this series
A Lap around Microsoft Silverlight 5
Related episodes
Cloud-Ready Data Services
Cloud-Ready Data Services
The New World of Data: SQL Server and Hybrid IT
The Discussion
-
rdoherty 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.
-
ivan_ Can we do Merge Replication with this Local Database Runtime as a subscriber?
-
ivan_ @rdoherty:Can we do Merge Replication with this Local Database Runtime as a subscriber?
-
tormenta There is some confusion about the SSDT and Denali projects.
May be you should clarify that confusion.
Regards
-
rdoherty @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.
-
rdoherty @tormenta:What confusion exactly?
Comments closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.