SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

PASS Virtual Chapter Events - July 2012


Date:  Thursday, July 10

Time:  11:00 a.m. - 12:00 p.m. Central Time

Virtual Chapter:  DBA Fundamentals

Event URL:  http://www.livemeeting.com/cc/usergroups/join (Meeting ID TW8M35, Entry Code Prxcw2F-H)


Subject:  ?DBA

Now that you're a DBA where do you start?  You have backups, don't you?  Are you really sure?  Tools for the DBA really help you do your job, so we will talk about some tools to use.  I'll talk about how you can get help when you need it.  I'll point you to some really good scripts to use for monitoring or for using for your whole maintenance cycle on your SQL Servers.

?Presenter:  David Smithey has 31 years of IT experience.  He has 9 years of experience as an SQL Server DBA and before that he was a developer.  He has worked/consulted for companies such as Acustar, Computer Services Corporation, the Pentagon, Boeing and NASA.  He is currently employed by Curves International.  ?Email:  david@davidsmithey.com ? Twitter:  @DavidKSmithey


Date:  Thursday, July 26

Time:  12:00 p.m. - 1:00 p.m. Central Time

Virtual Chapter:  Data Architecture Virtual Chapter

Event URL:  http://www.livemeeting.com/cc/usergroups/webJoin?id=CZC34P&pw=nP%28qm%3A2RN&role=attend

Subject:  ?Where Are My (Primary) Keys?


In this session, we revisit some of the fundamental design principals of relational databases - normalization rules, key selection, and the controversies associated with these issues -- from a very hands-on, practical perspective.  We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.
Session takeaways:
Understand the profound impact of key selection on the entire application lifestyle
Learn to identify when it is best to use natural or artificial keys
Learn how to minimize performance, portability, and maintenance issues during the early database design phase
?Presenter:  ?Ami Levi, CTO, DBSophic - Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT.  For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide.  Ami's areas of expertise are data modeling, database design, T-SQL, and performance tuning.  He leads the Israeli SQL Server user group (ISUG), moderates the Hebrew MSDN SQL Server support forum, and is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences.  Ami speaks often at user group meetings in Israel and Europe and writes articles about SQL Server.
  ...Tweet This

Marc Beacom

Marc Beacom – MCTS (BI, Dev), Principal Architect and Owner at DawaBI, has over 15 years of technical and business experience. DawaBI focuses on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently is co-organizer of the Colorado GiveCamp, served a year as a PASS Regional Mentor and served five years on the leadership board for the Denver and Colorado Springs SQL Server User Groups.


Leave a comment on the original post [www.dawabi.com, opens in a new window]

Loading comments...