SQL Server story continues – the “server-side” in an SBS 2003 scenario [Windows Small Business Server 2003 Best Practices]

hiya bozy and grrls!

I am the author of the Windows Small Business Server 2003 Best Practices book and I like to post up a passage a day as a daily virtual book reading! TGIF!

The Server Side

On the SBS server machine, the data resides not only in tables, but also is manipulated by the SQL Server engine. These SQL Server server-side capabilities include three functional areas: data warehousing, e-commerce, and line of business.

Data Warehousing

Microsoft has positioned SQL Server to act as a store of data for the organization. This is accomplished in several ways:

          Comprehensive Analysis Services. This speaks to SQL Server 2000’s business analysis capabilities via online analytical processing (OLAP) and data mining.

BEST PRACTICE: The analysis services and data mining capabilities in SQL Server 2000 are damn cool. It was the focus of an afternoon in the four day GTM hands on lab in the spring of 2003. And at the ITEC trade show in Portland in December 2003, an attendee at a CRM presentation asked about using the data that CRM gathers. He wanted to know how to use that data to make better forecasts. Since Microsoft CRM is using SQL Server 2000, the answer was to data mine the CRM data!

                      Data Transformation Services. These are the routines that automate the extraction and transformation of business data from multiple sources.

                      Web-enabled. Not only can you publish your information to a Web page, but you can analyze data accessible from remote Web sites. You will publish a Web page at the end of this chapter with SPRINGERS data.

                      Meta-Data Services. The idea here is that SQL Server supports the sharing of data between different tools and environments.

                      Indexed Views. Microsoft is claiming that performance enhancements related to accessing your data can be gained by indexed views.

                      Microsoft Office Integration. In Microsoft Excel, you can use the pivot table capabilities to manipulate SQL Server-based data.

                      English Query. Here’s something many SBSers, who don’t claim to be SQL gurus, will like. In SQL Server 2000, there is greater support for posing queries in English versus SQL speak (or as Microsoft calls it, “Multi-Dimensional Expressions” – MDX for short).



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