Implementing SQL Express (My TechEd 2006 Session)

Day/Time: Wednesday, June 14 3:45 PM - 5:00 PM Room: 157 ABC
Speaker(s): William Vaughn
SQL Express is the version of SQL Server 2005 designed to replace MSDE. In some scenarios, SQL Express is a viable replacement for the JET/Access database engine - it's safer and more reliable. Because SQL Express does not behave like JET in most respects, it can be a challenge for JET developers to understand how to control SQL Express and leverage its power from their applications. This talk discusses the differences in SQL Express, MSDE, JET and the other SQL Server Editions - including the just-announced SQL Server Everywhere edition. See how SQL Server Everywhere (which builds on the proven codebase of SQL Mobile) fills a need for a lightweight DBMS where SQL Express might be overkill. The session includes an overview of the new SQL Server Management Studio Express toolset and code used to manage SQL Express (or any instance of SQL Server) including discovery, starting, stopping and pausing instances. We also demonstrate how Visual Studio leverages SQL Server Express functionality into the IDE and permits developers to create, configure and deploy SQL Server Express databases with their applications.
Track(s): Database Development and Administration
Session Type(s): Breakout Session
Session Level(s): 200