The Ji Village News

Category: Technology

  • Connect to SQL Server 2005 using Query Analyzer, osql, and isql

    In this post, I talked about some potential permission issues facing average users regarding Sql Server Management Studio (SSMS) reports. When you manage Sql Server 2000 servers with SSMS, those reports will not be available, for the simple reason that most of those reports are based on DMVs, which are newly introduced in SQL Server…

  • Creative ways for ego boost

    The book I co-wrote on Sql Server Integration Service (formerly know as DTS) has been selling pretty well at Amazon. I received 10 copies from the publisher a few weeks ago. I must confess that I felt pretty good seeing my own picture on the book cover. It should reach bookstores soon. However, don’t use…

  • Silent install / Command line install of SQL Server 2005 Part 4

    The fourth time is a charm! I’ve documented my experients with SQL Server 2005 silent / command line install in 3 previous posts. They all failed. To be fair, I tested it using September CTP, not the finalized RTM release. After I got the RTM last November, I loaded it on my laptop, so I…

  • Barcelona bound

    My proposal on sqlcmd was accepted at Sql PASS European conference, to be held in Barcelona, Spain. Last Friday I submitted the last document the Spanish Consultate in Chicago needed. I was told that I would be able to get the visa next Friday. I will deliver a session on sqlcmd for the conference. So,…

  • Be careful of .Net Framework hell Microsoft

    I have encountered a few instances of application failing to install because of the .Net Framework on the machine is either too old or too new. This happened quite a lot during my testing of Microsoft SQL Server 2005 Beta and CTP. I figured it was ok because, after all, it was Beta, although I…