2013 Presentations
May 2013
Robert Davis - Designing a Global Scale-Out Architecture
Speaker: Robert Davis, SQL Server Master SQL DBA Master
Summary: How do you deliver a public-facing website on a global scale? To be truly competitive in a global market, you need to deliver a high performing website no matter what part of the world the user is in. Scaling out websites to multiple locations is easy, but it doesn’t really provide the performance required if the website has to get data from halfway around the world. This session will look at the challenges to scaling out the entire application to meet global performance requirements and how we addressed these challenges for an existing web application.
About Robert: Robert is a SQL Server 2008 Certified Master and an experienced Database Administrator, SQL Server evangelist, speaker, writer, and trainer. He has worked with SQL Server for 13+ years, most recently as Chief SQL Server Evangelist for Idera Software. Previously he served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. Robert helped found the PASS Data Architecture Virtual Chapter and was co-author of Pro SQL Server 2008 Mirroring
LiveMeeting recording
March 2013
Steve hughes on Accounting on Windows Azure
Speaker: Steve Hughes, Practice Lead at Magenic
Summary: As Windows Azure becomes a more significant part of the IT landscape, data architects need to understand the data technologies at their disposal. Not all data can nor should be stored in the relational database in Azure. The discussion will include the various storage types available for data in Azure and how they may fit into an architecture. Learn which data storage techniques may work best for your next project with Azure and some of the nuances of using each type within a project
LiveMeeting recording & ReplayLink & Slide Deck
February 2013
Neil Hambly on Think You Have The Right Data-Type?
Speaker: Neil Hambly, Database Administrator Confio Software
Summary: Selecting the right Data-Type (DT) for data is key to efficient data storage, retrieval and processing, with over 30 different DT to choose from this isn’t as straight forward as you might think, have your also considered the usage pattern of the data in addition to its storage requirements This session explores the various data-types now available, we look at conversion’s between different DT’s as well as index sizes & effectiveness, compression and other factors can that influence these decisions, we finish off by discussing different approaches on ‘migrating’ a DT to a different DT, throughout the session we consider any performance considerations, such as when implicit conversions occur and more
2012 Presentations
December 2012
Introduction to Microsoft’s Master Data Services (MDS)
Speaker: James Serra, BI/Data Warehouse/MDM Architect and Developer Serra Consulting Services
Summary: 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.
Designing for Common Problems in SQL Server Part II by Louis Davidson
o Download examples http://www.drsql.org/Pages/Presentations.aspx
· Designing for Common Problems in SQL Server by Louis Davidson
o Download examples http://www.drsql.org/Pages/Presentations.aspx
· Where are my (Primary) Keys? by Ami Levin
· Improving Data Quality & Integrity using Constraints BY Neil Hambly
· Eating the Elephant: SQL Server Table Partitioning by Mike Fal
· Datawarehouse Dimension Processing with Integration Services - Simple to Complex By Todd McDermid
· On Beyond Zebra AdventureWorks OR Where Did I Go Wrong? By Steve Simon
· Database Makeover: Renovate Your Data Model, January 19, 2012 by Audrey Hammonds
2011 Presentations
- Row Versioned Data Warehouses, December 15, 2011 by Jeremy Huppatz
-
- Characteristics of a Great Relational Database, October 20, 2011 by Louis Davidson
-
-
- Architecture Career Paths, September 15, 2011 by Robert L Davis
-
- Data Warehouse Architecture, August 18, 2011 by John Racer
-
- Microsoft – Readying on “Hadoop”, July 21, 2011 by Gaurav Aggarwal
-
- You've Just Inherited a Data Model: Now What?, June 16, 2011 by Karen López
-
- From DBA to Data Architect: Changing Your Game, May 19, 2011 by Stuart Ainsworth
-
- Database Standards SOP, April 21, 2011 by Thomas LeBlanc
- Live Meeting Recording: DatabaseStandardOperatingProcedure.zip
2010 Presentations
- Agile Data Architecture With SQL Server, October 27, 2010 by Jeremy Huppatz
·