Date: 09 Sept 2014
Time: 4:30 PM
Location: Microsoft Office in Waukesha (N19 W24133 Riverwood Drive, Waukesha, WI 53188)
We need presenters. There must be something useful in that head of yours – why not share it with the group? You might even discover you like it. Check out Kendra Little’s post on speaking
Take a deep breath and make the commitment. It won’t hurt. Promise.
24 Hours of PASS
: Free SQL Server training from industry experts! Starts at 07:00 (CDT) on September 9th, 2014 and runs for… yup, 24 hours. Oh, and it’s free. www.24HoursOfPASS.com
PASS Virtual Chapters
: Over two dozen virtual chapters, each focusing on a different area of SQL Server. Go to http://www.sqlpass.org/
and click on the Join a Virtual Chapter button to view the list and just click to the chapters that interest you.
WISSUG Newsletter Changes
If you would like to continue to receive information about upcoming meetings and events for both WISSUG & PASS, please make sure you get registered with an account on SQLPASS
. Starting in April 2014, all communications about WISSUG will be sent via a mailing list to users registered as WISSUG members with sqlpass.org.
Here's how to make sure you can stay "in the know"!
2. If you've never registered with this site before, use the Register link in the upper right-hand corner to create your account.
3. If you already receive messages from PASS, login with your account information.
4. Once you're logged in, go to MyChapters and make sure to join WISSUG as a Local Chapter.
5. Make sure the Subscribe to Email Newsletter is checked.
LiveMeeting is being replaced with Lync
Microsoft is replacing LiveMeeting with Lync, so we will be using Lync for remote access to the presentations beginning with the April 8th 2014 meeting. Please see the links below if you need the (free) Lync client software.
September 2014 WISSUG meeting
Replication. The very word can cause even hardened DBAs to break out in a cold sweat. Transactional, Publisher, Snapshot, Subscriber, Merge, Distributor - yikes! What does it all mean? How does it work?
Relax. Take a few deep breaths. And come to the September WISSUG chapter meeting as our very own Dr. Tom Lane explains it all.
“I Love Replication” Something Uttered By a DBA… Never. – Presented by Dr. Thomas Lane
As luck would have it you need to get data from point A to point B on a regular basis so someone suggests replication. Many things run through your mind like maybe I could deliver the data myself I have a few thumb drives, “who is the DBA anyway?”, or even which model and which type would work best here? This talk will go over all replication options available in SQL Server along which the many of the pitfalls and gotchas you should be aware of before setting things up.
Dr. Thomas Lane: Currently Thomas is BI/DW Architect at Solve. Solve delivers high-impact end-to-end solutions. We are experts in Business Intelligence and App Development, and we bring a special passion into every project. We have office locations in Northwest Arkansas, Chicago, and Milwaukee. Thomas received his Ph.D. in Chemistry, did his post-doctoral study at Marquette University, taught programming and database classes at Marquette University, worked as an instructor for a private teaching firm, worked as a developer, and for the past fourteen years worked with SQL server as DBA, ETL specialist, and Data Architect at various Midwestern companies.
WISSUG Meeting Agenda
* Networking with your peers: Got a problem? Got an answer? Share it!
* WiSSUG Business: Don’t just sit there – participate! Volunteer, present a topic, share your expertise (or your painful learning experience) with chapter members, suggest a topic for a presentation. The more people participate, the better the group becomes.
* Presentation by Dr. Thomas Lane
Lync Meeting Information
IMPORTANT: Lync requires an audio device to be connected on your computer to function properly. This is a known (and frustrating) issue with Lync. Some users have reported plugging in even a non-functional microphone has allowed Lync to work. Some users have reported better results using Lync 2010. Let’s hope Microsoft addresses this issue soon!
Join the Meeting!
Audio Information - Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
Lync 2010 downloads:
Obligatory Legal Notice:
Microsoft Office Lync can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
Upcoming WISSUG Meetings
14 Oct 2014 Mike Shelton – Data Warehousing with SQL Server
11 Nov 2014 – No chapter meeting in November (see you at the PASS Summit!)
09 Dec 2014 TBD (insert your name here…)