Aug-2014 ~ SQL Server Statistics: The Secret Sauce ~ Tim Harkin

Posted by admin

tim_harkinPresenter: Tim Harkin
Topic: SQL Server Statistics: The Secret Sauce

Learning how to write a query is a basic SQL skill. Eventually, a curious developer wants to know how SQL actually returns the data. Statistics are the “secret sauce” that SQL uses to create a query plan to get your data. In this session, the basics of how SQL creates and maintains statistics will be discussed, and the impact that the this has on query plans. Other topics covered will be what happens when statistics are wrong (and how that can happen), as well as when to take statistics maintenance into your own hands.

Biography:

Tim Harkin has been working with SQL since SQL 2000 and has worked in a variety of database environments from multi-terabyte data warehouses to high volume OLTP applications and everything in between. Tim also helps run the Fairfield\Westchester SQL Server User Group. Currently he is the Senior DBA for Toluna, USA, a pioneer in the dynamic world of market research, data collection, reporting and visualization.

Jul-2013 ~ What are you waiting for? ~ Jason Strate

Posted by admin

 

Presenter: Jason Strate
Topic: What are you waiting for?
Presentation Materials

Abstract:

You’ve spent the afternoon sweating over your T-SQL query. You’ve wrung out all of the wrinkles. It’s deployed, it’s running… now its waiting. In SQL Server the most performant query can become a problem query if there aren’t any resources in the SQL Server for it to use. In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them.

Biography:

Jason Strate is database architect with Pragmatic Works. He has been working with SQL Server for more fifteen years. His technical focuses includes administration and development of OLTP environments. Jason is a recipient of the Microsoft Most Valuable Professional (MVP) Award for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008 and 2012.

Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings. Jason is an active blogger with a focus on SQL Server and related technologies.