Skip Navigation Links

Archives


© 2017 Ambica
Version: 1.3.2


Archive for April 2008


Thursday, 17 April 2008


How to Alter the News Feed in the Visual Studio 2005 Start Page

To alter the news feed in the Visual Studio 2005 start page, do the following:

# posted by admin @ 15:51   0 comments

Tuesday, 15 April 2008


What's New in SQL Server 2008?

The main new features of SQL Server 2008 are:
  • Database and backup encryption.
  • Performance Studio (set of performance tools).
  • Integration with new .NET 3.5 features (including LINQ).
  • Large user defined types.
  • New date and time data types.
  • Ability to pass entire table to a stored procedure.
  • MERGE T-SQL command to combine insert, update and delete.
  • General performance improvements including to SSRS, SSIS and SSAS.

For more details see an excellent series of articles by Don Schlichting: Part 1, Part 2 and Part 3.


# posted by admin @ 21:25   0 comments

Tuesday, 15 April 2008


What's New in Visual Studio 2008?

Visual Studio 2008 has the following main new features:
  • Improved designer.
  • Enhanced JavaScript support (including IntelliSense).
  • Targets multiple framework versions (.NET 2.0, 3.0 and 3.5).

See http://msdn2.microsoft.com/en-us/library/bb386063.aspx#cssdesign for more details.


# posted by admin @ 21:01   0 comments

Tuesday, 15 April 2008


What's New in ASP.NET 3.5?

ASP.NET 3.5 adds the following main features on top of ASP.NET 2.0:
  • Integrated ASP.NET Ajax support.
  • New ListView control.
  • New DataPager control.
  • Language INtegrated Query (LINQ).

See http://msdn2.microsoft.com/en-us/library/s57a598e.aspx for more details.


# posted by admin @ 20:54   0 comments

Tuesday, 15 April 2008


How to Shrink SQL Server 2005 Transaction Log File (ldf)

Try one of the following two ways:

1) Via SQL Server Management Studio, left click on database name, select Tasks, Shrink and then Files. Then select file type Log and set the log file to the required size.

2) If 1) does not work then run the following (where DBName is the logical database name and DBLog is the logical log file name):

use DBName
go
dbcc shrinkfile(DBLog, 1)
backup log DBName with truncate_only
dbcc shrinkfile(DBLog, 1)

# posted by admin @ 20:16   0 comments