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

Wed, Jul 23 2014 12:00 Central Daylight Time


Grant Fritchey – How to Build a Database Deployment Pipeline

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

Grant Fritchey – Microsoft MVP

July 23, 2014 Noon CST

 

How to Build a Database Deployment Pipeline.

 

The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, its data.

 

 Speaker Bio:

Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk

 

Webinar  https://attendee.gotowebinar.com/register/3676956357735772161

 

PASS Summit Discount Code VC15FFM6

http://www.sqlpass.org/summit/2016/RegisterNow.aspx

The cost of the PASS Summit is now $2195.00 until midnight PST 09/18/16. If you use our discount code,VC15FFM6, you can save an additional $150.00 to bring the cost down to $2045.00.

It will go up $200.00 after 09/18/16comes to a close.

http://www.sqlpass.org/summit/2016/RegisterNow.aspx

If you are interested in presenting on Data Architecture topic, please submit your bio and abstract to rob@sqltigers.com

 

             

Statement Execution and the Plan Cache

Sept 7, 2106, Noon CST

By Kimberly L. Tripp

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://attendee.gotowebinar.com/register/2628525855691291906

Silent Killers Lurking in Your Schema

October 11th 2016

9 pm CDT (**** UPDATED TIME ****)

By Mickey Stuewe

GotoWebinar Link

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

 

 

Considerations for deploying SQL Server with hyperconverged infrastructure solutions

 

Nov 9th 2016 Noon CDT

 

 

Hyperconverged platforms, where compute, storage and virtualization are combined into a single appliance, are becoming a popular mode for deploying infrastructure to support SQL Server installations.  This session will discuss the benefits, pitfalls and best practices of running SQL Server with hyperconverged solutions, including details on performance, sizing, data protection and high availability.

 

 

 

Mike McGhee

Sr. Technical Marketing Engineer, Nutanix


Mike has 17 years of experience in the IT industry and is currently focused on assisting customers and partners better understand the core functionality of the Nutanix platform.  Mike has responsibilities around stretched clustering solutions as well as the Microsoft ecosystem of products including Hyper-V.  Prior to Nutanix, Mike worked for EMC as a Systems Engineer with a focus on storage technologies and their intersection with hybrid clouds. Mike has several certifications including MCP, MCDBA and NPP.

 

 

GotoWebinar Link

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

 

 

John Sterrett

December 7th 2016 CDT Noon

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

 

§ 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