January 2009 - Posts
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 choose
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
