Content in the Database Category
Need a fast data integration solution, but don’t have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We talk about how to set performance expectations, and how to put together a simple framework to record benchmarks for your ETL process. We go over the basics of smart package design, and then look at a number of design patterns for common data warehousing problems, such as Slowly Changing Dimension processing, Range Lookups, and Change …
RDBMS has been the standard for many years, when it has come to data storage. However, recently there has been an increase in document databases. In this talk we are going to cover the basics of CouchDB database, and how to work with it coming from an RDBMS and .NET point of view
Watch this video on the Oredev Conference web site
Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we discuss in detail the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse, and aging. You will leave this session with full understanding of how to improve your server’s performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).
Download …
An introduction and overview to object/relational mapping using Fluent NHibernate. See how Fluent NHibernate can help you map your domain with the least amount of effort, how you can remain flexible with your database, and how to drive your design through convention–over–configuration; all without writing a single line of XML.
Watch this streaming video from the Norwegian Developer Conference 2010
Entity Framework in .NET 4 has finally embraced agile development. Thanks to it’s new POCO support, you can now build completely persistent ignorant entity classes. In this session, we’ll look at building an intelligent repository from entity classes and mocking up some extra classes in order to build unit tests against methods that have some dependency on the Entity Framework without touching the EF APIs. A prior understanding of the PI and Unit Testing should keep your head from spinning too much.
Watch this streaming video from the Norwegian Developer Conference …

Twitter
Facebook
RSS