SQL Saturday Jacksonville

SQL Saturday #298 Jacksonville

Registration link:

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held May 10, 2014 at Jacksonville, FL.

Admittance to this event is free, all costs are covered by donations and sponsorship. Please register soon as seating is limited, and let friends and colleagues know about the event. Why: It is a great opportunity to learn from Microsoft MVPs, SQL Server authors, and professionals who have been through and can relate to the obstacles you have day to day. This one day training event is unlike any other providing free food, training and networking.

When: Saturday, May 10, 2014

Online registration is open now, but it is filling up fast so reserve your spot now. Let your friends and colleagues know about the event as well! Attendee check-in will begin at 8:00 am until 8:45 am with the first session beginning at 9:00 am. A full list of session tracks will be available soon but in the meantime, please suggest a session you'd like to see!

University of North Florida Campus, Main Campus
1 UNF Drive, Jacksonville, FL 32224

Building 50

Campus Map Link: http://www.unf.edu/map/

Cost: FREE!!!

Registration link:

SQL Saturday Performance Tuning Precon (Friday May 9, 2014)

Hello Dear Potential Attendee! Welcome to your opportunity to learn all about SQL Server! Come join SQL MVP Jorge Segarra and SQL Server DBA Bradley Ball for a full day of Performance Tuning. There is a lot to cover and a lot to learn.

Congratulations! You’ve got a Server – The first thing that you have to learn in Troubleshooting is how to ask the questions. We have two types of systems we will maintain. Those we see every day and those we have just discovered because of a problem thats been brought to our attention. There are questions we ask every day when we have the luxury of time and there are questions we ask quickly to figure out what’s going on. • Topics Covered: Baselines, Waits and Queues, Extended Events, Error Logs, DMV’s

Configuration & Best Practices
As Consultants a lot of the problems that we see are caused because the system has not been configured properly. There are things to configure for the Hardware, things to configure for the OS, things to configure AFTER you’ve installed SQL Server. We’ll discuss not just how you should set things, but why!

Topics Covered: Hardware (CPU, Memory, Physical Disk), Pre Configuration Checklist (Instant Database File Initialization, Service Account rights, OS Patching, Power Configuration), Post Configuration Checklist (Tempdb, Max Memory, Max DOP, Affinity, NUMA, Trace Flags).

Indexes, the Optimizer, and the Plan Cache
When it comes to making your queries run you need to understand how SQL Server reads a query and how the Optimizer works and return our physical data. Physical data is stored in structures such as tables and indexes, and understanding how to structure tables and indexes to work with our queries is critical. But what ties the Optimizer to the physical structures is the query plan. To find the query plan we’ll dive into the plan cache and cover query tuning from A to Z.

Topics Covered: Query Optimizer, Indexes, Page Splits, Plan Cache, Execution Plans and operators.

Locking, Blocking, Deadlocks, Latches, and Spinlocks
This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a few users, or if you have a large multi-tenant system you have Locking, Blocking, Latches, and Spinlocks. Understanding what they are and how they work is the first step in understanding how to troubleshoot them. Deadlocks are a problem, but they are a problem we can fix. In this module we will explain and investigate how to find and fix the problems that we see in our database every day.

Topics Covered: Locking, Blocking, Deadlocks, Latches, and Spinlocks.

When: Friday May 9, 2014
Where: University of North Florida Campus, Main Campus, 1 UNF Drive, Jacksonville, FL 32224. Building 50 Cost: Early Bird $99 (Until 4/9/2014)
Regular Price $129

Join or login to comment.

  • Irv A.

    Well planned and executed, organized and informative. Thank you!

    May 12, 2014

  • John G.

    Has anyone attended one of these SQL Saturday events. Often anything advertised as free is a bait and switch. What is the signal to noise ratio like at these events?

    May 8, 2014

    • Jeff T.

      I know several people who attend any of these events which are close enough to drive to. I know some of the presenters, and have been to other events by the hosts, so it should be good...

      1 · May 8, 2014

    • Jared W.

      I have been to Jax SQL Saturday every year for the last several years, and it is always completely free.

      May 8, 2014

  • Brian K.

    Don't forget to register at http://sqlsaturday.com/298/register.aspx instead of the MeetUp Button on the site.

    1 · April 16, 2014

  • Wayne

    Great stuff thanks for posting

    April 8, 2014

Our Sponsors

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy