Webinar: Top 5 Things to Know about Managing Multiple Database Platforms

By: Tim DelChiaro

Abstract: Moving Beyond Your SQL Server Comfort Zone

Login  
Top 5 Things to Know about Managing
Multiple Database Platforms


Moving Beyond Your SQL Server Comfort Zone
 


Wednesday, June 30th, 2010 at 12:00pm Eastern / 9:00am Pacific
(5:00 p.m. United Kingdom/ 6:00 p.m. Central Europe)


While some DBAs work exclusively on SQL Server, you may have to support two or more types of database platforms today, and certainly multiple types of databases throughout the course of your career. 

Whether additional database platforms come from new applications, a company acquisition, or somehow just pop up (darn those app developers!), supporting databases beyond your SQL Server comfort zone can be challenging. 

During this lively conversation with real world examples, Stephen Wynkoop and Scott Walz will discuss the five things every SQL Server DBA needs to know when managing multiple database platforms. 

Sign up for this web seminar if you're interested in learning how your SQL Server skills can be easily extended to additional database platforms such as Oracle, DB2, MySQL, or Sybase. 

 


The Top 5 Things to Know


Stephen and Scott's live, spirited conversation will address the following questions:


Advanced Schema & Data Migration & Reporting

        How do you reverse engineer the ERD (Entity Relationship Diagram) to show you what the new database looks like on "paper" so you can really "see" the tasks at hand?
        What are the best practices for setting up test and QA environments?
        How do you migrate schema and table data to a new database?
 


Security Management

        How can you save time when setting up new users across multiple DBMSes (e.g. roles, privileges and permissions)?
 


Object Management & Change Management

        How do you create and edit database objects?
        What's the best way to manage database change and roll backs
        What's the value of a "backstop" within your change management plan?
 


Detecting & Diagnosing Storage Problems

        Do you know...really know...how that new 3rd party application is being used?
        How much data is being added?
        Are you covered in terms of storage? How about 6 months? 9 months?
 


Diagnosing & Repairing Performance Problems

        What are the most useful performance analysis techniques?
        How can you easily find and fix performance issues early in the application development lifecycle and make sure they never make it into production?
        How can you quickly determine how SQL will perform under different database platforms?
 


Take Aways:
  • A general understanding of the variables involved in managing multiple database platforms
     
  • Proactive techniques you can use to improve database performance
     
  • How setting up a proactive storage monitoring plan can improve availability while decreasing your hardware costs
     
  • How to use the latest tools to increase you own productivity while expanding your skills into unfamiliar databases
     
  • In addition, each LIVE attendee will receive a copy of "The High Performance SQL Server DBA" whitepaper by Scott Walz
     

Speakers

Scott WalzScott Walz
Scott Walz has more than 15 years of experience in database development and administration and currently serves as the senior director of product management for Embarcadero Technologies. In this position, Scott oversees the direction of the company's database product family, while focusing on database development and administration products. Prior to joining Embarcadero four years ago, Scott served as a development lead for Louisville Gas & Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.


Stephen WynkoopStephen Wynkoop
Stephen is a Microsoft SQL Server MVP and the founder of SSWUG.ORG. He writes a daily column and newsletter on the site and produces a weekly SQL Server video program on the site. Stephen is the author of more than 12 books translated into 7 languages around the world. Stephen has spoken at numerous technology conferences and reports regularly on the happenings in the technology world.


 
 

Server Response from: ETNASC02