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, Mar 21 2013 12:00 Central Daylight Time


Steve Hughes Accounting for Windows Azure

RSVP: http://DataArch.SQLPass.org

Accounting for Windows Azure in Your Data Architecture As Windows Azure becomes a more significant part of the IT landscape, data architects need to understand the data technologies at their disposal. Not all data can nor should be stored in the relational database in Azure. The discussion will include the various storage types available for data in Azure and how they may fit into an architecture. Learn which data storage techniques may work best for your next project with Azure and some of the nuances of using each type within a project. Bio: Steve Hughes is a Practice Lead at Magenic. He works with Microsoft’s SQL Server stack to deliver data and business intelligence solutions. He has been working with technology for over 15 years with much of that time spent on creating business intelligence solutions including multidimensional databases, reporting solutions, and data marts. He is passionate about using data effectively and helping customers understand that data is valuable and profitable. Steve also has experience working with a large Software as a Service vendor where he received awards for customer satisfaction and engineering excellence. Steve believes the data in the cloud will change how information can be delivered to and consumed by the masses. He also provides insights from the field on his blog at http://www.dataonwheels.com. Steve been on the leadership team of the Minnesota SQL Server User Group (PASSMN) for the past 3 years and is currently a PASS Regional Mentor for the Northeast.

Accounting for Windows Azure in Your Data Architecture

As Windows Azure becomes a more significant part of the IT landscape, data architects need to understand the data technologies at their disposal. Not all data can nor should be stored in the relational database in Azure. The discussion will include the various storage types available for data in Azure and how they may fit into an architecture. Learn which data storage techniques may work best for your next project with Azure and some of the nuances of using each type within a project.


Steve Hughes is an Principle Consultant at Pragmatic Works. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered multiple presentations on SQL Server and data architecture over the past six years.

 

 

John Sterrett

December 13th 2016 1 PM CDT

Table Partitioning: Secret Weapon for Big Data Problems

Is big data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks.

Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

GotoWebinar Link https://attendee.gotowebinar.com/register/5269012927428510724

Bryan Cafferky

SQL Server 2016 R Intergration

Jan 18, 2107, 1 PM CDT

About Bryan Cafferky...

 

Bryan is a 2016 MVP award winner and author of Pro PowerShell for Database Developers by Apress. He is an independent Business Intelligence/Data Science consultant with decades of experience in information technology focused on the Microsoft stack. Bryan has spoken on a number of subjects at various PASS chapters, Code Camps, and SQL Saturdays. He has worked in banking, insurance, Internet/Ecommerce, utilities, and health care. Bryan holds an undergraduate degree in Computer Information Systems from Bryant University and a Masters in Business Administration from Bentley University.

GotoWebinar Link

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

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