Viewing 0 current events matching “sqlserver” by Date.

Sort By: Date Event Name, Location , Default
No events were found.

Viewing 4 past events matching “sqlserver” by Date.

Sort By: Date Event Name, Location , Default
Wednesday
Nov 13, 2019
OregonSQL - November Meeting - HiHo! HiHo! SQL Server on Linux, we go!
OHSU

Janis Griffin

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.

Alfred Burnett

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

Website
Wednesday
Jul 8, 2020
Oregon Data Community - July 8th Meeting
https://register.gotowebinar.com/register/1043102691190981391

Michael Wall Polybase – It’s What’s for Dinner

Polybase is Microsoft’s great new replacement to linked servers. With the current version in SQL Server 2019, one can connect to multiple data sources such as Teradata, Apache, Hadoop, Oracle, and many many more. We will review best practices for setting up Polybase and its Scale-Out groups as well as showing how it interacts in an AlwaysOn Availabilty Group. When Scaling-Out (up!), Polybase is able to work harder and deliver more data. What happens when one of its node disappears? We will have a live demo demonstrating how to manage the Scale-Out group when bad things happen. In addition, the DMVs for managing Polybase will be reviewed, and finally, there will be results of the impact of using multiple nodes in the Scale-Out group on the Polybase queries!

Website
Wednesday
Aug 12, 2020
Oregon Data Community - Potluck Night!!
Virtual Event - https://register.gotowebinar.com/register/3677754653419920656

Please come join us next Wednesday night at 1830 HRS PST for an all-star lineup of speakers on a variety of topics including #DeveloperAdvocacy (Tim Combs), #communityorganizing (Joe Dunn), #powerbi (Paul Turley), #AzureDataStudio (Jody Pilsworth), and #SQLServer #hardware (Glenn Berry)!

It's going to be a fun night! Come register at:

https://register.gotowebinar.com/register/3677754653419920656

Website
Wednesday
Oct 14, 2020
Oregon Data Community - New Features in SQL Server 2019
Virtual Event - https://register.gotowebinar.com/register/8620248537628761355

Are you having trouble keeping up with all the new releases of SQL Server? Don’t you feel like you’ve just completed a great milestone in upgrading all your instances to SQL Server 2017 – only to find out that you are behind again? ☹ If so, this session will help you quickly get up to speed in all the new features of SQL Server 2019. The topics that will covered are Intelligent Query Processing and how it works; new security and compliance features and how they can help; and an introduction to big data clusters and high availability for complete database transparency within your organization. This session is a must see for all DBAs.

Janis Griffin 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, 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.

Website