A Website by Richard Feich

While doing a bit of research I happen to come across a memoriam for the first Technical Manager of my professional career, which started at Bell Laboratories in Naperville. Wing Toy and some folks on his R&D team interviewed me for a position within his “Advanced Processor Architecture Group”. This happened just before I was ready to graduate with my BSEET. After interviewing with a number of companies, Bell Labs is where I wanted to work, especially in Wing Toy’s group. They liked me as well. Unfortunately, a hiring freeze was imposed by upper management and they were unable to extend me an offer. Wing personally called me to deliver the news. I was very disappointed; but I fervently expressed my desire to be apart of his group. He said that he would keep me in mind if the situation changed. He pulled some strings for me, and an exception to the hiring freeze was made; he called me a few weeks later with the good news. Thank you Wing! I still have the offer letter.

I worked with Wing in his group for a number of years along side top-notch, truely excellent engineers. This early experience laid the foundation of my engineering career.

Wing was not only a pioneering engineer, but also a warm kindhearted human being.

In Memoriam
IEEE TRANSACTIONS ON COMPUTERS
VOL. 41. NO. 5. MAY 1992
Dr. Wing N. Toy (19264990)This special issue of IEEE TRANSACTIONS ON COMPUTERS on fault-tolerant computing is dedicated to the memory of Dr. Wing Toy, who passed away on Oct. 28, 1990. He was an inspiration to all of us in the fault-tolerance community. His kind, unassuming demeanor belied the fact that he was one of the pioneers in this field and he continued to be one of its leading technical innovators over his long career. We were honored to have him as a friend. Dr. Toy was born on Feb. 9, 1926 in Canton, China, and came to the United States with his family at the age of 12 in 1938. He received the B.S. and MS. degrees in electrical engineering from the University of Illinois-Urbana in 1950 and 1952 and a Ph.D in electrical engineering from the University of Pennsylvania in 1969. During his 37-year career at AT&T Bell Laboratories, he was one of the principal designers of several generations of fault-tolerant computers for the Bell System electronic switching systems (ESS). The first system was developed when fault-tolerant computing was in its infancy and the idea of producing a computer system with only a few minutes of downtime per year was unheard of. The resulting duplex design (ESSl) using discrete components and such exotic technologies of the time (1959) as “twister memories” was implemented in Bell Telephone switching systems. It was a pioneering effort that was a predecessor of modern duplex machines such as Tandem and Stratus. As the technology advanced he continued to develop fault-tolerant machines (ESS 2 and ESS 3) leading to the current 3B20D processor which provides administrative control of the SESS Switching System and other telephony-related applications. He was awarded the prestigious Bell Labs Fellow award in 1983. Dr. Toy’s accomplishments include 30 U.S. patents and numerous publications in technical journals, several of which can be viewed as classics in the field of fault-tolerant computing. He was a distinguished member and dedicated contributor to the IEEE Computer Society. He was elected a Fellow of the IEEE in 1981 for his contributions to the conception, design, and development of fault-tolerant computers for electronic telephone switching and telecommunication systems. He served as a member of the IEEE Computer Society Governing Board (1986-1987 & 1990), an editor of IEEE TRANSACTIONS ON COMPUTERS (1986-1988), a member of the IEEE COMPUTER editorial board (1983-1986), the chairman of the program committee for the Computer Software & Applications Conference (COMPSAC ‘SS), and also served on numerous program committees for IEEE-sponsored con- ferences. Dr. Toy also contributed to the field of education. He was on the faculty of the Computer Science Division of the EECS Department of the University of California-Berkeley during the 1973-1974 academic year as a Visiting MacKay Lecturer. He also co-authored three textbooks. In addition, he taught regular and short courses at Northwestern University, the University of California-Irvine, and the University of Wisconsin-Madison. He served on the IEEE Ad Hoc Accreditation Visitors Committee during 1980-1985. Dr. Toy, who extended kindness to those in need of help throughout his life, was named in 1982 the outstanding Asian-American in the state of Illinois by the Asian-American Heritage Council.

 Full credit to Narayana Vyas Kondreddi — this code has help me immensly with database imgration and server clean-up. Thank You sir.

CREATE PROC dbo.ShowOrphanUsers
AS
  BEGIN
    CREATE TABLE #Results (
      [Database Name] sysname    COLLATE Latin1_General_CI_AS,
      [Orphaned User] sysname    COLLATE Latin1_General_CI_AS)
    
    SET NOCOUNT ON
    
    DECLARE  @DBName sysname,
             @Qry    nvarchar(4000)
                     
    SET @Qry = ''         
    SET @DBName = ''
                  
    WHILE @DBName IS NOT NULL
      BEGIN
        SET @DBName = (SELECT MIN(name)
                       FROM   master..sysdatabases
                       WHERE  name NOT IN ('master','model','tempdb','msdb',
                                           'distribution','pubs','northwind')
                              AND DATABASEPROPERTY(name,'IsOffline') = 0
                              AND DATABASEPROPERTY(name,'IsSuspect') = 0
                              AND name > @DBName)
                      
        IF @DBName IS NULL
          BREAK
          
        SET @Qry = ' SELECT ''' + @DBName + ''' AS [Database Name],
CAST(name AS sysname) COLLATE Latin1_General_CI_AS 
AS [Orphaned User] FROM ' + QUOTENAME(@DBName) +
'..sysusers su WHERE su.islogin = 1 AND su.name
<> ''guest'' AND NOT EXISTS
( SELECT 1 FROM master..sysxlogins sl WHERE su.sid = sl.sid )'
                                                 
        INSERT INTO #Results
        EXEC( @Qry)
      END
      
    SELECT   *
    FROM     #Results
    ORDER BY [Database Name],
             [Orphaned User]
  END

Seems obvious doesn’t it? Well, it’s branded with my name; that’s a clue.  All of the opinions, thoughts, photography, artwork, and code presented on this website are solely mine [unless otherwise stated].  I do not represent any businesses, organizations, or my employer in this regard. I do not to make money  and have no commercial interests with this website. This website is simply a platform for self expression.

If you have issues with the content of this website, feel free to log-in and post comments (be polite) or send me an email; there is a contact form on the “About” page. Please do not contact my family, friends, or my employer with issues regarding this website – that’s not cool.

 The information on this website is provided “AS IS” with no warranties, and confers no rights.

I reserve the right to publish or delete [for any reason] comments posted on this website. All comments will be approved before publication.

All original content is copyrighted. All content is subject to change without notice.

You should not drive or operate machinery while reading this blog. Your actual mileage may vary.

[I’ll write a better disclaimer later; but this gets to the main point for now]

This beach is absolutely beautiful; great for swimming and snorkeling. Early morning we would see surfers catching waves on the other side out a bit where the waves break. In the winter the south shore [where Poipu lives] is generally calmer while the north shore roars with intensity, we have seen it. The sand on this beach is golden and very soft…you just love to wiggle your toes in it. Right now it’s about 5 degrees in Chicagoland, and it snowed almost every day this month so far. I want to go back to Kauai! This shot was taken in the morning just after an early breakfest at the Sheraton. For a better view, enlarge your browser window and “click it”.

“click-it for the big picture”

While in Kauai we stayed at the Sheraton which embraces the Poipu Beach on the south shore. The Poipu Beach is arguably one of the very best beaches on the island; totally user-friendly, especially in the winter. It consists of three beautiful crescents of golden sand accented with black lava rocks. The shot below was taken just near west edge of the beach; painted with a beautiful sunset accompanied by a warm tropical breeze while I enjoyed a Mai Tai…perfection! Today in Chicagoland it’s -25 to -30 degrees fahrenheit with the wind chill-factor — ouch!

I wish you all the very best; and many more to come. Lookin’ forward to tippin’ a few with ya. Have a good one!

Aloha. I recently returned from a fantastic vacation on the island of Kauai, Hawaii. This was my first visit; I fell in love with this place. This trip was a spiritually significant experience for me.

The photo below was taken while hiking on the Kalalau trail which provided a spectacular view of the Kalalau Valley along the Na Pali coast on the north shore of the island.  Please click the image for a larger view (900 x 602):

“click it”

Imagine a straight forward informational website of around 25 pages including a few special features like an events calendar, publications section, contact form, and a simple membership management piece with maybe 40 members…and yes, it has an intergrated Content Management System — Sitecore. Sitecore is like an iceberg where the end-User Interface is just the “tip” as they say. The CMS functionality and databases (8 in this case) which exist below the surface is massive.  This relatively simple informational website built with Sitecore requires more then 5 Gigabytes of disk space, yes that’s right 5 GB. Something to consider when building with this system.

Lately I have been involved with migrating websites from one production server to another. All of these websites are CMS applications with databases on the back-end; implemented with Microsoft Technologies. This post will discuss the database aspect of website migration. There are a number of different methods to copy or move a database: detach-move-attach, backup-move-restore, export-import, DTS, Copy Database Wizard. Since we are not only moving the databases, we are also upgrading from SQL Server 2000 to SQL Server 2005, I decided to give Copy Database Wizard (CDW) a try…it’s a tool under SQL Management Studio full version. In theory CDW sounds great, but in practice you’ll pull your hair out getting it to work in some cases. CDW is very finicky about set-up, permissions, etc.

Preparation

• Check the source database ownership. If needed, change it to an account with sysadmin membership. For this example I used the sa account. To change DB ownership execute the following code in Query Analyzer:

use [currentdatabase]
go
sp_changedbowner 'yourusername', 'true'
go

• Check the source database for orphaned users and resolve or delete them. Here is an excellent article about orphaned users along with a Stored Procedure for identifying them:
  http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
  Orphaned users will cause a failure at the destination during the DB copy.
• On the source server add an entry to the LMHOSTS database file which is the IP address and NTLM name of the destination server. For additional info: http://support.microsoft.com/kb/314108
• To avoid data loss or inconsistency, you must be sure there are no active sessions attached to the database being moved or copied. It’s probably a good idea to do it off-hours and take the website off line during the migration.
• Make sure the SQL Server Agent has the proper user account setting…should be set to the Local System Account (NT AUTHORITY\System).

Process

1. Login to the destination server with admin credentials, fire-up Management studio and the CDW tool. Right click on a db, CWD is under tasks. CDW will step you through various screens to build the SSIS[DTS] package.
2. Specify the Source SQL Server by name or IP, use SQL Server Authentication, enter credentials of the saaccount – ID and password.
3. Specify the SQL Destination by name or IP, use SQL Server Authentication, enter sa account credentials of the sa account — ID and password.
4. Select Transfer Method, use the SQL Management Object method. This will allow the DBs to stay online and operational during the copy.
5. Select databases to be copied — use the copy checkbox…don’t move it.
6. Configure destination database. For this example I just used the default destination name and location. I also selected “drop any database at destination if one exists” to overwrite it.
7. Select the database objects. Leave the logins selected and nothing else. This will bring over the logins, so your connection strings should work at the destination with only a server name change.
8. Configure Package screen. Select logging options. Sometimes it’s good to direct logging to a file for better debugging.
9. Schedule package or run immediately — I have been just running immediately.
10. Verify choices — go back if needed.
11. Run the job — all steps should be all green [pass] or study the log file if debugging is needed.
12. Refresh Management Studio database list. Right click top server node and select refresh. The new databases should now appear. Check tables, users, etc.
13. Run sp_updatestats against the database on the destination server to
    update statistics and make sure that the copied database is performing optimally.
14. Update connection strings and test application.

The Ridges Sanctuary in Door County, Wisconsin is one of my favorite places visit with Mother Nature.