Hi all
I am currently in the process of starting up at consultancy within the data Engineering / Architecture and Business Intelligence area. One leg of my invisioned business would be training in the use of SQL Server, and excel, for analytics staff in larger companies.
I would like to build a small server for training purposes (Think 10-20 people in a room learning to use some software)
Looking for a bit of advise on the software installed on this server.
My hardware is a ryzen 5 3600x machine running 16 gb RAM and 500gb SDD
Software requirements
Users will access data using windows PC's through SQL Server Management Studio and Excel/Power BI respectively.
I am in the process of figuring out what I need to install on my server in order to allow users to access it through VPN and query data on an SQL Server using LDAP (Since I will be creating individual databases and linking these to LDAP user profiles that I generate before training sessions .
I am currently in the process of starting up at consultancy within the data Engineering / Architecture and Business Intelligence area. One leg of my invisioned business would be training in the use of SQL Server, and excel, for analytics staff in larger companies.
I would like to build a small server for training purposes (Think 10-20 people in a room learning to use some software)
Looking for a bit of advise on the software installed on this server.
My hardware is a ryzen 5 3600x machine running 16 gb RAM and 500gb SDD
Software requirements
- Preferably Ubuntu
- MS SQL Server including Adventureworks database
- VPN to allow users to access my server from outside of my network
- This would probably be through my router
- LDAP in order for me to create users before training start
- Software firewall?
- Backup features?
- Hypervisor / Virtual machines / Containers?
Users will access data using windows PC's through SQL Server Management Studio and Excel/Power BI respectively.
I am in the process of figuring out what I need to install on my server in order to allow users to access it through VPN and query data on an SQL Server using LDAP (Since I will be creating individual databases and linking these to LDAP user profiles that I generate before training sessions .