Compared to SQL Server here is the list of things that you can be completely ignorant about and still be a SQL Azure DBA:
- Hard Drives: You don’t have to purchase hard drives, hot swap them, care about hard drive speed, the number of drives your server will hold, the speed of SANs or motherboard bus, fiber connection, hard drive size. No more SATA vs. SCSI debate. Don’t care about latest solid state drive news. Everything you know about Hard Drives and SQL Server – you don’t need it.
- RAID: How to Implement RAID, choose a RAID type, divide physical drives on a RAID – don’t care. RAID is for hornets now.
- Backup and Restore: You need to know nothing about Back up SQL Server data files, transaction logs, or how the database model effects your backup. You don’t need a backup plan/strategy – nor answer questions the about risk factor for tsunami in Idaho. No tapes, tape swapping, or tape mailing to three locations including a hollowed-out mountain in the Ozarks.
- Replication: You never have to do any type of replication, or even care about the replication. Merge, Snapshot, Transaction Log Shipping, or having a read-only secondary database with a 60 second failover – don’t care.
- SQL Server I/O: You don’t have to worry about physical disk reads/writes or paging, disk access wait time, managing file groups across tables, sizing database file (.mdfs), shrinking your database (you shouldn’t do this on SQL Server anyways), transaction log growth, index fragmentation, knowing anything about the tempdb or how to optimize it, data files (.mdf, .ldf, .ndf), data Compression, or determine and adjust fill factor. None of this is required for a SQL Azure DBA.
- Hardware: You do not have to buy or make a budget for hardware when using SQL Azure. You don’t have to rack hardware, figuring out rail kits, care about cooling, find the right rack screw, creating name labels for servers using the label maker with dead batteries, sucking down water because the data center air conditioning is drying you like beef jerky. No more racks, wires, or KVMs, or redundant power worries.
- Rebooting: There is no driving cross-town for rebooting , 2:00 AM reboot, 3:30 AM rebooting, sleeping in the data center. No f@#!ing Safe Mode.
- Installing Software: No more installing Windows and the 103 critical updates. No more installing SQL Server or careing about how it is installed. No more midnight installations of Windows upgrades and SQL Server patches. Say with me now: “I don’t care how SQL Azure is installed “– first step of a twelve step program for recovering DBAs.
- Licensing: You do not need to understand SQL Server license types. Nor do you care how much RAM SQL Server 2008 standard edition supports in 32-bit mode versus 64-bit mode
- Database Integrity: DBCC anything. Weird huh – how does the database lose integrity? You don’t have to worry about it with SQL Azure.
- Performance Monitor: You will never have to open it with SQL Azure.
- Dynamic Management Views: sys.dm_db_index_physical_stats and sys.dm_io_virtual_file_stats are a couple that you don’t need to know.
Read the first five again (Hard Dives, RAID, Backup, Replication, SQL Server I/O), think of the books you have read and discussions you have had about these topics for SQL Server. Now look behind you; see that young SQL Azure DBA – why isn’t his bookbag weighting him to the ground?