Compartir a través de

IT-Talks - March 29: The art of SQL server deployment

  • Artículo

Do you want to learn how to install a perfect slick running SQL server our next event’s a must attend as we have two specialist from the SQL server user group that will spend a whole day showing and training us in the art of SQL server deployment”.

Event Name: The art of SQL server deployment
Where: Spes Nostra - Koning Albertstraat 50 - 8520 Kuurne
When: Saturday March 29th - 9:30 - 17:00

Program:

  • 10u00: welcome + boot labs
  • 10u30 – 11u30: install cluster + overview SQL server (Peter De Seranno - SQLUG.be / conSuRAN and Philippe Bauters )
  • 11u30 – 11u45: coffee and talks
  • 11u45 – 13u00: Databases - Backup/restore (Peter De Seranno - SQLUG.be / conSuRAN and Philippe Bauters )
  • 13u00 – 14u00: Lunch
  • 14u00 – 15u15: Security - High Availability (Peter De Seranno - SQLUG.be / conSuRAN and Philippe Bauters )
  • 15u15 – 15u30: coffee and talks
  • 15u30 – 17u30: client connectivity (Peter De Seranno - SQLUG.be / conSuRAN and Philippe Bauters )

Topics of the day:

  • installation cluster
  • Overview SQL Server:
    • Components, editions and versions
  • Databases:
    • Files, raid-sets, recovery models
    • Hands-on: create database, watch for important settings
  • Backup/restore:
    • Full, log, differential
    • Hands-on: restore point in time
  • Security:
    • Services, SQL server, database, roles, …
    • Hands-on: playing with roles
  • High Availability:
    • Clustering
    • DB-Mirroring
    • Logshipping
    • Others
  • Client connectivity
    • ODBC, OLEDB, native SQL client
    • Protocols
    • Hands-on: connectivity tools

You must register for this event in advance by mail to tom@decaluwe.eu, places are limited so be fast to register!

Technorati Tags: SQL Server,SQLU.BE,IT-Talks,Community,Usergroup