no text exists for this slide

Introductions
Introductions
Session goals
Oracle
SQL Server
MySQL
Additional information
Questions and Thank You

Database Architect
Database Architect
Oracle and SQL Server DBA
Former Software Developer
Current Position:
Manager of Database Engineering
Policy Studies, Inc. - Denver CO

CTO @ Edgewood Solutions
CTO @ Edgewood Solutions
SQL Server Professional Services, Development, Administration, Custom Training
jeremyk@edgewoodsolutions.com
410.591.4683
Founder @ MSSQLTips.com
Technical SQL Server newsletter delivered daily
Co-leader Baltimore SSUG – www.bssug.org
Professional Objectives
Seek out sensible solutions for difficult SQL Server problems
Work with clients from detection to knowledge transfer
Share knowledge through personal and group training as well as with MSSQLTips, user groups and conferences
Recognized as a SQL Server MVP

Data Architect/DBA
Data Architect/DBA
12 Years in IT using Oracle
Strategy, Design, Development, Compliance
Performance Tuning and Trouble-shooting
Current Position:
Database Architect
Policy Studies, Inc. - Denver CO

CIO – W3Consultants
CIO – W3Consultants
Developer – Smithsonian
Author / Partner – CommunityMX
Instructor – Web Technologies
10+ Years ColdFusion
10+ Years SQL Server, MySQL

Compare the database platforms on a common set of criteria
Compare the database platforms on a common set of criteria
Set aside time for questions and answers
Put it to a vote! You be the judge to determine the best platform for you…
Comparison of all RDBMS Platforms
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

SQL Server Platform Scalability
SQL Server Platform Scalability
Developer Productivity
Security
Automation

no text exists for this slide

no text exists for this slide

no text exists for this slide

no text exists for this slide

no text exists for this slide

Built-in roles to simplify management
Built-in roles to simplify management
Granular server, database and object level rights
All data access through stored procedures
Encryption and key management
Backup encryption
Auditing
Failed logins
Data changes – Insert, Update, Delete
SELECT statements
Object changes
Additional information
http://www.mssqltips.com/category.asp?catid=19

SQL Server Agent
SQL Server Agent
Job management, scheduling, alerting, etc.
http://www.mssqltips.com/category.asp?catid=27
Database Mail
Email engine for sending and receiving email
http://www.mssqltips.com/category.asp?catid=44
SQL Server Performance Warehouse
Metric collection and reporting
http://www.mssqltips.com/tip.asp?tip=1746
Integration Services
Extract, Transform and Load
Import and Export interface
http://www.mssqltips.com/category.asp?catid=17
Policy Based Management
Define conditions, validate meeting condition
http://www.mssqltips.com/tip.asp?tip=1492

Microsoft SQL Server 2008 Editions
Microsoft SQL Server 2008 Editions
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Features Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc645993.aspx
Maximum Number of Processors Supported by the Editions of SQL Server
http://msdn.microsoft.com/en-us/library/ms143760.aspx
Editions and Components of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms144275.aspx
SQL Server 2008 How to Buy
http://www.microsoft.com/sqlserver/2008/en/us/how-to-buy.aspx

Oracle Platform Scalability
Oracle Platform Scalability
Developer Productivity
Security
Automation

no text exists for this slide

Oracle Enterprise Edition
Oracle Enterprise Edition
Oracle’s top-end database server product with ability to add multiple features from Oracle stack.
Oracle Standard Edition
Four-processor version of Oracle Database, including full clustering support (Real Application Clusters).
Oracle Standard Edition One
Two-processor version of Standard Edition at an attractive entry-level price. Real Application Clusters is NOT included with Oracle Database Standard Edition One.
Oracle Personal Edition
Full-featured version for individuals, compatible with the entire Oracle Database family (except Real Application Clusters).
Oracle Express Edition
Oracle XE is a free version of Oracle that is limited to 1 processor, 1 GB RAM and 4 GB of data.

Partitioning Option
Partitioning Option
Spatial Option
Real Application Clusters Option
Advanced Security Option
Oracle Label Security
Oracle OLAP
Oracle Data Mining

no text exists for this slide

Real Application Cluster
Real Application Cluster
GRID Control
Data Guard

Oracle Developer
Oracle Developer
JDBC Drivers (XE Only)
XML Support
Regular Exressions
Java
PL/SQL stored objects

Users/Roles
Users/Roles
Encryption
Fine Graned Auditing
Label Security

Schedule Job Execution
Schedule Job Execution
Define Multi-Step jobs
Schedule Job Processing that Models Business Requirements
Manage and Monitor Jobs

Useful Links
Useful Links
http://www.oracle.com/technology/index.html
http://www.dba-oracle.com/
https://metalink.oracle.com/CSP/ui/index.html
http://www.orafaq.com/wiki/Oracle_Product_Set#Oracle_Standard_Edition

Scalability
Scalability
Developer Productivity
Security
Automation

no text exists for this slide

no text exists for this slide

Scalability
Scalability
Ability to spread the load of your application queries across multiple MySQL servers.
Replication
Clustering

Replication
Replication
Advantages
Available on all platforms supported by MySQL
Asynchronous and can be stopped and restarted at any time.
Data can be replicated from one master to any number of slaves, making replication suitable in environments with heavy reads, but light writes
Disadvantages
Data can only be written to the master.
No guarantee that data on master and slaves will be consistent at a given point in time

Clustering
Clustering
Advantages
Offers multiple read and write nodes for data storage.
Provides automatic failover between nodes
Data on nodes is instantaneously distributed to the other data nodes.
Disadvantages
Available on a limited range of platforms.
Nodes within a cluster should be connected via a LAN; geographically separate nodes are not supported.

Developer Productivity
Developer Productivity
Tools
PhpMyAdmin
Navicat
Aqua Data Studio

Security
Security
Privileges Management
GRANT | REVOKE
Passwords
Store Passwords in MD5 or SHA1 format
Never store the MySQL ‘root’ user password in a ~root/.my.cnf file.
Developer
Utilize Views and Stored Procedures

Automation
Automation
Backups
Schedules

MySQL Enterprise Features
MySQL Enterprise Features
http://www.mysql.com/products/enterprise/features.html
MySQL Cluster
http://www.mysql.com/products/database/cluster/
MySQL Backup and Recovery
http://www.mysql.com/products/backup/
MySQL How To Buy
http://www.mysql.com/buy-mysql/

Nate Nelson
Nate Nelson
natenelson@gmail.com
Jeremy Kadlec
jeremyk@edgewoodsolutions.com
Damon Brown
damonandrewbrown1@yahoo.com
Chaz Chumley
Chaz.chumley@w3consultants.com