|
|
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?
|
|
|
# posted by admin @ 21:01
0 comments
|
|
|
Tuesday, 15 April 2008
|
What's New in ASP.NET 3.5?
|
|
|
# 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
|