September 2004 - Posts

Very nice collection of the best articles from SQLServerCentral.com can be downloaded as a an eBook now.

Thanks Veer

 

 

Posted by AnjanaRam | with no comments
Filed under:

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).

 

Posted by AnjanaRam | with no comments
Filed under:


In one of the recent expert chats by Govind, had a good discussion with him on SQL Server 2005 XML features.

He had suggested the following blogs and articles to refer. Good one's indeed.

http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5xml.asp

http://blogs.msdn.com/mfussell
http://sqljunkies.com/weblog/mrys/
http://www.25hoursaday.com/weblog/

http://www.extremeexperts.com/SQL/Yukon/ChangingXMLSchema.aspx
http://www.extremeexperts.com/SQL/Yukon/FORXMLOutput.aspx
http://www.extremeexperts.com/SQL/Yukon/FindXMLSystemObject.aspx
http://www.sswug.org/see/18881

http://msdn.microsoft.com/XML/BuildingXML/XMLandDatabase/default.aspx?pull=/library/en-us/dnsql90/html/forxml2k5.asp


http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsql90/html/sql2k5xml.asp
http://www.daveandal.net/books/8391/

http://portal.acm.org/citation.cfm?id=1007686

Posted by AnjanaRam | 2 comment(s)
Filed under:

Nice to read these during weekend...

01. [DoFactory] : http://www.dofactory.com/Patterns/Patterns.aspx

02. [CodeProject] : Illustrated GOF Patterns

03. [IPattern] : Patterns in ASP .NET from Maxim V Karpov.

04. [IPattern] : Implementation of Abstract Factory in Cryptography

 

Posted by AnjanaRam | 1 comment(s)
Filed under:

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

As someone who toils by day in the development and promotion of developer tools, I spend a great deal of time thinking about what makes software developers more productive. Understanding the answer to this question would help me professionally, to be sure, but it would also help others figure out what makes a good developer. ..More..

Posted by AnjanaRam | with no comments
More Posts