Click here for the latest SQL Server SIG news.

Thursday, March 24, 1999 NEXT SQL SERVER SIG MEETING ************************************************************ The next SQL Server SIG meeting will be held on Thursday, April 1, 1999 at 6:00 PM. This meeting will be hosted at the offices of Solutech, Inc. located in the Lighton Plaza at 7300 College BLVD, Suite 165, Overland Park, KS. See http://home.gvi.net/~spyder/img/solutech_map.gif for a map. Solutech's offices are on the first floor, and parking in the building lot is FREE. The topic will be "Creating SQL Server Stored Procedures". The first part of the presentation will be introductory and geared for those who have little or no experience writing stored procedures. The second part of the presentation will be an open forum to discuss stored procedures. Please feel free to bring samples of your own stored procedure creations to share and discuss with the group. Please feel free to print out and distribute the flyer for this meeting; the flyer is located at http://home.gvi.net/~spyder/sqlflyer.html . SEEKING SQL SERVER AUTHORS ************************************************************ Have you ever dreamed about writing a book? Or read a book and said, "I could do that"? If so, now is your chance. Certification Insider Press (an imprint of The Coriolis Group) is looking for qualified SQL Server administrators and designers who may have the skills to author or review books in this area. Qualified individuals should be SQL Server certified, in the process of acquiring their MSDBA certification, have strong writing skills, and the ability to develop a well-organized book manuscript. Also, a teaching or instructing background is helpful as the books they are looking to publish focus on the certification arena. To find out more, contact Jeff Kellum, acquisitions editor, at mailto:jeff.kellum@coriolis.com . SQL ON MULTIPLE RDBMS PLATFORMS ************************************************************ Rob Kraft, leader of the Heartland Users Groups' Visual Basic SIG has been developing an application this last year that runs on multiple RDBMS platforms (Oracle, Microsoft SQL Server, and Microsoft Access). Rob ran into a number of interesting things during the course of the project. Check out Rob's findings at the following web location: http://ourworld.compuserve.com/homepages/robkraft/professnl/sqldb.doc . INTERNATIONAL SQL SERVER USERS GROUP ************************************************************ Microsoft Corporation and PLATINUM technology are founding an independent SQL Server user group known as the Professional Association for SQL Server (PASS). The new association will be launched at its inaugural conference, COMPASS, held in Chicago, Illinois on Sept. 29 - Oct. 2, 1999. Check out the PASS web site at http://sqlpass.org/tracks.html for additional details. SQL SERVER FAQs ************************************************************ FAQs (Frequently Asked Questions) pertaining to SQL Server 7.0 and 6.x are available from the Microsoft support site at the following locations: * SQL Server 7.0: http://support.microsoft.com/support/sql/70faq.asp * SQL Server 6.x: http://support.microsoft.com/support/ sql/content/faq/default.asp SALARY SURVEYS ************************************************************ Check out these online salary surveys to see how your pay stacks up with the national averages: * SWYNK: http://www.swynk.com/salarysurvey/ * InformationWeek: http://www.informationweek.com/salary UPCOMING SQL SERVER EVENTS ************************************************************ All Heartland Users Groups meetings are open to the general public. Anyone may attend any of the various monthly SIG meetings and the HUG general meeting. If you are not already a member of the Heartland Users Groups, please consider joining -- an individual membership is only $25.00. Just ask the SIG leader or any Heartland Users Groups officer for a membership form. Your membership entitles you to receive the monthly newsletter and makes you eligible to receive door prizes at Heartland Users Groups events. Thursday, April 1, 1999 at 1:00 PM - 4:00 PM Maximizing SQL Server 7.0: Data Warehouse Solutions At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS Register via the web at http://www.solutechinc.com or call 913.451.8703 Thursday, April 1, 1999 at 6:00 PM - 8:00 PM Monthly SQL Server SIG Meeting Topic: Stored Procedures At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details Thursday, April 15, 1999 at 1:00 PM - 4:00 PM Maximizing SQL Server 7.0: Performance and Tuning At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS Register via the web at http://www.solutechinc.com or call 913.451.8703 Tuesday, April 20, 1999 at 9:00:00 AM - 10:15:00 AM MSDN Workshop - Migrating to Microsoft SQL Server 7.0 (Overview) AMC Theatre - Town Center 20 119th and Nall Leawood, KS Register via the web at http://events.microsoft.com/isapi/events/event.asp?s=436988 Tuesday, April 20, 1999 at 10:30:00 AM - 11:45:00 AM MSDN Workshop - Integrating Sybase apps with SQL Server 7.0 AMC Theatre - Town Center 20 119th and Nall Leawood, KS Register via the web at http://events.microsoft.com/isapi/events/event.asp?s=436986 Tuesday, April 20, 1999 at 1:15:00 PM - 2:30:00 PM MSDN Workshop - Migrating Access databases to SQL Server 7.0 AMC Theatre - Town Center 20 119th and Nall Leawood, KS Register via the web at http://events.microsoft.com/isapi/events/event.asp?s=436987 Thursday, May 6, 1999 at 6:00 PM - 8:00 PM Monthly SQL Server SIG Meeting Legato Storage Systems At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details Thursday, June 3, 1999 at 6:00 PM - 8:00 PM Monthly SQL Server SIG Meeting Database Stress Testing -- Cyrano At Solutech Inc. 7300 College BLVD, Suite 165 Overland Park, KS See http://home.gvi.net/~spyder/sqlserver.html for details MICROSOFT NEWS ************************************************************ Microsoft Technology Day for the Kansas City metropolitan area will be held on April 20, 1999 at the AMC Theater in Town Center Plaza at 119th and Nall. See the SQL Server workshops in the list above or go to the following web site to search for a complete listing of all 14 workshops that will be held on that date: http://www.microsoft.com/midamerica/events . See http://www.microsoft.com/mcp/certstep/mcdba.htm for details about Microsoft's new Database Administrator certification program. 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 (this offer expires March 31, 1999 and the training must be completed by April 30, 1999). Order your free* Microsoft SQL Server 7.0 trial CD today at http://www.microsoft.com/sql/go/imdb.htm *Shipping and handling charge of $9.95 will apply to all CD orders. Trial CD is only available in the U.S. The trial period is limited to 120 days. 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.