SQL Server Compact Edition v3.5 Management

SSCE 3.5 is not supported with SQL Server 2005 Management Studio. You need to use either the SQL Server Management Studio in SQL Server 2008 or Server Explorer in Orcas Beta 2 to query SQL Compact 3.5 databases.


Watch Out Pt 1 – Ensure you utilise appropriate data types and use explicit CAST/CONVERT in queries

I will use the title of “Watch Out” to write about things I see customers implement “incorrectly” or not according to best practices. During a delivery of the SQL Server 2005 Performance Tuning and Optimisation course one of the attendees showed me an example of a simple query and he was wondering why the query…



As it is Indian tradition, when starting any letter, official document or academic writing, the first thing we write is Shri at the top of the page. So in keeping up with my traditions my first blog is also “Shri”. Background on Shri In Hinduism, Sri (commonly Lakshmi) is the consort of Vishnu. Lakshmi or…