May-2012 ~ On beyond Zebra AdventureWorks OR where did I go wrong? ~ Steve Simon

Posted by admin

[Steve Simon]

 

Presenter: Steve Simon
Topic: On beyond Zebra AdventureWorks OR where did I go wrong?
Downloads: http://tinyurl.com/talkz
Mentioned Link: Parameter Sniffing

 

 

No matter how well planned and executed, the data structures of any data warehouse oft times eventually land up resembling something out of a Dr. Seuss book. In this presentation we shall be looking at and discussing a few of the “perfect” data structures (that I have inherited) and discussing the flaws that have only recently surfaced. We shall be looking at the ‘before’, discussing a few alternatives to make these structure more efficient and effective, then we shall then look at final “production structure” and the resulting improvement metrics; all of which help us to help our clients’ make better decisions in a timely manner.

Biography:

Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 20 years. Steve has presented papers at eight PASS Summits and two at PASS Europe. He has just recently presented a Business Intelligence paper at Oracle World in San Francisco . Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.

Aug-2010 ~ What Are You Waiting For? ~ Thomas LaRock

Posted by admin

 

Presenter: Thomas LaRock; Senior DBA, SQL Server MVP, PASS Director
Topic: What Are You Waiting For?

 

It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Biography:

Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Currently serving as a Senior DBA for Confio Software, Thomas has progressed through several roles in his career including programmer, analyst, and DBA. Thomas holds a MS degree in Mathematics from Washington State University and is a member of the Usability Professional’s Association. Thomas currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is also a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA (http://dbasurvivor.com).

May-2010 ~ As a DBA, where do I start? ~ Mike Walsh

Posted by admin

 

Presenter: Mike Walsh
Topic: As a DBA, where do I start?

 

Whether you are new to the role of DBA, being “forced” to take on the responsibility of one or are starting at a new company, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the “itties” of Database Administration (Recoverability, Availability – Health & Performance – , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the “itties” of Database Administration. There is also an interesting tip on extracting information from vendors before bringing their systems live.

Biography:

Mike is an experienced SQL Server professional and has worked with SQL for over ten years. He has performed the duties of Database Administrator, Developer, Architect and Performance Team Lead but always leans on his DBA experience in each role. Most recently he is the Principal DBA and SQL Server SME for a global insurance company while consulting with interesting and challenging assignments on the side.
Mike is becoming more active in the community through his blogging, starting up a user group in NH (http://seacoastsql.sqlpass.org) and speaking at various regional events