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

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

Variable and Assignment enhancements – SQL Server 2008

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 Read more »
VN:F [1.9.17_1161]
Rating: 4.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

Activity Monitor – SSMS 2008

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.

Read more »

VN:F [1.9.17_1161]
Rating: 3.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: +1 (from 1 vote)

Installing SQL Server 2008 Clustering on Windows Server 2008

In this podcast we are going to install SQL Server 2008 Clustering on Windows server 2008. I’ve already made my both the nodes clustered with Windows server 2008 and the details are below.

Below are the list of SQL Server 2008 editions supporting clustering.

  • SQL Server 2008 Enterprise Edition (16-node failover clustering)
  • SQL Server 2008 Standard Edition (2-node failover clustering)
  • SQL Server 2008 Developer Edition

Read more »

VN:F [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

SQL Server 2008 Service Pack 1 (SP1) Released

Today Microsoft has released the final version of Service pack 1 for SQL Server 2008. You can download it from the  link below. Some of the new features are included in SQL Server 2008 service pack 1.

  • Slipstreaming is an installation method that integrates the base installation files for a program with its service packs and enables them to be installed in a single step. You can slipstream a SQL Server 2008 update and the original installation media so that original media and the update are installed at the same time. The update setup documentation available from the Download Center has the most recent description of the slipstream process. The update setup documentation is also available at MSDN.
  • You can uninstall SQL Server 2008 cumulative updates or service packs from Programs and Features in Control Panel. For more information, see “Overview of SQL Server Servicing Installation” in the update help file.
  • SQL Server 2008 Service Pack 1 provides a ClickOnce version of Report Builder 2.0. Report Builder is available for use in Reporting Services (SSRS) installed in native or SharePoint integrated mode. If SSRS is installed in SharePoint integrated mode, you need to install the add-in, Microsoft SQL Server 2008 Report Builder 2.0 ClickOnce for SharePoint, to make Report Builder 2.0 ClickOnce available from a SharePoint site. For more information, see the Report Builder 2.0 ClickOnce for SharePoint Readme.

Read more »

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)