This entry has been pending for a week but it is still worth posting. Last week was the Server Wave Launch 2008 event here in Singapore where Microsoft released their very new products, namely, Windows Server 2008, Visual Studio 2008 and SQL Server 2008. This launch’s theme focuses on celebrating the people behind the technology […]
>This was a long awaited blog post dating back last November 2007 when I did a session at the Singapore SQL Server User Group specifically for this topic. One of the most difficult task that DBAs are faced with in managing complex enterprise database environments is ensuring that all elements of the system conform to […]
>If you have been playing around with SQL Server 2008, chances are that you may have already seen this in your Task Manager’s running processes. DCEXEC.EXE is the data collector run-time component which manages data collection based on the definitions provided in a collection set and can accept any collection set as input. What is […]
This was initially posted in a private newsgroup sometime April of 2006 and I decided to simply post it publicly. We only look at Easter Sunday as the day when Christ resurrected from the grave. After a grueling experience at Golgotha in the hands of the brutal Roman soldiers and being left alone by followers […]
As a database professional, I get to work with databases every single day of my life (that doesn’t count all the other stuff I work on). Databases have to maintain files in the file system to store data. Initially, a fixed size is allocated to the database files. The databases are either configured to have […]