|
Time |
Red Room |
Grey Room |
Yellow Room |
|---|---|---|---|
|
8.30 - 9.15 |
Registration - Tea, coffee, and pastries |
||
|
9.15 - 9.50 |
No Data Left Behind |
||
|
10.00 - 11.00 |
Database Maintenance Essentials Steve Jones, SQL Server MVP |
Future Plans For Red Gate Development Red Gate Product Management Team |
Get more out of your monitoring Robin Anderson, Red Gate |
|
11.00 - 11.30 |
Break-time (Grab a drink, something sweet, and network with attendees, presenters, and Red Gaters.) |
||
|
11.30 - 12.30 |
Prepare for when Disaster Strikes Steve Jones, SQL Server MVP |
Red Gate tools – The Complete Lifecycle Speaker information coming soon |
Case Study: Why You Should Source Control Your Database Mitchel Sellers, CEO/Director of Development |
|
12.30 - 13.30 |
Lunch (On us of course. You can chill out, talk to Red Gaters, and see the latest tools) |
||
|
13.30 - 14.30 |
The Whys and Hows of Database Continuous Integration David Atkinson and David Simner, Red Gate |
Automated Deployment: Application And Database Releases Without The Headache Allen White |
|
|
14.40 - 15.40 |
Social Media, Business Intelligence, and Bridging the SSMS-VS divide Noemi Moreno and Tom Austin, Red Gate |
Proactive Data Growth Management: Reducing your Storage Footprint Jes Schultz Borland, Consultant |
An introduction to Windows Azure and Cerebrata Eric D. Boyd, Windows Azure MVP |
|
15.40 - 16.05 |
Break-time (grab a drink, something sweet and network with attendees or speak to Red Gaters) |
||
|
16.05 - 17.05 |
Six Scary SQL Surprises Brent Ozar, MCM |
A Sandbox Development Process Grant Fritchey, SQL Server MVP |
Thwarting Database Defects Sebastian Meine, Trainer and Consultant and Dennis Lloyd Junior, Trainer and Consultant |
|
17.05 - 17.30 |
Drinks celebration - Final chance to talk to MVPs, presenters, and Red Gaters. |
||
Database Maintenance Essentials
Many DBAs take routine database maintenance for granted. What they don’t understand is that the cumulative effect of poor database maintenance can significantly hurt performance and reduce uptime. In this session, you will learn the key things all DBAs need to know in order to help them maintain their databases at peak performance. In this session you will learn about: Physical File Fragmentation; Database and Log File Management; tempdb Maintenance, msdb Maintenance; Index Maintenance; Statistics Maintenance; Data Corruption Detection; Database and Log File Protection; and Database Maintenance Monitoring.
Tools used: SQL Monitor
Future Plans For Red Gate Development
At Red Gate, it's everybody's job to make sure our tools delight our customers. In this session, we'll tell you about new, free tools from Red Gate labs, and our other latest product developments. We'll introduce you to tools you could start using in the office first thing on Monday, and ask for your feedback on what you'd like us to give you next.
Get more out of your monitoring
Would you like know how to extend SQL Monitor’s range and monitor wider business applications? This session is for you. Robin will show you how you can deploy custom metrics to monitor more than SQL Server, using real examples that are running on the Red Gate and SQL Server Central servers. He’ll also give you a preview of the new hosted version of SQL Monitor, designed to make it even easier to get started with a monitoring solution.
Prepare for When Disaster Strikes
Accidents happen, and when they happen to our computer systems, they are disasters. Steve Jones will talk about the disasters that are likely to occur in your computer systems and the steps you can take to minimize the impact to your environment.
Tools used: SQL Backup Pro, SQL Virtual Restore, SQL Monitor
Red Gate tools – The Complete Lifecycle
Developing and deploying databases within SQL Server requires you to perform massive amounts of work to get things done. Don't you wish there was a way to make your job even a little bit easier? Red Gate software supplies tools that work to simplify your work and your processes all the way through the development process. And make no mistake, these are useful tools, not another piece of software that you have to maintain. This session walks you through a complete development and deployment life-cycle with all the Red Gate software that will assist you through this process. We'll go from initial development to that first deployment to production and then back through the whole lifecycle again with subsequent releases of your code.
Case Study: Why You Should Source Control Your Database
This session walks through a development scenario explaining the true business need around source control for databases. Typical scenarios are discussed with a demonstration of the types of business benefit that database source control can define, including rollback, change tracking and helping improve consistency across the development teams. This session will end with a complete demonstration of the Red Gate SQL Source Control tool.
Tools used: SQL Source Control
The Whys and Hows of Database Continuous Integration
Development teams looking to shorten the feedback loop in the development cycle are turning to database continuous integration to achieve their goals. In this session, the two Davids discuss the benefits of database continuous integration and how the SQL Developer Bundle fits into the process. They’ll demonstrate using SQL Source Control to put a database under source control, the SQL Compare command line, and SQL Test for unit testing.
Tools used: SQL Source Control, All tools in the SQL Developer Bundle
Automated Deployment: Application And Database Releases Without The Headache
Ever since applications were first created, the deployment of updates and changes has been a headache, with the potential of disruption of the application at best and data corruption at worst. Getting the steps of any deployment right are critical to the success, and if there's a problem it's even harder. Data structures depend on code, and code depends on data structures. In this session we'll look at how deployment has been done in the past, the problems encountered, and we'll look at some ways to mitigate the risk inherent in application deployment, including Red Gate's new Deployment Manager tool, which helps you streamline the whole process.
Social Media, Business Intelligence, and Bridging the SSMS-VS Divide
In this session, Noemi and Tom explain how they developed a system to import information from Twitter into a SQL Server data warehouse, and then export their analysis into Google Docs. They also discuss how Red Gate’s database development tools helped them collaborate on the project without having to pick between their favourite IDEs.
Proactive Data Growth Management: Reducing your Storage Footprint
Organizations are storing more and more data at an unprecedented rate, forcing them to purchase more hard disk space. Are there any ways that DBAs can deal with data growth, and at the same time minimize their storage costs? Of course there is. In this session you will learn about several different options how you can use different forms of compression to reduce your organization’s footprint. These will include using Red Gate Software’s SQL Storage Compress to compress databases used for testing, development, and reporting; and how to use SQL Backup Pro to minimize your backup storage footprint.
Tools used: SQL Storage Compress and SQL Backup Pro
An introduction to Windows Azure and Cerebrata
In this session Eric will provide an introduction to Windows Azure, explaining the different components and concepts. He will then describe and demo a sample application and show how the Cerebrata tooling can be used to streamline the development of your Windows Azure applications. Free Cerebrata licenses, worth $515, will be available to all attendees of this session.
Six Scary SQL Surprises
No news isn't good news: sometimes it's terrifying. Just because your SQL Server slaves away silently doesn't mean all is well. If you're frustrated with your server's performance and you're not sure why things aren't going faster, maybe there's a hidden hazard holding you back. In this session, Brent will demonstrate 6 of the top server issues he sees out in the wild, explain how to monitor for them, and show you where to go to learn how to fix them for good. If you're an accidental DBA or a developer stuck managing a SQL Server that scares you, come gain confidence in this challenging session.
Tools used: SQL Monitor
A Sandbox Development Process
This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known datasets and source code management of your database code. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.
Thwarting Database Defects
It's bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It's even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You'll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.