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

Thomas Leblanc May 18, 2016 Noon CST

 

Getting Started with Tabular Analysis Services Abstract:

 

This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013.

We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.


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

 

 

Mickey Stuewe

Changing Your Habits to Improve the Performance of Your T-SQL



July 6 2016 CST Noon

GotoWebinar Link

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

 

Azure and SQL Server

By Jes Borland

 

August 3, 2016 Noon CST

 

 

Bio:

Jes Borland is a Senior SQL Engineer at Concurrency and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, founder of FoxPASS in northeast Wisconsin, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturday, and other community events.

 

GotoWebinar Link

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

Statement Execution and the Plan Cache

By Kimberly   L .  Tripp

 

Sept 7, 2106, Noon CST

 

Statement Execution and the Plan Cache



Kimberly will discuss the impact on caching / performance of different methods of statement execution. Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the best way to request data so that stable requests are cached and unstable requests are not (giving you the most optimal performance).

 


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://global.gotowebinar.com/pjoin/2628525855691291906/1818394693229665282

 

 

Mickey Stuewe

Silent Killers Lurking in Your Schema

October 11th 2016 CST Noon

GotoWebinar Link

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

 


Zero-Downtime Upgrades: Rockstar DBA

 

By Argenis Fernandez

 

 

 

 

 

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL

 

Server infrastructure?

 

You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

 

In this session you will:

 

* Understand how rolling upgrades are better than in place upgrades

 

* Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades

 

* Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

 

This is a demo-intensive session, so you can see rolling upgrades live and up close.

 

If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!

 

 

 

 

 

 

BIO

 

Argenis Fernandez is a SQL Server MVP and SQL Server Solutions Architect for Pure Storage. He has worked with SQL Server for over 17 years and enjoys high-end OLTP databases, virtualization, performance troubleshooting, high availability, disaster recovery, best practices, and dealing with hard problems. Previously a Senior Consultant for Microsoft, he is also a Microsoft Certified Master, founder of the PASS Security Virtual Chapter, and an active member of the SQL Server community.

 

  Gotowebinar

 

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




Zero-Downtime Upgrades: Rockstar DBA

 

By Argenis Fernandez

 

 

 

 

 

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL

 

Server infrastructure?

 

You can actually do this by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

 

In this session you will:

 

* Understand how rolling upgrades are better than in place upgrades

 

* Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades

 

* Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

 

This is a demo-intensive session, so you can see rolling upgrades live and up close.

 

If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you!

 

 

 

 

 

 

BIO

 

Argenis Fernandez is a SQL Server MVP and SQL Server Solutions Architect for Pure Storage. He has worked with SQL Server for over 17 years and enjoys high-end OLTP databases, virtualization, performance troubleshooting, high availability, disaster recovery, best practices, and dealing with hard problems. Previously a Senior Consultant for Microsoft, he is also a Microsoft Certified Master, founder of the PASS Security Virtual Chapter, and an active member of the SQL Server community.




 

  •   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 davc@sqlpass.org or twitter is @DArchVC