Performance Data Collector – Part 1
Performance Data Collector is one of the new features that’s accompanied from SQL Server 2008. If you are a DBA , you know it’s very hard to get performance data from necessary inputs. We will get the data from Perfmon (system monitor), profiler, DMV etc and correlating this data is very hard, implementing the same process or scripts across your environment is also time consuming one. To Overcome this MS has added Performance data collector feature in SQL 2008. In a Nutshell performance data collector will collect performance data (integrating all your data from your server), upload it in centralized management data warehouse (MDW) in relational format and finally allows you to see reports in graphical format.
DotNet 3.5 on Windows 7 to Install SQL Server 2008
This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks I’m seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5 is required. Windows installer 4.5 is installed and enabled by default, .Net 3.5 is included in windows features, so you can directly go there and turn on .Net 3.5, windows 7 will automatically install this. To turn on .Net 3.5 in Windows 7 just follow the steps below
Merge Drop Slipstream Setup – SQL Server 2008
In my previous article we have discussed about Basic slipstream setup, now I’m going to write a article on Merged Drop slipstream setup. In this method you will be merging the service pack with the base setup prior to the installation there by altering the source or base setup files. The merged setup package can be reused multiple times and you can burn it in DVD or copy it to a network share. However the main thing is that you need to TEST this setup package before promoting it as the core setup or live setup copy.
Basic Slipstream Setup – SQL Server 2008
In my previous article I’ve posted about slipstream and we have discussed about it’s methods. In this article I’m going to write about creating basic slipstream setup in SQL Server 2008. In this method you will be merging the service pack with the base setup at the time of installation. This method is very simple and straight forward. The merged setup package cannot be reused and it’s valid only for that particular (single) installation.
SlipStream in SQL Server 2008 Setup
Slipstream is a feature expected in earlier version of SQL server itself however from SQL Server 2008 SP1 it’s included. This is one of the most expected thing in SQL Server by DBA’s since windows operating system has the feature already and the system admin’s can easily update their setup packages. Now we have the capability to merge service pack with the base setup of SQL Server 2008. There are two methods of slipstream creation available and they are below