Click here for the latest SQL Server SIG news.

Wednesday, October 7, 1998 Dear SQL Server Professionals, The purpose of this message is to provide you with the latest information about the Heartland Users Groups' SQL Server SIG. This e-mail message was sent to you as a 'blind copy' to protect your privacy. Please feel free to forward this message on to whomever you feel may have an interest in the Heartland Users Groups and/or the SQL Server SIG. If you wish to be removed from this e-mail list simply send a reply to this message and indicate so. MICROSOFT EVENT ON OCTOBER 16TH ************************************************************ Microsoft will be hosting a free half-day workshop entitled "Building Business Solutions with SQL Server 7.0 and Visual Basic 6.0" on October 16, 1998 at the Conference Center of the Business Technology Association, 12411 Wornall Road, Kansas City, MO. See the flyer at http://home.gvi.net/~spyder/sqlmsevent.html for details or go to http://www.microsoft.com/midamerica/events and enter event code 20613. OCTOBER 22nd SQL SERVER SIG MEETING ************************************************************ The October SQL Server SIG meeting will be held on Thursday, October 22, 1998 at 5:30 PM. This meeting will be held at the offices of Analysts International Corporation, located in the Broadway Summit Building, 3101 Broadway, Suite 101, Kansas City, MO. This building is situated on the SOUTHEAST corner of 31st Street and Broadway. AIC's offices are on the first floor. Please use the entrance located on the SOUTH side of the building. Parking in the building lot is FREE. The topic will be "Database Design 101", which will be an introductory lesson about logical database design concepts and techniques. We will learn about entities, attributes, relationships, and keys, and we will demonstrate the use of Platinum's ERwin data modeling tool. This session will be relatively platform-independent so persons who use database systems other than SQL Server should also benefit. Brent Huscher, SQL Server DBA for Payless Cashways, will be the presenter. We will also be electing SQL Server SIG officers at this meeting. SQL SERVER 6.5 AND Y2K ************************************************************ Microsoft SQL Server 6.5 Y2K compliance information may be found at the following new link: http://www.microsoft.com/technet/topics/year2k/product/user_view9796EN.htm OLTP vs OLAP ************************************************************ See http://home.gvi.net/~spyder/sqloltpolap.html for a quick look at a diagram showing the differences between OLTP and OLAP systems. SQL SERVER 7.0 ************************************************************ Use the following link to find out the latest information about Microsoft's soon-to-be-released SQL Server 7: http://www.microsoft.com/sql/beta/default.asp. You may also use this link to request a free copy of SQL Server 7.0 beta 3. GENERAL INFORMATION ************************************************************ 1. Effective immediately and until the end of 1998, SQL Server SIG meetings will commence at 5:30 PM. Based on feedback, we may decide to have meetings in 1999 and beyond at a later hour. 2. Effective November 5, 1998, the regular meeting day of the month for the SQL Server SIG will be the FIRST THURSDAY of the month. 3. The following is the calendar of SQL Server SIG meetings for the rest of 1998: a. October 1998: Thurs. 10/22/98 @ 5:30 PM at AIC, 3101 Broadway, Suite 101 b. November 1998: Thurs. 11/05/98 @ 5:30 PM at AIC, 3101 Broadway, Suite 101 c. December 1998: Thurs. 12/03/98 @ 5:30 PM at AIC, 3101 Broadway, Suite 101 4. See the following web page for links to good books about SQL Server: http://home.gvi.net/~spyder/sqlreading.html . Let me know if you have any other books you would like to see on the list. 5. Effective in November 1998, the Windows 9x/NT SIG will be splitting into two separate SIGs: One for Windows 9x and the other for Windows NT. John Webb will lead the Windows 9x SIG. Jan Brandt will be the leader of the new NT SIG. The NT SIG will meet on the second Tuesday of each month starting November 10, 1998. See the main HUG web page at http://www.hugkc.org for further details. BE A SQL SERVER SIG OFFICER ************************************************************ Until the October 22nd meeting, I will continue to act as the SQL Server SIG's provisional leader; however, we need to have official elections of SQL Server SIG officers. Interested parties are encouraged to nominate themselves for any of the following five offices: president, vice-president, programs committee chair, membership committee chair, or treasurer. See the following web page for descriptions of the duties of these offices: http://home.gvi.net/~spyder/sqlofficers.html . Elections will be held at the Thursday, October 22, 1998 meeting. The following persons have been nominated thus far: Matt Crouch - nominated for vice-president, Bob Van Cleave - nominated for treasurer, Brent Huscher - nominated for president. Call or send me an e-mail message if you are interested in nominating yourself. UPCOMING HEARTLAND USERS GROUPS EVENTS ***************************************************************** All Heartland Users Groups' meetings are open to the general public. Joining the Heartland Users Groups entitles you to receive door prizes and the monthly newsletter. Please consider joining -- an annual membership is only $25.00. You can obtain a membership form at any of the Heartland Users Groups' events. Here is a calendar of upcoming Heartland Users Groups events: Saturday, October 10, 1998 at 9:30 AM - 11:30 AM Win 9x/NT SIG -- topic TBA At COMP-USA 11421 Metcalf, OP, KS Wednesday, October 14, 1998 at 7:00 PM - 9:00 PM C++ SIG -- topic TBA At Step 1, Inc. 10551 Barkley, Suite 117, OP, KS See http://www.kcx.com/c/ for details Monday, October 19, 1998 at 7:00 PM - 9:00 PM General Meeting -- topic TBA At Johnson County Community College Room GEB 233, OP, KS see http://www.hugkc.org for details Tuesday, October 20, 1998 at 6:00 PM - 8:00 PM Smalltalk SIG -- Squeak 2.1; A freeware Smalltalk-80 implementation by David Mitchell At Information Systems Corp. City Center Square, 1110 Main, Suite 1540, KC, MO See http://www.kcx.com/smalltalk/ for details Wednesday, October 21, 1998 at 6:30 PM - 8:30 PM Access SIG -- topic TBA At Johnson County Community College Room GEB 137, OP, KS See http://www.kcx.com/accessvb/logon.asp for details Thursday, October 22, 1998 at 5:30 PM - 7:30 PM SQL Server SIG -- Database Design 101 At Analysts International Corporation 3101 Broadway, Suite 101, KC, MO See http://home.gvi.net/~spyder/sqlserver.html for details Tuesday, October 27, 1998 at 7:00 PM - 9:00 PM Visual Basic SIG -- Menus, arrays, and collections; user controls At Johnson County Community College Room CEC 234, OP, KS See http://www.kcx.com/accessvb/logon.asp for details Monday, November 2, 1998 at 6:00 PM - 8:00 PM HUG Board Meeting (for HUG officers and SIG leaders) At Security Benefit Companies Corporate Woods, Building #27, Suite 150, OP, KS (northeast of College BLVD and Grandview RD) Wednesday, November 4, 1998 at 7:00 PM - 9:00 PM JAVA SIG -- JAVA tutorial (third session) At Step 1, Inc. 10551 Barkley, Suite 117, OP, KS See http://www.qni.com/~brisk/JavaSIG/Default.html for details Thursday, November 5, 1998 at 5:30 PM - 7:30 PM SQL Server SIG -- topic TBA At Analysts International Corporation 3101 Broadway, Suite 101, KC, MO See http://home.gvi.net/~spyder/sqlserver.html for details SQL SERVER JOB OPPORTUNITY ************************************************************ Actuarial Resources Corp, an actuarial consulting firm in Overland Park, is seeking a SQL developer for developing and maintaining a data mart application. This person must have strong analytical skills, and some experience developing in Microsoft SQL Server. The candidate should be keenly interested in the development of data marts using SQL Server. This is a permanent position. Salary is commensurate with experience. The firm has been in business since 1987, and has 20 employees in its Overland Park office. Interested parties should call Jim Hipp at 913.451.0044 or send e-mail to mailto:Jim.Hipp@arcval.com . MISCELLANEOUS ITEMS ************************************************************ We still need to determine a discussion topic and presenter for the November 5th meeting. If you would like to volunteer to present at this or any other upcoming meeting, please contact me by phone or e-mail. The Heartland Users Groups' home page is at: http://www.hugkc.org . The SQL Server SIG's home page is at: http://home.gvi.net/~spyder/sqlserver.html . Feel free to offer any ideas for improving the SQL Server SIG's page or for adding any links. Please let me know if you have any questions, comments, criticisms, and/or referrals of persons who may be potentially interested in the SQL Server SIG.