1 / 15

Understanding Computer Networking: Types, Hardware and SQL Server Insights

This article provides an overview of computer networks, including definitions and common types like Fast Ethernet, Gigabit Ethernet, and wireless technologies. It explains different networking types such as Peer-to-Peer and Client/Server, emphasizing the significance of hardware components like switches, hubs, and routers. Key considerations for networking hardware include reliability, fault tolerance, security, and performance. The article also discusses SQL Server best practices, licensing, and terminal services, offering recommendations for maintaining effective and secure networking environments.

shaina
Télécharger la présentation

Understanding Computer Networking: Types, Hardware and SQL Server Insights

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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?

More Related