Certification link - Microsoft

New SQL Server 2008 Exam are all set under MCTS and MCITP.

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
MCTS: SQL Server 2008, Database Development
MCTS: SQL Server 2008, Implementation and Maintenance

Please find the link :http://www.microsoft.com/learning/mcp/mcts/default.mspx

World of Business Intelligence - >>>>>

Hi all ,

Microsoft Business Intelligence Products Link:

http://www.microsoft.com/bi/products/default.aspx

1] Microsoft Office performance Point Server 2007 – BI Tool.

2] Microsoft Office SharePoint Server 2007 – Supports lot BI features .

3]SQL Server 2005/2008 – Has complete got BI Suite.


Thanks & Regards,
Naveen Mukkasa

Shrinking Transcation Log FIle - SQL Server

Different ways to Shrink file
1]
USE Database Name
GO
DBCC SHRINKFILE(logfile name, 1)
BACKUP LOG databasename WITH TRUNCATE_ONLY
DBCC SHRINKFILE(logfile_name, 1)

2]
sp_dboption [AdventureWorks], 'trunc. log on chkpt.', 'true'
dbcc shrinkfile ([AdventureWorks_Log])

3] Eliminate the log file completely
Sometimes we just do not need the big log file. For example, I have 40GB log file. I am sure I do not need this log file and want to get rid of it completely to free up the hard drive space. The logic is
a. Detach the database
b. Rename the log file
c. Attach the database without the log file
d. Delete the log file
Let’s say, the database name is testDev. In the SQL Server Management Studio,
Highlight the database-> Tasks->Detach..-> Click OK Go to log file folder -> rename the testDev_log.ldf to be like testDev_log-aa.ldf, Highlight Databases->Attach…-> Click Add -> add the database testDev, highlight the log file and click the ‘Remove’ button. This means you only attach testDev.mdf After this is done, you can verify the contents of the attached database and then delete the log file.