SQL SERVER – 2008 – Design Process Decision Flow

I was recently invited by a company that is primarily using other RDBMS as their primary database for solutions. It was a different experience for me, as I am used to having pretty good SQL Server Smart crowd in my presentations, but this time there were smart people but no SQL Server experts in front of me. I was asked to elucidate the basics of SQL Server as well as how it works. Now, this was nothing short of a challenge for me; I had never done this kind of high level presentation.

I used presentation from Infrastructure Planning and Design regarding SQL Server 2008. The Infrastructure Planning and Design (IPD) guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.

What really captured the attention of audience was slide 8 of the presentation that discussed about Design Process Decision Flow. This flow is very clear and well known in SQL Server industry but it is still a good idea to go over it one more time.

The following six steps represent the most critical design elements in a well-planned SQL Server 2008 design:

  • Step 1: Determine the Project Scope
  • Step 2: Determine Which Roles Will Be Required
  • Step 3: Design the SQL Server Database Engine Infrastructure
  • Step 4: Design the SQL Server Integration Services Infrastructure
  • Step 5: Design the SQL Server Analysis Services Infrastructure
  • Step 6: Design the SQL Server Reporting Services Infrastructure

designflow SQL SERVER   2008   Design Process Decision Flow

After the presentation was over I noticed that people who were earlier claiming other RDBMS as complete database system were a little silent over SQL Server. Well, I just want to say that every solution available in industry is good but SQL Server has edge over others. SQL Server has best help available for any technology product all over the globe. If you need any help with SQL Server product, you can always send me email at pinal ‘at’ sqlauthority.com , I will get back to you as soon as possible.

You can visit Infrastructure Planning and Design and download SQL Server 2008 guide.

You can also directly download SQL Server Guide from here. Infrastructure Planning and Design is provided with permission from Microsoft Corporation.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

8 thoughts on “SQL SERVER – 2008 – Design Process Decision Flow

  1. True I agree with Pinal, SQL Server is cheap and more over inbuilt Business Intelligence features
    “SQL Server has best help available for any technology product all over the globe”


  2. We display data using 3 tables by joining them and getting the required columns in the resultset.Now we rollup/group by the result using 2-3 columns.Every now and then we keep getting requirement to groupby using new columns from some new tables other than those 3-joined tables.And for that we create a new table and insert the data in it accordingly.As the data is huge.We need some new design of these tables by which can avoid this new table creation for just getting our resultset grouped by new & diff set of columns everytime.


  3. Typically who does the IPD ? Since it does not really involve too much DBA skills but rather more of a systems administrator or someone who has a good knowledge about hardware like processor, memory or storage etc.

    Does a Junior or Intermediate DBA really gets involved in IPD ? Or is it typically a Senior or an Architect DBA plans it with hardware guys ??


  4. Pingback: SQL SERVER – Weekly Series – Memory Lane – #040 | Journey to SQL Authority with Pinal Dave

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s