About The Course

The main benefits of SQL Server over Access are improved reliability, better performance, reduced network traffic and increased scalability. Drawbacks are an increased deployment cost and a more complex support environment. For small workgroups of up to a dozen users on a Local Area Network with modest data requirements (no more than 50,000 records) and without ultra-high reliability requirements then Access is probably your best bet. Outside of these parameters you should probably look to a client/server solution such as SQL Server.

COURSE FEATURES:

  1. Extending Data Compression in SQL Server 2008 with Fixed Length Data Types
  2. Hot Add CPU and Hot Add Memory
  3. Extending Data Compression in SQL Server 2008 with Fixed Length Data Types
  4. Backup Compressions
  5. Policy-Based Management
  6. Performance Data Collector
  7. Data Auditing
  8. SQL Server Extended Events
  9. Streamlined installations
  10. Backup Compressions
  11. Resource Governor
  12. Policy-Based Management

Course Content:

  1. Reliability
  2. Data Integrity
  3. Performance
  4. Network Traffic
  5. Low Bandwidth
  6. Scalability
  7. Wireless LAN
  8. WAN

SOME OF OUR CLIENTS