My first brush with SQL was in 1996, with SQL 6.5. It was known as the “mickey mouse” database for some reasons i couldn’t understand then (well, i was still a student u know). I had huge respects for DBA (Database Administrators) and earned my first DBA Certification (MCDBA) from Microsoft in 2002. And subsequently upgraded my certifications several rounds.
Yes, i’m on my next round of certification updates. This time i’m eyeing on SQL Server 2008 R2. From a simple database server to now, it has grown so much (Felt like my brains are swelling from picking it up).
I just wanted to share a very cool set of resources that i picked up on Channel 9. It is a Developers Training Course for SQL Server 2008 R2. Supposedly to be meant for developers, but i felt IT Pros benefits from understanding the information too. (Warning to IT Pros: Might be a bit too developer focused. Good for DBAs to know the capabilities).
To make it easy, i’m listing the topics here. But do visit the main page for a collection;
- Getting Started with SQL Server 2008
- SQL Server 2008 – Overview
- SQL Server 2008 R2 – Overview
- SQL Server 2008 – Date and Time Data Types
- SQL Server 2008 – Location Awareness via Spatial Technologies
- SQL Server 2008 – Improved BLOB Support via FILESTREAM
- SQL Server 2008 – Transact-SQL Improvements
- SQL Server 2008 – CLR Integration
- SQL Server 2008 – Reporting Services
- SQL Server 2008 – Adventure Works Racing Community
- SQL Server 2008 R2 – Application and Multi-Server Management
- SQL Server 2008 R2 – StreamInsight
- SQL Server 2008 R2 – Reporting Services
/Dennis