|
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 Grant Fritchey, SQL Server MVP |
Case Study: Why You Should Source Control Your Database Ernest Hwang, Senior Software Engineer |
|
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 |
A Sandbox Development Process Grant Fritchey, SQL Server MVP |
|
|
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 Denny Cherry, MCM |
Automated Deployment: Application And Database Releases Without The Headache Justin Caldicott, Red Gate |
|
15.40 - 16.05 |
Break-time (grab a drink, something sweet and network with attendees or speak to Red Gaters) |
||
|
16.05 - 17.05 |
Forgotten Rings and Other Monitoring Stories Grant Fritchey, SQL Server MVP |
Thwarting Database Defects Sebastian Meine and Dennis Lloyd Junior, Trainer and Consultants |
Top 10 Query Optimizer Topics for Better Performance Benjamin Nevarez, Senior Database Administrator |
|
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
Combining Continuous Integration and the Red Gate SQL Developer Bundle can help take the pain out of database deployments. Ernest will demonstrate how Practice Fusion went from not knowing what was in production to having effortless and worry-free deployments. In less than 30 days, Practice Fusion incorporated several Red Gate products in their Continuous Integration build process, saving precious developer person-hours and preventing headaches.
Tools used: SQL Source Control, SQL Compare, SQL Data Compare, SQL Test
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
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.
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
We all hear that “space is cheap”, so when servers get low on space we should just buy more. In fact, hard drive space in a server environment isn’t cheap. Fast or networked storage is very expensive. Wouldn’t it be nice if there was a way to write more data to the space you have available? Thankfully, you can. In this session, you’ll learn how Red Gate’s SQL Storage Compress helps. We’ll also look at native data compression in SQL Server 2008 and later. On the backup side of things, you’ll learn how SQL Backup Pro can compress the data within database backups to make them run faster and use less space.
Tools used: SQL Storage Compress and SQL Backup Pro
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.
Forgotten Rings and Other Monitoring Stories
Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure?
This session will drill down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server.
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.
Top 10 Query Optimizer Topics for Better Performance
This session will show you how Query Optimizer can help you to improve the performance of your queries. Ben will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.
Tools used: SQL Prompt and the SQL Developer Bundle