Skip to content

  • Check out the final line-up of speakers & register now…

Share this page:

SQL Server Training the Red Gate way

Pasadena 2013

Wednesday 09 October 2013

Agenda

Time

Room 107

Room 101

8.30 - 9.00

Registration – meet attendees & Red Gaters

9.00 - 9.30

Protect and Change

John Theron, Red Gate COO, Steve Jones, SQL Server MVP, and David Simner, Software Engineer

9.30 - 10.30

Team-based Database Development with Version Control

Steve Jones, SQL Server MVP

Query Performance Tuning in the Cloud

Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate

10.35 - 11.35

Database Build and Release

Ernest Hwang, Senior Software Engineer,
Practice Fusion

Practical DBA Tools Demo Session

Red Gate developers and Grant Fritchey

11.35 - 11.55

Break-time – grab a refreshment + check out the latest Red Gate tools and network with Red Gaters, attendees, and speakers

11.55 - 12.55

Best Practices for Database Deployment

Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate, and David Simner, Red Gate Software Developer

Red Gate Data Services — A Future Direction

Dom Reed, DBA UX Lead

12.55 - 13.50

Lunch-time – enjoy lunch on Red Gate + share experiences of using Red Gate tools with fellow attendees, MVP speakers, and Red Gaters

13.50 - 14.50

Core Monitoring for SQL Server

Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate

The Encryption Primer

Steve Jones, SQL Server MVP

14.55 - 15.55

Common Problems in Backup and Recovery and How to Handle Them

Steve Jones, SQL Server MVP

SQL Server Tips and Tricks

Ike Ellis, SQL Server MVP

15.55 - 16.15

Break-time – grab a refreshment + suggest and discuss product feedback with Red Gate developers in the demo-pod area

16.15 - 17.00

Automating Common DBA Tasks

Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate

Improve Your T-SQL by Changing Your Writing Habits — Red Gate Style

Mickey Stuewe, Sr. SQL Database Developer

17.00 - 17.30

Networking time

Please note the agenda schedule is subject to change. Follow #sqlinthecity for updates.

Session abstracts

Team-based Database Development with Version Control

An efficient development process requires that all of your team members coordinate their efforts. This session shows how a version control system and standard development practices help improve the speed and quality of your development process.

Back to top...View slides (PDF)

Query Performance Tuning in the Cloud

Just because you're using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources.

This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You'll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.

Back to top...View slides (PDF)

Database Build and Release

Combining Continuous Integration and the Red Gate SQL Developer Bundle can help take the pain out of database deployments. Ernest Hwang demonstrates 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

Back to top...View slides (PDF)

Practical DBA Tools Demo Session

Back to top...

Best Practices for Database Deployment

The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code?

The difference between a successful deployment and a failed or problematic deployment is all the preparation work you've done to ensure that you're deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.

Back to top...View slides (PDF)

Red Gate Data Services — A Future Direction

This session will give you a peek at prototypes of the latest Red Gate projects for DBAs and those concerned with database administration. You'll be one of the first to hear what's coming next, and have the opportunity to provide feedback on which new features you want to see in our tools.

Back to top...View slides (PDF)

Core Monitoring for SQL Server

Good DBAs ensure they're always aware of the state of their instances. All systems should have monitoring in place, not just so you know when things go wrong, but so you understand what a normal workload looks like and can plan for the future.

This session will cover best practices for monitoring a SQL Server system, key metrics you should be tracking, and how you can monitor for your specific business needs using Red Gate's SQL Monitor.

Back to top...View slides (PDF)

The Encryption Primer

SQL Server has a number of encryption features that allow you to better secure your data. This session will examine the basics of encryption and cover the various ways in which you can encode and decode your data to protect it from unauthorized access. Cell-level encryption, Transparent Data Encryption, and backup encryption will all be discussed. This session is designed for those who want to learn the basics of protecting their data. This talk looks at the encryption options in SQL Server that are available, including the changes in SQL Server 2012.

Back to top...View slides (PDF)

Common Problems in Backup and Recovery and How to Handle Them

The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we'll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we'll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you'll gain from this session could help to save your business.

Back to top...View slides (PDF)

SQL Server Tips and Tricks

In this session we'll quickly go over our best tips on using SQL Server. We'll show you shortcuts, tools, great practices, and hidden gems on how to manage SQL data. There'll be great tips for SQL Server Reporting Services, SQL Server Integration Services, SQL Server Performance Tuning, Architecture, Design, and Software Development. Come prepared to share your own tips too.

Back to top...View slides (PDF)

Automating Common DBA Tasks

Being a DBA is a continual challenge — the only constant is change. Nonetheless, certain tasks do get repeated. This session covers how to automate some of them, including auditing your databases for changes, maintaining lookup/code table data across environments, troubleshooting production problems, and recovering objects from backups, using tools available in the common tool set and Red Gate's SQL DBA Bundle.

Back to top...View slides (PDF)

Improve Your T-SQL by Changing Your Writing Habits — Red Gate Style

Do you dread handing your T-SQL over for code review? Does the DBA always want to tweak your queries? Do you always forget that error handler or the syntax of Common Table Expressions? In this demo-heavy session, Mickey Stuewe will look at ways you can improve your habits. You'll learn how to format code for readability, why top-down design is not the best solution, how to templatize the T-SQL in your personal arsenal for easier reuse, and performance tips like how to search for implicit conversions. By changing your writing habits you can improve the performance of your queries and your own performance, right from the outset.

Back to top...View slides (PDF)