30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Designing and deploying a database using visual studio 2010

Database projects allow offline development and easy deployment of a database. Previously they were only available in team system versions of visual studio, but with the release of visual 2010 they will also be available in the professional version.
This presentation will introduce the key concepts of database projects.  It will also show you how to create a database project, import an existing database, modify objects and then deploy it to any sql server.

Speaker focus

Anthony Brown


Anthony has been a sql server DBA since 1998 and have worked with all
versions of SQL server since 6.5. Since 2001 he has worked
at John Lewis on their website designing a highly scalable and
resilient architecture for it. He has experience in many areas of sql
server including service broker, replication and visual studio
database projects.


Anthony Brown's blog http://sqlblogcasts.com/blogs/antxxxx/Default.aspx



Downloads

No items to download

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Make your DBA life better using SQL Server technologies - notes from field & best practices
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!