SQL Server as an e-commerce and line-of-business platform in SBS 2003 [Windows Small Business Server 2003 Best Practices book excerpt]

Goodness gracious! It’s Saturday and I, as author of the above title, as posting up a passage on SQL Server in the SBS 2003 realm. Thanks for attending my virtual book reading!


          XML Support. One of the more promising developments in the data­base world is that of the Extensible Markup Language (known as XML). This is the capability to parse data into a meaningful format. This is central to stuff like Office 2003 interoperability.

 Visit http://www.microsoft.com/technet for the latest updates for any Microsoft product.


                      Web and Application Hosting. SQL Server is clearly e-commerce­ready, with its ability to interact in real time with Web pages, and by collecting and providing data.

                      Distributed Partition Views. This is the ability to distribute the workload over several servers (call it another fancy term for load bal­ancing). This would be very important for an organization that has much Web activity, such as a Web retail storefront.

                      Database Administration. Not surprisingly, the database administra­tion area has improved with this release of SQL Server including auto­matic tuning and maintenance features.


Line of business

                      High Availability. Short of getting the right data in the right hands, the other SBSer obligation to SQL Server is high availability. Consider the following. You’re a king SBSer who knows infrastructure like no one else, and you’ve done a good job of advising your client or bosses on the use of a database. But without high availability, all of your cre­dence might be shipped south. SQL Server 2000 is committed, as I can attest, to high-availability. One such way it demonstrates this is by its ability to make online SQL Server-based backups (say in the middle of the day) of critical databases.

                      Application support. Ah, my favorite topic. Major line of business (LOB) software application vendors are committing to SQL Server 2000 (granted, these software vendors may have committed to Oracle first, but that’s a whole different story and book).

                      Application hosting. Interestingly, with Microsoft’s ascension to the altar of application service providers (ASPs) with its .NET (called “dot-net”) initiative, Microsoft is promoting the ASP paradigm shift in SQL Server 2000. So perhaps you can act as a line of business server to other businesses. Hmmmmmm…shall we say the possibili­ties are truly endless?


          Replication. I suspect you join me on this one, but I truly believe that having your data stored in more than one place is a business technol­ogy success factor. I shared with you the importance of replication in Chapter 6 in the context of PDA replication. SQL Server essentially has the same capability with its transactional and snapshot replication.



Harry Brelsford, CEO at smb nation www.smbnation.com

Microsoft Small Business Specialist SBSC, MBA, MCSE, MCT, MCP, CNE, CLSE, CNP

PS – did u know I host a technology conference in the New York City area each spring? Save the date for March 6-8, 2009 and watch “voice meet data” in the SMB space!

PPS – my SBS 2008 book will be out in mid-November 2008!

PPPS – my Microsoft Response Point Primer book is here NOW!


Leave a comment

Filed under Book

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s