You’ve only just begun: SQL, SBS 2003 and end of book! [Windows Small Business Server 2003 Best Practices book excerpt]

Hey loyal readers. I am the author for the Windows Small Business Server 2003 Best Practices book and each day I host a virtual book reading. It’s a lot of fun and today is very special as I post up the final passage fomr this “purple book.” Over the past six months, you have joined me in our SBS book club, by any other name, for these daily missives. I intended to post up until the SBS 2008 product shipped, and indeed that day has arrived. Yesterday, November 12th, was the Windows Essential Server Solutions (WESS) launch for Small Business Server 2008. And today is “numerically” the end of the SBS 2003 book. So the timing was perfecto.

Here you go – some final thoughts on SQL Server in a SBS 2003 environment!

Next Steps – You’ve Only Just Begun

So you’re still interested in learning more about SQL Server? That’s great! It’s a huge area where you can always grow; it has no upper knowledge limit. Aside from the advanced SQL Server books mentioned earlier today, there are several key areas to master as you continue in your quest to learn and use SQL servers. These study topics are:

                      Learn SQL basics including these SQL commands: SELECT, UPDATE, INSERT, and DELETE.

                      Learn the rules: how to define primary keys, secondary keys, and in­dexes, and how to normalize a database.

                      Learn the power of stored procedures. Create a stored procedure of your own.


 Visit for the latest updates for any Microsoft product.


                      Learn, inside and out, the tools that ship with SQL Server 2000 includ­ing SQL Server Enterprise Manager, SQL Query Analyzer, and Books Online (to name my three favorite tools).

                      Learn and master client-side connectivity, especially ODBC.

                      Learn how third-party applications use SQL Server 2000. Such third-party applications include Great Plains, the accounting application.

                      Learn to connect sophisticated Web pages to SQL Server 2000 for online transactions (far more advanced than you learned in the last section). This is, of course, a very popular and in-demand skill set. It is the basis of many electronic commerce implementations.

                      Learn to migrate data from Access to SQL Server 2000.



Today you worked with SQL Server 2000, the powerful database included with SBS 2003 (premium edition). I hope that the exercise in creating a database for SPRINGERS went a long way toward debunking the myth that databases are hard to use. If you followed the steps in this chapter, you not only created a database, but used it as well. That said, I emphasize the following point again: On an SBS network, your interaction with SQL Sever 2000 will likely be limited to installed third-party applications that use SQL Server 2000 as a database engine. If for some reason you decide to program SQL Server directly, as you did in creating the SSLDOG database table for SPRINGERS, remember to keep your databases simple and friendly, very much like you did today. That’s my $0.25 USD advice to you. Good day.



Harry Brelsford, CEO at smb nation

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: Logo

You are commenting using your 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