Developer hearted / Relational minded

Do you want to script out the jobs available in SQL Server Agent ? There a many ways to skin the cat. The probably easiest one is to us the built in functionality of SSMS. Simply select all the jobs (doing a STRG+A on the Object Explorer list) and...

Doing a SKUUPGRADE has changed a little bit in SQL Server 2008. Instead of using the SKKUUPGRADE from the SETUP.EXE as in SQL Server 2005 you can now specify the parameter /ACTION=Upgrade. [1] For the GUI friends, there is a new Edition Upgrade wizard...

  Common scenario, you want a subset of data which is duplicate across some attributes but does contain additional attributes being not duplicate at all. For a quick sample, I used the new function of table row constructors in SQL Server 2008 to...

Due to the problem that there is no definite table for getting information about the current status of jobs, I created a small procedure grabbing the information from parts of the internal procedures used to extract the very relevant information. As an...

While talking with a former colleague of mine, we were elaborating about methods for syncing databases in his company. After boiling down the scenario to a point where we excluded all sync technologies possible, we came down to good old triggers. As of...