DBA Fundamentals October 2017

What is coming up in this month, you ask?
You are asking, right?

Words: 781
Time to read: ~ 3.5 minutes

What’s On:

Some great content coming up in the DBA Fundamentals VG for the month of October with 3 different sessions from Edwin Sarmiento, Sunil Agarwal, and Ebru Ersan.

We will be giving away one more full PASS comp after Edwin Sarmiento’s session on October, the 3rd.

In order to win, first you need to be a member of PASS, and second you cannot have already registered for PASS summit. These are comps, not refunds 🙂

To be entered to win, attend the session and you’ll have your entry entered into the draw.

VC15GBQ6 for $150.00 off the cost of PASS Summit. The code still works, but our contest is over for the $500.00.

As always, you can hop on over to our website at dbafun.org to sign up for any of these and future sessions.

Sessions:

Edwin Sarmiento ( Blog | Twitter )

“Upgrade Strategies for Highly Available SQL Server Environments”

2017-10-03, 11:00 – 12:00

If you have high availability and disaster recovery solutions in place for your SQL Server instances, proper planning and considerations have to be made to upgrade to SQL Server 2016. In this session, we will look at high availability options in previous versions of SQL Server, including database mirroring, failover clustering, log shipping and replication. We will also learn how to upgrade to SQL Server 2016 with minimal downtime when SQL Server high availability and disaster recovery features are part of the existing configuration.

This session will focus on:

  • The considerations for performing an in-place upgrade versus a side-by-side migration
  • How to prepare for the upgrade in order be successful
  • How to upgrade to SQL Server 2016 with existing database mirroring, failover clustering, log shipping and Availability Group configuration
  • How to reduce your downtime and level of effort associated with upgrading SQL Server

Sunil Agarwal ( Twitter )

“Strategies to get maximum concurrency for your workload in SQL Server:”

2017-10-10, 12:30 – 13:30 Brisbane

Have you experienced slow down in your application because of blocking and wondered what you can do? This talk will cover the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity and deadlocks. We will follow thru this with  diagnosing and troubleshooting the blocking issues and will conclude with general guidelines in designing application(s) for maximum concurrency.Have you experienced slow down in your application because of blocking and wondered what you can do? This talk will cover the basics of concurrency starting with isolation levels including RCSI and snapshot isolation levels, lock escalation, locking granularity and deadlocks. We will follow thru this with  diagnosing and troubleshooting the blocking issues and will conclude with general guidelines in designing application(s) for maximum concurrency.

Session Goals:

  1. Overview of blocking and concurrency in SQL Server. This is more of refresher to bring everyone on the same page.
  2. Use demos to show blocking including lock escalation and steps you can do minimize or eliminate blocking without any changes in the application.
  3. Use demos to show deadlocks and waits induced thru page latches and show how to monitor and troubleshoot.

Ebru Ersan

“Comprehensive Guide for Monitoring SQL Server and Azure SQL DB”

2017-10-17, 11:00 – 12:00

One of the most popular workloads in the world, MS SQL Server, is bigger than the on-premise database engine for Windows datacenter. Now we also have Azure SQL DB – robust and scalable cloud-hosted database and SQL Server on Linux which eliminates boundaries between Windows and Linux datacenters. We want to show you the most exciting and compelling ways to get all these scenarios monitored using SCOM, OMS, SQL Best Practice Analyzer, and other tools.
You will learn how to:

  • Monitor MSSQL Server with SCOM, OMS SQL BP Analyzer
  • Configure SCOM to monitor on premise SQL Server and Azure SQL DB
  • Use SCOM to monitor SQL Server on Linux

Other Items.

We’ve mentioned it before in a few webinars about looking for another volunteer for the DBA Fundamentals VG, and we’ve had some interest from people already. However, in the interest of fairness and to try and include as many people as possible, we’re keeping the call for volunteers open a bit longer. So don’t be scared, sign up, and find out how much you learn from volunteering as well as attending the webinars.

We’re continuing work on getting a list of past presenters up on our website. It’s a slow, deliberate progress but it’s ongoing.
You can check it out here: Past Presenters
If you have any suggestions, please don’t be afraid to let us know.

We’ve created a Group on LinkedIn as another way to spread the information and as a platform for knowledge sharing. Check it out and let us know a). if you like it, and/or b). how you think it can be improved.
We are always open to suggestions.

Apart from that, anything you want to get in touch about, hit us up on Slack or Twitter.

Enjoy October everyone!

Author: Shane O'Neill

DBA, T-SQL and PowerShell admirer, Food, Coffee, Whiskey (not necessarily in that order)...

What's your opinion?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s