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
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)