Tag Archives: microsoft

moving ms sql server

we needed to move an sql server… so we looked for space in our virtual environment… there was… but wth? moving is renaming… or isnt it? first it looked like it was, but secondly there were a few problems…

basiclly the sql server instance has the same name as the server… wrong!

sp_dropserver ‘old_name’
GO
sp_addserver ‘new_name’, local
GO

this statements change the instance name… following command returns the current instancename…

select @@SERVERNAME

and thats the history of renaming ms sql servers… funny…

asp.net mvc

at work i needed to create a new web frontend… and actually i am really disapointed with microsoft web framework asp.net… for me it is too random… ok i dont know how to do it correctly, but i am really confused with the 32452390918745 events, which will be called every postback (postback? never thought in java, that there might be different types of postback… and handlers…)… but yeah… did some application with asp.net and they all work… and are running… i think… 🙂

new project. new technology: asp.net mvc. i like it… the concept is as stated in the name: mvc… and actually i think it is really good implemented and totally included into visual studio… simple create a controller… based on it create views and of course use the model… the where is my model thing is for me not yet 100% clear… when using a external project/dll… is the dll the model? or is the dll only the functionality for the controller to fill the model? or is the model a wrapper around the dll? currently using a bit of all possibilities… works, but fareaway from perfect…

ms office docx format

currently working on a c# document creator. main goal is to create new word documents, based on a template and input data…

so had to read stuff about the docx format and figured out pretty quickly, that the format is xml based… cool… but its way more better…

just ads “.zip” to a word document and open it…

read more: http://msdn.microsoft.com/en-us/library/aa338205(v=office.12).aspx