Welcome to the Data Architecture Virtual Chapter
|
|
|
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.
|
|
|
May Presentation
|
| Subject: |
Eating the Elephant: SQL Server Table Partitioning |
| Start Time: |
Thursday, May 17th, 2012 12:00 PM US Central Time (Thursday, May 17th, 2012 6:00 PM GMT) |
| End Time: |
Thursday, May 17th, 2012 1:00 PM US Central Time (Thursday, May 17th, 2012 7:00 PM GMT) |
| Presenter: |
Mike Fal |
| Live Meeting Link: |
Live Meeting
|
|
Eating The Elephant: SQL Server Table Partitioning
Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.
|
|
Mike Fal
Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience along with some brief excursions into Oracle and Netezza. He has worked in several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.
Contact URL: http://www.mikefal.net/
|
 Add to calendar |
|
June Presentation
|
| Subject: |
Improve Data Quality & Integrity using Constraints |
| Start Time: |
Thursday, July 19th, 2012 12:00 PM US Central Time (Thursday, July 19th, 2012 6:00 PM GMT) |
| End Time: |
Thursday, July 19th, 2012 1:00 PM US Central Time (Thursday, July 19th, 2012 7:00 PM GMT) |
| Presenter: |
Neil Hambly |
| Live Meeting Link: |
|
|
Improving Data Quality & Integrity using Constraints
Leverage the power of Constraints to improve both Data Quality and
Performance of your databases. Powerful Data Entity & Referential Integrity can be
achieved using the different constraints available in SQL Server. Discover how to
utilize the full range of constraints available Default, Check, Unique, Foreign
and Primary keys. Learn how to use DBCC commands to validate data conforms to
constraints, handle Nulls and gain real-world performance tips.
|
|
Neil Hambly
Neil Hambly is a SQL veteran with over 13 years’ expertise in SQL Server from
Version 6.5 through to the very latest 2012 edition. Neil has held Database
roles at major organizations {BBC, ABN AMRO, ACCENTURE} as well as market
leading smaller companies, experienced in DBA, Developer & Architect roles. Neil is an speaker at conferences and user groups. UG Leader of the London Area SQL Server User Group (UK) often seen presenting at UK & international events. Just loves SQL!!!
|
| Add to calendar |
|
|
|
|
We are looking for presenters for the Data Architecture Virtual Chapter. Whether you have 10 minutes worth to discuss on a specific insight, or a raft of full-length decks ready to roll, we want to hear from you.
EMail us at PASS_DA_VC@Hotmail.com.
If you want to vounteer, we have openings:
• LiveMeeting hosting - creating the LiveMeeting scheduled task, emailing the presenter link to speakers and hosts, introducing speakers before webcasts, and monitoring questions.
• Speaker recruiting - reaching out to presenters in the SQL Server community to share their expertise and making sure session recordings are posted on the online meeting archive.
• Marketing - helping update the DArch website, submitting meetings to the PASS Events page, promoting webcasts via community bloggers/tweeters, and notifying media sites such as SQLServerCentral.com, Megaphone Community, and USGS.
• Website maintenance – acting as webmaster for the VC’s DotNetNuke-based website, hosted by PASS.
|
|
|
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies.
PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
|
|