Vidhya Sagar – Blog

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

Read more…

Vidhya Sagar SQL Server 2008, Troubleshoot .Net, SQL Installation, SQL Server 2008, Troubleshoot

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.

Read more…

Vidhya Sagar SQL Server 2008 slipstream, sql setup

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.

Read more…

Vidhya Sagar SQL Server 2008 setup, slipstream, sql 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

Read more…

Vidhya Sagar SQL Server 2008 setup, slipstream, sql setup

In my previous article we have seen the need for compression, goal of compression etc. In this article we are going to discuss the types of compression supported in SQL Server 2008. There are two types of compression supported and they are

• Row Level Compression and
• Page Level Compression

Lets discuss on each compression type

Read more…

Vidhya Sagar SQL Server 2008 compression