Networknet.nl

The SMS 2003 infrastructure I am managing has one singe SMS database which became 4 GB. 1GB data and 3GB log. Today I planned the database maintenance and managed to shrink the files with 3GB. Open the Enterprise Manager or Microsoft SQL Server Management tools and make sure the database option is set to Auto Shrink = Auto (enhancement for the future).

Run the following sql script:

USE [SMS_123]

GO

DBCC SHRINKFILE (N‘SMS_123_log’, 0, TRUNCATEONLY)

GO

Another useful script can be found here which will create a stored procedure and show all table space sizes with rows and MB used.

exec sp_show_huge_tables

Yesterday I successfully passed the 70-292 Microsoft exam. Somewhere in 2004 I finished all requirements for MCSA 2000 and in 2005 I passed my last exam for MCSE. It was three years ago I did my last one for Microsoft and before 31 of March 2008 I will need to pass 70-292 & 70-296 to upgrade my current MCSA/MCSE 2000 certificates. After 31st of March both of the upgrade exams will retire. I managed to pass the first one, but Microsoft put a lot of effort to enhance their exams and they even changed to one provider Thomson Prometric Test Center (I had issues with the new tool and couple times delay of minutes before new question was on the screen). Be prepared!!!

The 70-292 was a tough one even for a system administrator with years of working experience; sus1.0 has been discontinued for a while but the questions were there.

I used one eBook (MCSE Core Required Exams in a Nutshell O’Reilly Media) and netfresco.com 70-292 study notes website to prepare myself for the exam.