Steve Simon - Challenges to designing financial warehouses
In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time. In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
Steve Simon is a SQL Server MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Master Data Services presentation at the PASS Amsterdam Rally. 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.
Presentation Material, Code, or further Contact with Steve - http://www.Infogoldusa.com
Louis Davidson - How to Recognize When Your Relational Database is "Good Enough"
Speaker: Louis Davidson, Data Architect, drsql.org
Summary: In a computer project, no phrase irks me more than "better is the enemy of good enough." It is true of course, but you have to carefully guard the meaning of "good enough" or you will have a mess on your hands. What makes a great database? When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and normalized (naturally) will be covered.
About Louis: Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 8 years and has written five books on database design. Louis is currently the data architect for the Christian Broadcasting Network, supporting offices in Virginia Beach, VA, and Nashville, TN. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Steve Simon - Challenges to designing a Finacial DW
Speaker: Steve Simon SQL Server MVP
Summary: In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time. In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
About Steve: Steve Simon is a SQL Server MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Data Quality Services presentation at the PASS Nordic Rally in Copenhagen. 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
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
Steve hughes on Accounting on Windows Azure
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
Neil Hambly on Think You Have The Right Data-Type?
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
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
- 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
- Agile Data Architecture With SQL Server, October 27, 2010 by Jeremy Huppatz