-
Midsommar and kräftskiva
The normally reserved Swedes celebrate summer in a big way. The biggest celebration of all is Midsommar, where people put up a maypole, sing and dance around it while imitating frogs, pigs, and violen playing, and just be merry in general. I’ve never attended Midsommar celebration during my summer trips in Sweden, because we were…
-
Sql Server Browser needs to be started for remote connection to a named instance
A default installation of Sql Server 2005 is pretty easy. After install, you can connect to it remotely, either through Sql Server Management Studio or sqlcmd. However, if you install a named instance on the same box, you may not be able to connect to it remotely, although connecting to it locally would still work.…
-
Issues connecting to SSIS and browsing packages in msdb when database service is clustered
In Sql Server 2005, you cannot cluster Sql Server Integration Service (SSIS). During database cluster install, you can pick to install Integration Service. SSIS will only be installed on the node where installation process starts from. For example, suppose you have Node1 and Node2, and the install is started from Node1, then database service and…
-
One year of blogging and trying to get out of my funk
It has been a little more than a year now since I started blogging. I started writing Sql Server related entries at http://blogs.sqlservercentral.com/blogs/haidong_ji/default.aspx. Shortly after that, I established this site, where I post all my blog entries. My purpose is simple: sharing my musings and observations, sharing my learning experience of various technologies, and keeping…
-
Grant database read/write access to Windows login
Regular readers may have noticed that I am a big fan of automation. As such, for repetitive tasks, I prefer scripting over point and click. Nothing wrong with point and click though. For one time task, I don’t mind using GUI to get it done quickly. Repetitive is the key word here. Below is a…