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
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.
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
- Estimate the Compression Ratio (Optional)
- Configure Data Compression
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.
- Declare Statement
- Compound Assignment Operators
- Row Constructors
- Table Valued Parameter (TVP) Lets discuss on this titles one by one
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.