1 / 18

SQL Server Express

SQL Server Express. Scott Baldwin Associate Consultant - Readify Prerequisites for presentation: I assume you know: 1) .Net Development 2) Database Experience Level: Intermediate. Sydney 2005 November 30. SQL Server Express – Session Overview. What is SQL Server Express (SSE)

kendall
Download Presentation

SQL Server Express

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server Express Scott Baldwin Associate Consultant - Readify Prerequisites for presentation: I assume you know: 1) .Net Development 2) Database ExperienceLevel: Intermediate Sydney 2005 November 30

  2. SQL Server Express – Session Overview • What is SQL Server Express (SSE) • Feature Overview • Comparison with MSDE 2000 • Visual Studio Integration • XCopy & RANU • Demo • Who Will Use It? • Usage Scenarios • Resources

  3. What is SQL Express? • Based on SQL Server 2005 Database Engine • Complete SQL Server Programming Model • Transact-SQL • Stored Procedures • Views • Triggers • Cursors • New for SQL Sever 2005 • CLR Integration • XML • Enhanced Security

  4. What is SQL Express? Cont… • Replacement for MSDE 2000 • Freely Downloadable & Redistributable • Integrated setup and deployment • Tight Visual Studio Integration • Native and Managed Data Access • Automated patching and servicing • Some restrictions placed on database size, performance and feature set.

  5. Feature Comparison

  6. Feature Comparison cont…

  7. Other Restrictions • Clustering • Mirroring – Log Shipping • Database Snapshot • Online Operations (Online Index Rebuilds) • New backup-restore features • Plan Guides • SQL Agent • Analysis Services • SSIS (SQL Server Integration Services)

  8. Other Features • Other SQL Server Features • Service Broker (to/from another SKU of SQL Server) • SQL Express only • User Instances (RANU / XCopy Deployment) • Post RTM (Autumn 2006) • SQL Server Management Studio Express Edition • Reporting Services • Full Text Search

  9. SQL Server Express Deployment • No Merge Modules • MSDE was hard to service if distributed as a Merge Module (Slammer). • Issues with programs installing MSDE multiple times on same machine • MSI installer only, with both interactive/silent modes • Much better maintenance story • Highly customisable

  10. XCopy Deployment • XCopy Deployment • Treat the database as a file • Use AttachDBFileName and |DataDirectory| • Simplifies deployment • Must be an Admin on the instance to attach • Lose some functionality (eg Replication)

  11. User Instances • RANU • Run As Normal User • Designed for JET scenarios • Better isolation and security • Works for LUA User

  12. User App User App LUA User SQL Server Parent Instance User Instance User Instances cont… • How it works Connect to Parent Instance w 1 . / UserInstance = TRUE 3 . ADO . NET redirects connection to UI 2 . Parent Instance spawns User Instance

  13. User Instances Cont… • Limitations • Supports only Windows Authentication • Listens only on local named pipes • Replication is not possible • Administration • Only members of the Administrators group, and the spawning user can connect • Exposed through sys.dm_os_child_instances

  14. Demonstration • Demo of RANU and XCopy

  15. Target Users • Hobbyists & non-professional • Technology Professional • ISVs – Shrink wrapped software market

  16. Usage Scenarios • Software vendor creating different SKU’s can implement lowest SKU with SQL Express. • Trial products. • Shrink wrapped single user software. • Smart Client (sometimes connected scenarios)

  17. Resources • http://lab.msdn.microsoft.com/express/sql/ • http://blogs.msdn.com/sqlexpress/ • http://www.sqlserver.org.au/ • http://www.sqldownunder.com/ • sqldownunder@listserver.readify.net • http://sjbdeveloper.blogspot.com

  18. Discussion • Questions

More Related