HUG User Conference

1
Session VII
Networking, Hardware Issues, SQL Server and
Terminal Services
2

• What is a computer network ?

3
Computer Network A group of two or more
computers linked together electronically.
4
Common Types of Networks

• Fast Ethernet
• Gigabit Ethernet
• Wireless B
• Wireless G

5

• Fast Ethernet

• 100mbit Data Packet Transfer
• Requires Fast Ethernet Network Adapters and
  Switches
• Most common type of network

6
Gigabit Ethernet

• 1000mbit data packet transfer
• Requires Gigabit Network Adapters and Switches
• Gaining popularity with affordability

7
Wireless

• 802.11B Capable of 11mbit Data Transfer
• 802.11G capable of 54mbit or 108mbit
• No Wires!!
• Ad-Hoc / Access Point
• Network Bridge to Wired Network
• Data Encryption Recommended

8
Types of Networking

• Peer to Peer
• Workstations linked to other workstations
• Share resources to create network devices
• Basic security of password protection
• Client / Server
• Workstations linked to dedicated servers
• More advanced networking capabilities
• Enhanced security of Active Directory
• More versatile and capable of higher production

9
Networking Hardware

• Switches / Hubs / Routers
• Desktop / Server Network Adapters
• Network Operating System Software
• Mass Storage Media
• Back Up System
• Fault Tolerant Devices
• Security Components

10
Hardware Issues

• Redundancy
• Server hard drives (RAID)
• Scanners
• Any other mission critical pieces?
• How long can you afford to be down?

11
Most Important Considerations

• Reliability
• Fault Tolerance
• Security
• Speed / Performance
• Usability
• Scalable
• Adaptability

12
Recommendations

• Implement and upgrade to the latest hardware
  devices
• Implement and upgrade to the latest software
  versions
• Maintain comprehensive documentation
• Implement and test effective backup solution
• Utilize qualified support individuals
• Evaluate needs annually

13
SQL Server

• Latest Service Packs
• SQL 2000 SP3a
• SQL 7 SP4
• Microsoft Free Tools
• Microsoft Baseline Security Analyzer 1.2.1 (MBSA)
  
• Best Practices Analyzer Tool for MS SQL Server
  2000 1.0
• SQL Server 2005 coming next summer

14
Terminal Services

• Ports needed for access tcp/3389
• Licensing Issues
• Windows 2003 Server
• Small Business Server
• Terminal Server
• Other issues

15
Questions?