Archives / 2004 / September
  • Notes : SQL Server Express

    Basically an enhanced version of Microsoft Desktop Engine (MSDE), a light weight database engine from Microsoft which can serve any small scale application. The architecture of MSDE has been totally revamped to enable any developer to install and use it as they would do with any Jet databases or MS access with any problems.

    If you look at the feature set of SQLSX, you can find lot of goodies for development and productivity enhancements.

    Database engine

    •  Based on the core SQL Server 2005 Database Engine

    •  Supports the complete SQL Server programming model including T-SQL and CLR integration

    • Standard SQL Server objects such as stored procedures, views, triggers, and cursors

    XML Support

    ·         Native XML data type

    ·         XQuery and XML Schema support

    Scalability, Security and Performance

    ·         Supports 1 CPU, but can be installed on a server with any number of processors

    ·         Maximum 1 GB addressable RAM

    ·         Maximum 4 GB database size

    ·         Secure By Default

    ·         Implementation of Code access security (Safe, external and Unsafe)

    ·         Windows Authentication support

    and from Securing your SQL Server Express

    ·                 A replacement for JET databases. That is, a DBMS that can be taken over by an IT department if needed, one that meets HIPA security requirements, one that uses all of the power of SQL Server to protect data and referential security and do all of this regardless of how the user mistreats it. (HIPPA or HIPAA (often shortened to HIPA) refers to federal legislation that requires robust security and access protections be placed on databases storing personal healthcare information.)

    ·                 A DBMS that can scale from a single user to several dozen users without upgrading to SQL Server Standard edition—and without having to worry about a governor degrading performance when it's needed most.

    ·                 A DBMS that can work as easily on a small Web site as well as in a client/server configuration.

    ·                 A DBMS engine that can be easily installed and updated in place when service packs are made available. This means setup routines that are easily integrated into your application's deployment scripts.

    ·                 A DBMS that can be accessed by simply pointing to a DBMS file installed with, or passed to, an application. Because SQL Server Express is designed to permit databases to be attached on the fly, it's easier than ever to use "loose" SQL Server MDF database files and deploy them with your application. This makes it far easier to deploy a stand-alone SQL Server Express database .MDF file, as could be done with JET databases.

    ·                 A standard way to refer to a shared instance of SQL Server. When SSE is installed, by default it's installed with the same instance name: SQLEXPRESS. This means your application's connection string can more easily target SQL Server Express whether it's installed on the local system or on the local area network, assuming the application setup routines take advantage of this feature. I'll talk about instance issues a little later.

    Finally Top 10 cool things about SQL Server Express 2005 Edition 

    1. Integrated common language runtime (CLR) support. Stored procedures and functions can be written using your favorite programming language.
    2. Native XML support.
    3. XCopy support for moving databases from one location to another.
    4. Robust and reliable installation using either graphical user interface (GUI) or silent modes.
    5. Automated servicing and patching.
    6. Deep integration with Visual Studio to provide access to rich data controls like the DataGridView, DataNavigator, and DataConnector.
    7. Support for databases up to 4GB.
    8. Support for disconnected systems with SQL Server Service Broker and Replication.
    9. SQL Server Express Manager, a new, easy-to-use database management and query analysis tool (first preview available August 2004).
    10. Easier deployment via Visual Studio ClickOnce (available in Beta 3).



  • What Makes Developers Productive?

    Found this interesting one to share with fellow developers...

    Identifying the skill and productivity of development team members is harder than it looks
    by Peter Varhol