SQLSaturday #733 – Atlanta 2018

SQLSaturday #733 - Atlanta 2018

UpSearch at SQLSaturday #733

UpSearch proudly supported PASS SQLSaturday #733 – Atlanta 2018. The event was held May 19, 2018 at Gwinnett Technical College, 2875 Old Milton Pkwy, Atlanta, Georgia, 30009.

Presentations

The UpSearch team supported SQLSaturday #733 – Atlanta 2018 by presenting:

Targeting Wait Statistics with Extended Events and DMVs by David Maxwell.

SQLSaturday #733 - Atlanta 2018

 

Thank you to the Atlanta MDF (SQL Server User Group) for hosting SQLSaturday #733 – Atlanta 2018. If you live in the Atlanta, GA area, consider getting involved with Atlanta MDF (t).

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

SQLSaturday #724 – Madison 2018

SQLSaturday #724 - Madison 2018

UpSearch at SQLSaturday #724

UpSearch proudly supported PASS SQLSaturday #724 – Madison 2018. The event was held April 7, 2018 at The Pyle Center, University of Wisconsin-Extension, 702 Langdon Street, Madison, Wisconsin, 53706.

Presentations

The UpSearch team supported SQLSaturday #724 – Madison 2018 by presenting:

Targeting Wait Statistics with Extended Events and DMVs by David Maxwell.

SQLSaturday #724 - Madison 2018

 

Thank you to FoxPASS, MADPASS, Western Wisconsin PASS, WausauPASS  and WI SSUG for hosting SQLSaturday #724 – Madison 2018. If you live in the Madison, WI area, consider getting involved with FoxPASS (t), MADPASS (t), Western Wisconsin PASSWausauPASS (t) or WI SSUG.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

SQLSaturday #719 – Chicago 2018

SQLSaturday #719 - Chicago 2018

UpSearch at SQLSaturday #719

UpSearch proudly supported PASS SQLSaturday #719 – Chicago 2018. The event was held March 17, 2018 at Benedictine University, 700 College Rd, Lisle, Illinois, 60532.

Presentations

The UpSearch team supported SQLSaturday #719 – Chicago 2018 by presenting:

Understanding and Handling Database Corruption by David Maxwell.

SQLSaturday #719 - Chicago 2018

 

Thank you to the Chicago SQL Server User Group, Chicago SQL BI User Group and Chicago Suburban SQL Server User Group for hosting SQLSaturday #719 – Chicago 2018. If you live in the Greater Chicago, IL area, consider getting involved with the Chicago SQL Server User Group (t), Chicago SQL BI User Group or Chicago Suburban SQL Server User Group.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

SQLSaturday #708 – Cleveland 2018

SQLSaturday #708 - Cleveland 2018

UpSearch at SQLSaturday #708

UpSearch proudly supported PASS SQLSaturday #708 – Cleveland 2018. The event was held February 3, 2018 at Hyland Software, 28500 Clemens Rd., Cleveland, Ohio, 44145.

Presentations

The UpSearch team supported SQLSaturday #708 – Cleveland 2018 by presenting:

Targeting Wait Statistics with Extended Events and DMVs by David Maxwell.

SQLSaturday #708 - Cleveland 2018

 

Thank you to Ohio North SQL Server User Group for hosting SQLSaturday #708 – Cleveland 2018. If you live in the Greater Cleveland, OH area, consider getting involved with the Ohio North SQL Server User Group (t).

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLSaturday #698 – Nashville 2018

SQLSaturday #698 - Nashville 2018

UpSearch at SQLSaturday #698

UpSearch proudly supported PASS SQLSaturday #698 – Nashville 2018. The event was held January 13, 2018 at Middle Tennessee State University, 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132.

Presentations

The UpSearch team supported SQLSaturday #698 – Nashville 2018 by presenting:

Working with Temporal Data in SQL Server by David Maxwell.

SQLSaturday #698 - Nashville 2018

 

Thank you to the Nashville SQL Server User Group and Nashville BI User Group for hosting SQLSaturday #698 – Nashville 2018. If you live in the Greater Nashville, TN area, consider getting involved with the Nashville SQL Server User Group (t) or Nashville BI User Group (t).

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


PASS Summit 2017

 

PASS Summit 2017

 

UpSearch at PASS Summit 2017

UpSearch’s David Maxwell proudly supported PASS Summit 2017. The event was held October 31-November 3, 2017 at the Washington State Trade Center, 705 Pike St., Seattle, WA 98101.

 

Presentations

To learn more about David Maxwell’s Understanding and Handling Database Corruption presentation at PASS Summit, visit the session details.

Understanding and Handling Database Corruption by David Maxwell

PASS Summit 2017

To learn more about David Maxwell’s Targeting Wait Statistics with Extended Events and DMVs presentation at PASS Summit, visit the session details.

Targeting Wait Statistics with Extended Events and DMVs by David Maxwell

PASS Summit 2017

About PASS

PASS Summit 2017 - A SQL Server Conference

PASS (t) is a not-for-profit organization run by and for the community. PASS supports data professionals throughout the world who use the Microsoft data platform.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


Targeting Wait Statistics with Extended Events and DMVs

 

About the Presentation

SQL Server Wait Statistics - The Top 5 Waits You Should KnowWait statistics are a great tool for troubleshooting performance tuning problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don’t know where to look next. In this session, we’ll examine 5 of the most frequently seen SQL Server wait statistics and how to troubleshoot each of them. You’ll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with SQL Server wait statistics.

Session Level: 300

Download Presentation

Targeting Wait Statistics with Extended Events and DMVs

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Performance Tuning?

If you'd like to learn more about how UpSearch can support your SQL Server performance tuning initiative, visit SQL Server Performance Tuning or contact us today.

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

David Maxwell Named Principal Consultant

We are pleased to announce David Maxwell has been promoted to Principal Consultant.

“David has been an outstanding team member and driving force behind UpSearch’s Remote DBA Service,” stated Shawn Upchurch, Founder & CEO of UpSearch. “He regularly earns client praise for his ability to scope complex projects, serve as a resident subject matter expert, and effectively engage in executive-level technology decision maker discussions.”

David has also been extremely willing to support UpSearch’s strategic partnerships and Microsoft Partner enablement efforts.

 

About David Maxwell

David Maxwell Named Principal Consultant

In 2016, David became a Charter Member of Microsoft’s Certified Solutions Expert: Data Management and Analytics. He is a frequent presenter at local and national Professional Association for SQL Server (PASS) events, including the PASS Summit. David serves on the Columbus PASS chapter board and blogs at https://dmmaxwell.wordpress.com.

“We recognize David for his unique combination of technical know-how, presence, and professionalism,” stated Shawn Upchurch.

Learn more about David Maxwell here.

Shawn Upchurch,
Founder & CEO

Congratulations David!

Fun Facts

David will make two presentations at PASS Summit 2017:

 

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

SQLSaturday #680 – Kansas City 2017

SQLSaturday #680 - Kansas City 2017

UpSearch at SQLSaturday #680

UpSearch proudly supported PASS SQLSaturday #680 – Kansas City 2017. The event was held October 7, 2017 at Rockhurst University, 100 Rockhurst Road, Kansas City, Missouri, 64110.

Presentations

The UpSearch team supported SQLSaturday #680 – Kansas City 2017 by presenting:

Working with Temporal Data in SQL Server by David Maxwell.

SQLSaturday #680 - Kansas City 2017

 

Thank you to the Kansas City SQL Server User Group for hosting SQLSaturday #680 – Kansas City 2017. If you live in the Greater Kansas City, MO area, consider getting involved with Kansas City SQL Server User Group.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLSaturday #629 – Indianapolis 2017

SQLSaturday #629 - Indianapolis 2017

UpSearch at SQLSaturday #629

UpSearch proudly supported PASS SQLSaturday #629 – Indianapolis 2017. The event was held August 12, 2017 at Ivy Tech Noblesville, 300 N 17th St, Noblesville, Indiana, 46060.

Presentations

The UpSearch team supported SQLSaturday #629 – Indianapolis 2017 by presenting:

Introduction to Database Administration by David Maxwell.

SQLSaturday #629 - Indianapolis 2017

Handling Temporal Data in SQL Server 2016 by David Maxwell.

SQLSaturday #629 - Indianapolis 2017

 

Thank you to IndyPASS for hosting SQLSaturday #629 – Indianapolis 2017. If you live in the Greater Indianapolis, IN area, consider getting involved with IndyPASS (t).

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.