.png "SQL Server How Do I - Videos")
 | Introduction to DB Design This video presents the fundamental concepts for relation tables and using the normalization design process to minimize structural problems with the tables you design in relational databases.The presentation first covers the fundamental concepts and design process, and then walks you through an exercise showing how the normalization rules are applied. Thursday, Feb 23 |
 | SQL 2012 Master Data Services - Hierarchies and Collections Learn how to use Hierarchies and Collections in Master Data Services SQL Server 2012 Tuesday, Jan 24 |
 | SQL 2012 Master Data Services - Entity Based Staging Loading data into MDS has become easier. You can now load all members and attribute values for an entity at one time. Previously you had to load members and attributes in separate batches. This video demonstrates how to use the new Entity Based Staging in MDS SQL Server 2012. Tuesday, Jan 24 |
 | SQL 2012 Master Data Services - Business rules and approval workflows Learn how to create business rules and approval workflows in Master Data Services SQL 2012. Tuesday, Jan 24 |
 | SQL 2012 Master Data Services Overview IThis video provides an overview of Master Data Services in SQL Server 2012 and presents its capabilities, architecture and key scenarios. Tuesday, Jan 24 |
 | SQL 2012 Master Data Services Security Learn how to use Security in Master Data Services SQL Server 2012. Tuesday, Jan 24 |
 | SQL 2012 Master Data Services - Model migration across environments and MDS upgrade Migration of model structure and data from one MDS environment to another is made much easier and efficient in MDS SQL Server 2012. This video showcases the new model migration tools in MDS SQL Server 2012 and demonstrates their usage and capabilities. Monday, Jan 23 |
 | Managing Data Warehouse Dimensions with MDS (part 1) This video demonstrates the power of MDS and BI integration, empowered business users to manage their dimensions in a DWH / DataMart in a very agile manner, reducing the dependency on IT and lowering TCO.The managing data warehousing scenario has 2 parts. In this part 1, you will see how business users can manage a simple data warehouse hierarchy. Wednesday, Dec 14 |
 | Managing Data Warehouse Dimensions with MDS (part 2) This video demonstrates the power of MDS and BI integration, empowered business users to manage their dimensions in a DWH / DataMart in a very agile manner, reducing the dependency on IT and lowering TCO. The managing data warehousing scenario has 2 parts. In this part 2, you will see how business users can leverage MDS to manage complex recursive hierarchies in the data warehouse. Wednesday, Dec 14 |
 | Using MDS Excel Add-In to Model and Manage your Master Data The Master Data Services Excel Add-in is newly introduced in SQL Server 2012. It empowers business users / data experts to create and manage their models. This video presents the MDS Excel Add-in feature set and demonstrates how an information worker can leverage the power of Excel to manage master data in an agile and effective manner. Wednesday, Dec 14 |
.png){kind=spacer}
