Date: Tuesday, July 28th, 2015
Time: 6pm – 8pm (Eastern Daylight Time)
Location: Dynamic Quest HQ, 4821 Koger Blvd, Greensboro, North Carolina
Scott Fallen Presents Getting Started With Execution Plans
Speaker: Scott Fallen, Sales Engineer SQL Sentry, LLC
Summary: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.
About Scott: Scott Fallen is a member of the Sales Engineering team at SQL Sentry, makers of the award winning Performance Advisor and Event Manager monitoring tools. In this role, he teaches customers and evaluators how to utilize SQL Sentry’s tools to monitor and improve the performance of their SQL Servers.
TSSUG is a forum for Microsoft SQL Server database administrators and developers. Our goal is to provide a forum to meet similar individuals, learn about the product, and share ideas. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Servers. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Pizza and drinks are provided.
40% of businesses will incorporate the anywhere operations model to accommodate the physical and digital experiences of both customers and employees (Techvera).
The average cost of a data breach in the United States is $8.64 million, which is the highest in the world, while the most expensive sector for data breach costs is the healthcare industry, with an average of $7.13 million (IBM).
The cost of cybercrime is predicted to hit $10.5 trillion by 2025, according to the latest version of the Cisco/Cybersecurity Ventures “2022 Cybersecurity Almanac.”.
Forty-three percent of attacks are aimed at SMBs, but only 14% are prepared to defend themselves (Accenture).
More than 33 billion records will be stolen by cybercriminals by 2023, an increase of 175% from 2018.
The internal team was energized. With the Level 1 work off its plate, the team turned its attention to the work that fueled company growth and gave them job satisfaction.
It takes an average of 287 days for security teams to identify and contain a data breach, according to the “Cost of a Data Breach 2021” report released by IBM and Ponemon Institute.
The three sectors with the biggest spending on cybersecurity are banking, manufacturing, and the central/federal government, accounting for 30% of overall spending (IDC).
We did a proof of concept that met every requirement that our customer might have. In fact, we saw a substantial improvement.
We did everything that we needed to do, financially speaking. We got our invoices out to customers, we deposited checks, all the things we needed to do to keep our business running, and our customers had no idea about the tragedy. It didn’t impact them at all.
“We believe our success is due to the strength of our team, the breadth of our services, our flexibility in responding to clients, and our focus on strategic support.”