Tag Archives: sql server 2008

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

Continue reading DotNet 3.5 on Windows 7 to Install SQL Server 2008

Basic Slipstream Setup

In my previous article Ive posted about slipstream and we have discussed about its methods. In this article Im 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 its valid only for that particular (single) installation.

Continue reading Basic Slipstream Setup

Variable and Assignment enhancements

Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers.

Activity Monitor

Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU time etc, this really helps us to know the status of the server immediately.

Continue reading Activity Monitor