The Ji Village News

Category: Technology

  • Sql Server aliases can be handy at times

    In both Sql Server 2000 and Sql Server 2005, you can create server aliases on your client machine. When you connect to the database server from this client, you can use the server’s alias, instead of its real name. This can be handy at times. For example, if you have a DTS / SSIS package…

  • DTS runtime and Legacy Components are not supported on 64-bit

    SQL Server 2005 provides a utility called DTS Migration Wizard to help you move your legacy DTS 2000 packages to SSIS format. It is not guaranteed to work perfectly, but it will make a best-effort attempt. Initially, you may want to install DTS runtime on the SQL Server 2005 box so you can continue running…

  • Give role authority to upload image files in DNN

    I talked about roles and permissions in DotNetNuke (DNN) in this post. Sometimes you want to grant a role authority so users with that role can upload image files for their documents. Here is how you do it: 1. From the Admin menu, usually at the far right of the horizontal menu bar, pick File…

  • Great Flickr Greasemonkey Scripts

    Update: Flickr changed its interface, so the scripts in step 2 and 3 no longer work. I will update this as I get more information. If you have Flickr account and use Firefox, I found 2 Greasemonkey scripts that are very helpful. They make photo editing so much more easier. They are both focused on…

  • Connect to a different database server within command line utility

    In sqlcmd, you can connect to a different server by this command: :connect MyServer The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead: :connect MyServer -U MyLogin You can do the same kind of thing in Oracle Sql Plus by using this…