"How do I do this ?" series
A Matchnet Case Study using Microsoft Technology
Partitioned Views, Distributed Architecture and Server Federations
featuring Peter Voutov
Mr. Voutov presented an exciting lecture that discussed how one of the top three world-wide internet dating firms use visual studio and sql server technology to keep an on-line community of people dating and chatting 24 hours a day, 365 days worldwide without interruption. This occurs in multiple time zones and in multiple languages.
Matchnet does it all with boxes that you can buy from Dell or CompUSA. If you have ever wanted to learn more about Federated and Distributed Architecture - this is the lecture for you!
Mr. Voutov discusseed the technical benefits of Partitioned Views and how to implement them. Code was shown and discussed. Peter also talked about the trade-offs of scaling up versus scaling out. What problems are solved, and which ones still remain to be solved.
Specific topics covered included:
Scale up vs. Scale out
Readiness CheckList ofr scaling out (things to do before going to multiple servers)
Scale out Approaches:
a) Distributed Partitioned Views
b) Data-dependent routing (utilized at MatchNet)
c) Message Queueing
Peter Voutov has been MatchNet's Chief Technology Officer since August 2001. From June 2000 to August 2001, Mr. Voutov was founder and Director of Systems Architecture of Akonix Systems Inc., a web applications solutions provider. In 1999, Mr. Voutov founded and built an online auction site for college students, Campus24.com, which later merged with CollegeClub.com. At CollegeClub.com, Mr. Voutov served as Senior Software Engineer. From September 1999 to June 2000, Mr. Voutov taught Mathematics and Computer Science at Harvard University. Mr. Voutov earned a Bachelor of Science degree in Mathematics from Harvard University in 1997.
Case Study: Database Structure for Geographical Mapping Systems
Doug presents a brief overview of modern development methods ranging from eXtreme Programming on one end to the Rational Unified Process (RUP) on the other, and including ICONIX Process, which fits somewhere in between. He discussed recent work in applying ICONIX Process within an "agile" context, and presented the design of the example project for the "Agile/ICONIX" book.
The example project, known as the "mapplet", is a "hotel finder" mapping application which can be found on the VResorts website at http://smartmaps/VResorts.com/hmap/ --- the mapplet project was developed using the Agile/ICONIX process, and is a C#/.Net application which uses geospatial database (i.e. map-based query) techniques. Doug was assisted in the presentation by Dave Lewis of ESRI (http://www.ESRI.com) who managed the development of the mapplet and can explain technical details of geospatial database technology.
Doug Rosenberg is the founder and President of two businesses: ICONIX Software Engineering, Inc. (http://www.iconixsw.com), and VResorts, LLC. (http://www.VResorts.com). ICONIX was founded in 1985 and has been training clients in object-oriented analysis and design since the early 90's. Doug has taught "JumpStart" training classes at hundreds of corporations over the last decade, using a minimalist, core subset of UML and a use case driven process known as ICONIX Process. VResorts.com is a travel website featuring QuickTime VR "virtual reality" photography and an online hotel reservation booking capability.
Doug is the author of "Use Case Driven Object Modeling" and "Applying Use Case Driven Object Modeling", both published by Addison-Wesley, and also "Extreme Programming Refactored - The Case Against XP", from Apress, and is currently working on two more titles: "Agile Development with ICONIX Process" due out at the end of 2004 from Apress, and "Use Case Driven Object Modeling in Theory and Practice", which will be available in summer 2005 from Addison-Wesley. Doug's first two books were co-authored by Kendall Scott, and the next three by Matt Stephens.
"How do I do this???" series
Importing and Exporting Large Amounts of Data
Featuring Franck Leveneur
When & How to use DTS for Data Manipulation / When & How to use Utilities...
Occasionally the DBA or a database programmer needs to move a large amount of data into or out of SQL Server as quickly as possible. SQL Server has several tools for bulk data transfer operations. Although DTS is one of them, we'll focus on BCP and T-SQL Bulk Insert , some powerful SQL Server utilities too often unknown or left aside. This lecture will cover the architecture, demos, tips, performance optimization for importing large text files, and the power of BCP/T-SQL Bulk Insert with Dynamic SQL.
Franck Leveneur has been using MS SQL for more than 7 years and is a member of the Los Angeles SQL Server Professionals Group. He is currently working as a Data Architect at DaVita. For almost 3 years he has been responsible for the architecture, programming, and implementation of database driven web applications and data warehouse. He has extensive experience with stored procedures, OLAP, UDF, and BCP. Prior to DaVita, Franck worked as a Sr. DBA /Tech Leader @ Genex, Culver City.
Understanding SQL Server's Query Optimizer
Optimize your queries
Presented by: Dave Owen
Learn how to communicate with SQL Server's Query Optimizer efficiently
and effectively. Attendees will learn:
The steps to executing a query
How to read and interpret SQL Server's Execution Plan and use that valuable information to optimize your queries
How indexes affect your queries
Write the query with an unambiguous search argument.
Pre-think join order and minimize table joins
Dave is an outstanding speaker who brings over twenty-five years on information management expertise to our podium. He managed environmental data collected from every naval facility world-wide, stored the data for easy access and reported the information to the Department of Defense, Department of the Navy and the Environmental Protection Agency.
After retiring in 1997, he worked on a number of tasks for cities and counties in California in implementing Department of Labor Work Force Investment Act issues. He also teaches Microsoft and Cisco Systems certification tracks at Moorpark College.
Dave holds MCSA, MCSE, MCDBA and MCT certifications. Dave's past topics with the LA SQL-SIG have included Business Intelligence and Analysis Services.
Performance Analysis & Tuning
in SQL Server 2000
(with an introduction to Yukon)"
Director, Application & Architectural Development
Jeff has been working closely with Microsoft as a beta tester for Yukon. Jeff shared with us his experiences and first-hand knowledge about the eagerly-awaited release of SQL Server 2005.
Electronic Crimes and the Corporate Response
Protect data stored in corporate databases
Joel Rakow, Ed.D
Data Protection Strategies for your databases.
Organizations coping with data protection issues face serious challenges:
an increase in electronic crime
a new wave of privacy legislation
insurers wary of covering information loss liability.
The corporate response begins with combining physical and IT security to dramatically mitigate information risk and protect data stored in corporate databases.
“I heard Dr. Rakow’s presentation last summer and it was spellbinding.”
Roger Lux, President of Association of Information Technology Professionals (AITP), Los Angeles Chapter in his introduction of Rakow to the AITP chapter members
“Thank you for a most interesting, and as Roger put it, spellbinding presentation last night.”
Michael Berner, AITP chapter member
“…best presentation I have heard here in twenty years.”
Member of American Society of Industrial Security (ASIS) following Rakow’s presentation at a San Fernando Chapter meeting
Joel Rakow, Ed.D., Partner, leads Tatum’s eCrimes Practice. He has served as an advisor to the U.S. Secret Service, SSP Solutions (a security provider for communications between the White House and the Department and Defense), the Los Angeles Electronic Crimes Task Force and Adobe Software.
Dr. Rakow is on the IT Security Council for the American Society of Industrial Security (ASIS), the faculty of the Los Angeles Police Departments Law and Private Security Conference and a secure-access member of the FBI Infragard. He is a former Harvard University Postdoctoral Fellow and a National Science Foundation Fellow.
He founded and operated, for 17 years, a software company that sold over 3 million corporate licenses as an IBM Business Partner, Microsoft Solution Provider and McGraw-Hill licensor. He won PC World Magazine’s Product of the Year for three consecutive years, Microsoft’s Partner of the Year, 1999 and Microsoft Great Plains Implementation of the Year, 2001.
Dr. Rakow has implemented a number of software solutions in very secure organizations such as U.S. Senate, National Security Agency, Northrop Grumman and Bank Boston. He currently advises corporate executive on strategies for securing their critical assets and avoiding catastrophic legal liability.
Tatum Partners is a national professional services firm that provides financial and technical leadership at the executive level of sophisticated business organizations ranging in size from several hundred million dollars in annual revenue to $1 billion and up. Tatum has approximately 400 partners operating out of 30 major markets in the U.S.
High Performance SQL
How Super Computing Technology Is
Making Its Way to the Enterprise
Why TPC benchmarking for SQL has been so successful over the past year.
§ What hardware implementations have revolutionized Windows/Intel technology
§ Why SQL can beat DB2 on the mainframe.
Your data is a vital business asset. The volume of data you collect grows daily.
§ Are you prepared for this growth?
§ Is your database performance acceptable?
§ Can your total cost of ownership be significantly improved through server consolidation?
§ Do you fully leverage all of your data to maximize revenue opportunity?
Scott Schweitzer is NEC's Product Manager for their Itanium Server Family. Scott has been working professionally with computers since 1983 when he joined IBM Research in New York. There he helped internally launch the companies first RISC workstations and later managed both the AIX and OS/2 support teams.
He also co-developed the OS/2 installation from CDROM and led the team that developed the first Professional Developers Kit for OS/2, the predecessor to MSDN. In 1995 he moved to Silicon Valley and IBM's Storage Systems Division where he led the team that launched their first mobile platform & mobilized their entire sales force.
Starting in 1997 his team designed, built and rolled out the "IBM Edge" an extranet portal for OEM drive buyers that processed $2B in web orders in 1999 making it the second largest eBusiness application inside the company that year.
In 2000, Scott joined a startup as their Chief Deployment Architect charged with building a web infrastructure to support 15 million visitors an hour, which was completed in six months. Like all startups though they ran out of cash before they had sustainable revenue.
He then started as the Chief Architect for OldRepublic Title in 2002, a fortune 500 company, where he increased their online ordering volume 2000% in the first year resulting in an increased savings to the company of 3,800 man hours monthly. He architected their move to an all new Cisco network supporting six plant sites and 130 branch offices and began the roll-out of a Voice Over IP phone network.
Last summer he joined NEC to focus on 64bit computing and to help them launch their new Itanium server line in October.
Multiserver Job Administration with SQL Server 2000
SQL Server 2000 includes a multiserver job capability (called Multiserver Administration in Books Online). With it, it is possible to set up various tasks, such as a backup or maintenance plan jobs on one server (a Master), and have that task copied to, and run on multiple SQL Server machines (known as Targets). This can be a real time-saver for a DBA. This feature also conveniently allows the DBA to review all task and job status information from a single Enterprise Manager desktop.
Ron Landers demonstrated how to set up and configure multiserver administration, and how to create SQLAgent jobs that run on multiple SQL Server machines (instances).
Ronald Landers is the President and Senior Technical Consultant for IT Professionals, Inc., an IT development, recruiting, and staffing company based in Calabasas (http://www.goitpros.com). In additon to consulting, Ron has also taught for UCLA Extension for the past 12 years. Ron's current UCLA Extension classes include SQL Server 2000 (beginning and advanced), Building ASP.NET Applications and Web Services (beginning and advanced), and Object Oriented Programming Using Visual Basic .NET and C#. Ron has given several LADOTNET presentations over the past couple of years, and is a previous LADOTNET Webmaster. Ron can be reached via email at mailto:firstname.lastname@example.org
SQL Server Tables, Diagrams and Security
Alison Balter gave us for an insightful presentation: Many people are unaware of the details of working with SQL Server tables, database diagrams, and security. In this intermediate talk, we went beyond the basics, and explored the ins and outs of these three topics.
Alison Balter is a Microsoft Certified Solutions Developer, and a leading author of Microsoft Access books and .NET books, including Alison Balter's Mastering Access 2003 Development and Alison Balter's Mastering Database Development with .NET. She is a highly experienced developer and independent trainer. She develops applications using Visual Basic, Access, .NET and SQL Server. She specializes in teaching others how to develop Windows and Web applications. During her 20 years in the computer industry, she has trained and consulted many people in corporations and government agencies. Alison is featured in several training videos for Blast Through Learning, and can be reached at email@example.com.