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

SQL SERVER - 2008 - Design Process Decision Flow designflow

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 (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – List All Missing Identity Values of Table in Database
Next Post
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

Related Posts

7 Comments. Leave new

  • Nice and different article.

    Reply
  • Jacob Sebastian
    July 28, 2009 1:22 pm

    “SQL Server has best help available for any technology product all over the globe”

    Well Said! Search at https://blog.sqlauthority.com/search-sqlauthority/
    :-)

    Reply
  • True I agree with Pinal, SQL Server is cheap and more over inbuilt Business Intelligence features (SSAS and SSRS).

    Reply
  • Sir,

    The best articles that have a lot of usefull links.

    Thanks,
    Edwin

    Reply
  • 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”

    Reply
  • 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.

    Reply
  • 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 ??

    Reply

Leave a Reply

Menu