6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting
HiHo! HiHo! SQL Server on Linux, we go!
Are you being forced to the ‘Cloud’ to reduce costs? SQL Server 2017 now runs on Windows, Linux, and Docker containers.
Now SQL Server can be installed on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. This presentation will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on different Linux distributions and Docker will be shown, as well as best practice considerations for production/development environments. Also, several useful Linux commands for monitoring, managing and backing up SQL Server will be demonstrated. Finally, client connectivity and tools will be discussed – plus the new Azure Data Studio UI with the ability to add monitoring widgets will be demonstrated.
Janis has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software,
Janis primarily worked in the Telecom/Network Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Simplify Database Performance and Management
Database management is complex. Database professionals are increasingly being asked to manage not only larger numbers of database instances, but multiple database platforms. Open source and NoSQL databases along with cloud adoption are all having a major impact, and DBAs are now expected to ensure the best performance and stability of this cross-platform database environment.
But what if you could meet growing demands faster and with less risk? This means you’d get more time to innovate and focus on important projects. In this session, you’ll learn how to proactively manage all your database platforms from end to end.
Items of discussion include:
· Scoring optimal availability and performance out of Enterprise and Standard edition databases
· Managing hundreds of database instances with ease
· Maintaining databases both on-premises and in the cloud
· Decreasing overhead by managing databases with little to no impact on performance
Alfred is Account Manager covering the Pacific Northwest. Responsible for our market leading database performance and diagnostic solutions, Foglight & Spotlight as well as our SQL Server specific backup/restore solution, LiteSpeed.
Refreshments graciously provided by ServerLogic.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.