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

Thu, Dec 20 2012 13:00 (UTC-05:00) Eastern Time (US & Canada)


Introduction to Microsoft’s Master Data Services (MDS) by James Serra

RSVP: http://dataarch.sqlpass.org/

Introduction to Microsoft’s Master Data Services (MDS)

Companies struggle with consolidating the same set of data from multiple systems to accurately report on critical business information. For example, having customer lists in multiple systems that often have the same customer in more than one list, sometimes with a different spelling. Master Data Services is bundled with SQL Server 2012 to help resolve many of the Master Data Management issues that companies are faced with when integrating data. In this session, James will show an overview of Master Data Services 2012, including the out of the box Web UI, the highly developed Excel Add-in, and how to get started with loading MDS with your data.


James is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

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/16 comes 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

 

Indexes and Execution Plans

July 27 2016 12:01 Pm CDT

By Robert Bishop

 

Abstract:

 

In the spirit of Tim Ford’s Year Long Entry Level Challenge, this presentation will explain the basics of execution plans, how to read execution plans, what are warnings and what do they mean, and how to use execution plans to properly index your databases for optimal performance.

 

BIO:

 

Robert has been working with databases since SQL Server 2005. After 4 years as a .NET developer using SQL Server, Robert became a DBA out of necessity, a true "Accidental" DBA! For the past 5 years he has worked as a DBA for a local hospital managing over 90 instances of SQL Server. Recently, Robert decided to expand his career by becoming a SQL Server Consultant for Sparkhound. Robert has presented at his local SQL Server User group and regional SQL Saturdays. Robert enjoys automating administrative tasks, configuring SQL Server for optimal performance, troubleshooting problematic SQL Servers and performance tuning.

 

GotoWebinar Link

 

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

Azure and SQL Server

August 3, 2016 Noon CDT

By Jes Borland

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/447887534067687170

 

 

 

 


Understanding SQL Server Backup and Restore

Wed, Aug 17, 2016 Noon CDT

By Tim Radney

Description

Understanding SQL Server Backup and Restore Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!

GotoWebinar Link

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

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


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

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