Wednesday, December 12, 2018
Task Pane 
Remember Me
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 / Getting Certified - The New Microsoft Certifications Explained - Athena Pawlowski
Author: Jeff Wharton Date Posted: 7/2/2007 11:24:34 PM
Presentation 1

"Getting Certified - The New Microsoft Certifications Explained". Microsoft have recently changed the structure of their certifications. Learn how to upgrade your current certification or see how to achieve a new one.

Presenter 1 (20 mins)

Athena is the Manager of Canberra based IT company, dotNET solutions. dotNET solutions are a Microsoft Gold Certified Partner specialising in custom software development and IT training. Athena is also heavily involved in the Canberra IT community as President of the Canberra .NET User Group and recently becoming involved in the management of the Canberra Windows (Infrastructure) User Group.

Presentation 2

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

Presenter 2

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: Canberra Microsoft Office, Level 2, 44 Sydney Avenue, BARTON, ACT | Duration Pizza & drinks from 5:00 pm for a 5:30 pm start. Finish approximately 7:30pm | On: Wednesday, September 12, 2007