The PASS Data Architecture Virtual Chapter focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.
Meeting Detail

Thu, Dec 19 2013 12:00 (UTC-06:00) Central Time (US & Canada)


Nigel Sammy - T-SQL: Tips and Tricks

RSVP: https://attendee.gotowebinar.com/register/5187602867480253442

Nigel Sammy - T-SQL: Tips and Tricks https://attendee.gotowebinar.com/register/5187602867480253442 Queries are running longer than expected? Your database server isn't performing as well as it should? There are many reason that this could be happening and one of them is the T-SQL being executed on the system. T-SQL offers various ways to get the information that you need but sometimes the option you choose might return the data that you want but may not be the best query structure or logic to use. This session will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. It will also show you some tips and tricks to avoid some bad T-SQL coding habits and help you write better queries. This session is for Developers and Database Administrators. About Nigel Sammy Nigel Sammy is a Microsoft SQL Server MVP with over a decade of technical experience and over eight years database and SQL Server experience. He's progressed through several roles in his career including Lecturer, Developer, Analyst, Database Administrator/Developer, Project Manager, Architect, Team Lead and Manager. He's the founder and current chapter leader of the Trinidad and Tobago SQL Server User Group (TTSSUG) and is also the chapter leader of the PASS Azure Virtual Chapter.

 

 

Why Physical Database Design Matters

Feb 9, 2107, 1 PM CDT

By Kimberly L. Tripp

KIMBERLY L. TRIPP

SQLskills.com

President/Founder

Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.

Email: Kimberly@SQLskills.com

Website: http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/

Blog: http://www.SQLskills.com/blogs/Kimberly

Twitter: http://twitter.com/KimberlyLTripp

SQL Server MVP since 2002

GotoWebinar Link

https://attendee.gotowebinar.com/register/7880420115776213508

 

How to Get Started Tuning SQL Server Performance

 

Tuesday , March 14, 2016 1 PM CDT

 

By Tim Radney

 

Figuring out how to get started tuning SQL Server performance can feel overwhelming at first. Where do you start? What should you look at? In this session you'll learn a systematic approach to tuning SQL Server. First we'll cover common instance level settings that can have a significant impact on SQL Server performance. Then we'll cover how to collect I/O metrics and pinpoint databases that have the highest latencies plus how to collect and understand wait statistics. Finally, we'll cover how to find high-cost queries and discuss the importance of having a good baseline to measure all these things against. If you've been struggling to put together a performance-tuning process, this session is for you!

Tim Radney

SQLskills.com

Principal Consultant

 

Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.


Email:
Tim@SQLskills.com
Website:
http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/tim-radney/
Blog:
http://www.SQLskills.com/blogs/tim
Twitter:
http://twitter.com/TRadney
Microsoft
MVPsince 2014

 

GotoWebinar Link

https://attendee.gotowebinar.com/register/205069192578339332

 

Data Architecture Virtual Chapter

thanks our new sponsor NUTANIX

http://bit.ly/sqlonnutanix

 

Data Architecture underpins just about everything we do in IT. Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it. Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional. Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.

The PASS Data Architecture Virtual Chapter will focus on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform. We want to make data architecture accessible to all data practitioners, and drive the point home that Data Architecture is a set of practices and a body of knowledge that overlaps almost all database professionals to some degree.

Email us at rob@sqltigers.com or twitter is @DArchVC