Categories
Troubleshooting

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

Categories
General

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.

Categories
DBA

Configuring Data Compression

In this article we are going to configure Data compression in SQL Server 2008. Configuring data compression is very easy with just an couple of steps. The steps are below

  1. Estimate the Compression Ratio (Optional)
  2. Configure Data Compression
Categories
General

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.

Categories
DBA

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.