>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 […]
Didn’t I say this blog will be full of those acronyms? I’ve seen such equations during my high school algebra days when properties of equations are being discussed. I used to think that mathematics is way too boring if not applied in our daily walks of life (which is the main reason I shifted from […]