SQL Server and SBS 2003 [Windows Small Business Server 2003 Best Practices book excerpt]

Hiya – today, as part of my on-going virtual book reading (that I host as the author of this book), I am posting up the first part of Chapter 14 addressing my beloved affari with SQL Server. I love data and I hope you do to!

Chapter 14 Database Management with SQL Server 2000

Talk about a career path. Not only can you find very good (and large) texts dedicated to the SQL Server 2000 database application (a database application helps you gather, organize, and report information), but more than one Microsoft Certified Professional (MCP) has made a good living doing the SQL thing. Studying SQL Server introduces you to one of the largest bodies of knowledge and know how contained within SBS 2003 (premium edition). Given this overwhelming perspective, I’ve made the decision to keep the SQL Server discussion germane, practical, and relatively brief (and, as always, with the SPRINGERS point of view). If you so desire, I can recommend a great SQL Server book from my fellow Seattle-area author, Richard Waymire: Sams’ Teach Yourself Microsoft SQL Server 2000 in 21 Days, ISBN: 0-672-31969-1.

If I were to delve into the depths of SQL Server at the level of the aforementioned books, you and I would not only be here late into the night, but we’d be together for many days and nights forward. I can appreciate your interest in learning more about SQL Server (more than I can reasonably deliver in one chapter), so bear with me and consider this a sampler. Note that in the advanced SBS 2003 book I plan to write in mid-2004, I intend to show you more with SQL Server including importing a table from Microsoft Access.

After discussing SQL Server at a high level, this chapter has you create a database for SPRINGERS and then publish it to a Web site. Let’s get started!



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