Click here for the latest SQL Server SIG news.

Monday, December 21, 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. NEXT SQL SERVER SIG MEETING: Thursday, 01/07/1999 ************************************************************ The January SQL Server SIG meeting will be held on Thursday, January 7, 1999 at 6:00 PM. This meeting will be hosted at the offices of Solutech, Inc. located at 7300 College BLVD, Suite 165, Overland Park, KS. This building is situated NORTHWEST of College BLVD and Metcalf AVE. Solutech's offices are on the first floor. Parking in the building lot is FREE. Lori Bird will be presenting and demonstrating Platinum Technology's ERwin data modeling tool. Lori is a Senior Product Consultant for Platinum Technology specializing in Platinum's enterprise modeling suite of applications. Lori's previous experience was with the US Air Force as a software developer and with Laboratory Information Management Systems as technical lead. Lori has a B.S. in Computer Information Science from Troy State University in Montgomery, AL and an M.B.A. in Operations Research from Wright State University (Dayton, OH). Feel free to print out and distribute copies of the flyer for this meeting. The flyer is located at http://home.gvi.net/~spyder/sqlflyer.html . SQL SERVER FIXES IN NT 4.0 SP4 ************************************************** According to Knowledge Base article Q150734 (November 5, 1998), Windows NT 4.0 Service Pack 4 (SP4) fixed the following SQL Server-specific problems: 1. Q178393--SQL Server Hangs When Sending a Message Using SQLMail 2. Q181859--Stop 0x0000000A When Using UltraBac to Back Up a SQL Server 3. Q185870--IIS: SQL Server Insert Error Regarding Column Name Mismatch 4. Q187708--Cannot Connect to SQL Virtual Server via Sockets in Cluster 5. Q192293--IIS Stops ODBC Logging after Failing to Communicate with SQL NT 4.0 SP4 also addressed a number of RPC-related bugs. The comprehensive list of NT 4.0 SP4's bug fixes can be seen at http://support.microsoft.com/support/kb/articles/q150/7/34.asp . SQL SERVER USENET NEWSGROUPS ************************************************** USENET is a collection of over 50,000 subject areas known as 'newsgroups'. Interested parties can browse or post messages to the various newsgroups. Newsgroup messages can be viewed by anyone, and anyone can post a reply to the messages. The newsgroups listed below are regularly monitored by Microsoft MVPs and are a great place to post your specific SQL Server questions. Please note that your Internet browser may require you to install additional components in order to view USENET newsgroups. For more details, please check with your Internet browser's documentation. You can also search through a huge archive of past USENET newsgroup messages at http://www.dejanews.com . news://microsoft.public.sqlserver.clients news://microsoft.public.sqlserver.connect news://microsoft.public.sqlserver.odbc news://microsoft.public.sqlserver.programming news://microsoft.public.sqlserver.replication news://microsoft.public.sqlserver.server news://microsoft.public.sqlserver.setup SUGGESTED READING ************************************************** We are adding a new book to the SQL Server SIG's suggested reading list: The Hitchhiker's Guide to Visual Basic and SQL Server, 6th edition ISBN: 1-57231-848-1. Read Chapter 28 of this book ("Understanding ADO and OLE DB") online at the following location: http://www.vs6.com/books/HitchhikerGuide6/1597.htm . Also, see http://home.gvi.net/~spyder/sqlreading.html for the SQL Server SIG's list of suggested books. THANK YOU SOLUTECH ! ! ! ************************************************************ Special thanks to Jan Brandt and the folks at Solutech, Inc. for providing the SQL Server SIG with a regular place to hold our monthly meetings. Solutech's Kansas City area office is located on the first floor of the building at 7300 College BLVD, Suite 165 in Overland Park, Kansas. Solutech is a leading provider of vendor certified consulting, technical education and software product sales. Solutech has offices in Nashville, Des Moines, Kansas City, Louisville, Omaha and St. Louis. Solutech is a Microsoft-certified training and solutions provider. See Solutech's web site for additional company information: http://www.solutechinc.com . UPCOMING 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. Monday, December 21, 1998 at 7:00 PM - 9:00 PM Heartland Users Groups' General Meeting and Holiday Networking Party At Johnson County Community College Room CEC 211 Overland Park, KS see http://www.hugkc.org for details Thursday, January 7, 1999 at 6:00 PM - 8:00 PM SQL Server SIG -- Lori Bird presents Platinum's ERwin data modeling tool At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details Thursday, February 4, 1999 at 6:00 PM - 8:00 PM SQL Server SIG -- Business Objects presentation about decision support tools At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details Thursday, March 4, 1999 at 6:00 PM - 8:00 PM SQL Server SIG -- Topic TBA At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details MICROSOFT NEWS ************************************************************ See http://www.microsoft.com/mcp/certstep/mcdba.htm for details about Microsoft's new Database Administrator certification program. Exams and courseware for this new track are expected to be available by the first quarter of 1999. Microsoft SQL Server 7.0 Overview: This is the one-day course that Microsoft is offering for $99. See http://www.microsoft.com/train_cert/sql7/oneday/ for details. Get a voucher worth $500 towards the 5-day System Administration for Microsoft SQL Server 7.0 course (course #832). See http://www.microsoft.com/train_cert/sql7/offer for details. MISCELLANEOUS ITEMS ************************************************************ The SQL Server SIG board is looking volunteers to be presenters for future SQL Server SIG meetings. If you or someone you know is interested in presenting a topic of interest to SQL Server professionals, please contact me or any other SQL Server SIG officer. The regular meeting time for monthly SQL Server SIG meetings is 6:00 PM on the first Thursday of each month at Solutech, Inc., 7300 College BLVD, Suite 165, Overland Park, KS. The SQL Server SIG's home page is at: http://home.gvi.net/~spyder/sqlserver.html . Please feel free to offer any ideas for improving the SQL Server SIG's page or for adding any links. The Heartland Users Groups' home page is at: http://www.hugkc.org . 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.