>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 […]
>I will spend the next couple of blog posts looking at performance tuning and troubleshooting in SQL Server 2005, although I may insert a few posts about SQL Server 2008 and probably SharePoint 2007. Having to work in an organization that provides enterprise hosting services, I regularly deal with customers who blame our infrastructure whenever […]