Friday, 22 September 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
SQL Server 2005 Compact Edition: A DBA's Primer - Jeff Wharton
Author: Jeff Wharton Date Posted: 24/07/2007 1:18:52 PM
Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is the rebranding of Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile 3.0) without the desktop restriction.

SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops. Just as with SQL Server Mobile, SQL Server Compact is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005 for developing desktop and mobile applications.

In this session Jeff will cover:

- What is SQL Server 2005 Compact Edition (SSCE)?
- Obtaining SSCE
- SSCE Deployment Architecture
- Managing SSCE Databases
- Verifying and Repairing SSCE Databases
- Compacting and Shrinking SSCE Databases
- Locking, Concurrency and Isolations
- Synchronisation
- Securing the SSCE Database
- Performance Tuning
- Resources

Meet the Presenter

Jeff Wharton is WARDY IT Solutions Chief Solutions Architect and has been working in the Information Technology industry since 1992 spending 3 years in the Integration and Configuration of PC’s and networks and 12 years developing/enhancing/upgrading applications using a wide range of Technologies. Jeff is also experienced in System Administration, Project Management, Configuration Management, Application Package and Deployment, Team Leadership and Training Course Development and Delivery. Jeff holds a Masters Degree in Systems Development (.NET Stream) as well as various Microsoft Certifications including MCPD: Enterprise Application Development, MCITP: Database Developer, MCTS: Microsoft Windows Mobile Application Development & Configuration and is also a Microsoft Certified Trainer. Jeff is also in the final stages of completing a Master of Database Design and Management (SQL Server 2005) degree at Charles Sturt University. In his spare time Jeff runs the Canberra SQL Server User Group, Mentors "ITI555 - Operating System Essentials" and “ITI556 – Supporting a Network Infrastructure” for I.T. Masters, and works on his blog.

Venue: Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street | Duration Catering from 5:30PM for a 6:00PM Start | On: Thursday, 27 September 2007