Past Meetup

2017-10: SQL Server for Windows Administrators - tweaks (Basel)

This Meetup is past

7 people went

GAIA Hotel

Centralbahnstrasse 13-15 · Basel

How to find us

The GAIA HOTEL is located opposite the SBB main railway station. Discounted parking is available in the Centralbahnstrasse public car park with over 400 lots.

Details

SQL Server for Windows Administrators - tweaks Vedran Kesegic

How do you install SQL Server for optimal performance, for Windows Administrators and „accidental“ DBAs.

We will go through hardware selection, on what to spend more money and where we can save the money. How to configure OS and storage system to leverage the system abilities to their maximum, with the accent on SQL Server-specific workload.

Tweaks in installation and configuration of SQL Server and database settings for optimal performance.

You will see some of the tricks used by experienced professionals to make SQL Server run fast on SQL Server 2016 & 2017 on Windows 2016, but most of it can be applied to previous versions as well (Windows & SQL Server 2008 upwards).

Agenda

15:45 - 16:00 : Arrival and Registration
16:00 - 17:15 : SQL Server for Windows Administrators - tweaks
17:15 - 17:30 : Coffee Break
17:30 - 18:45 : Encryption in SQL Server
18:45 - 19:15 : Q&A and Quiz