SQL University
Welcome to the homepage for SQL University. Here I will be keeping a running list of all known SQL University posts so that students, both new and alumni, can come back to and refer to old classes whenever you need to.
Student Resources
Faculty
Spring Semester 2010
- Documentation Week: Jorge Segarra
- Professional Development Week: Andy Leonard and Mike Walsh
- Doing It Right The First Time (4/19)
- Professional Development and Knowledge Sharing (4/20) by Mike Walsh
- Day Job Lessons From the Garden (4/23) by Mike Walsh
- Security and Auditing Week: K. Brian Kelley
- Auditing SQL Server Pt 1 (4/26)
- DBA Coach LaRock: Securing and Auditing Servers (4/27)
- Auditing SQL Server Pt 1 (4/26)
- Tools of the Trade Week: Mike Walsh
- Get You Some Tools (5/6)
- Check Out These Tools (5/7)
- DBA Coach LaRock: Tools of the Trade (5/4/10)
- SSIS Design/Development Week: Josef Richberg
- SSIS Fundamentals: The Big Picture (5/10)
- SSIS Fundamentals: Script Tasks and Components (5/11)
- SSIS Fundamentals: Data Flow Task (5/12)
- SSIS Fundamentals: Miscellaneous Components (5/13)
- DBA Coach LaRock: SSIS Design and Development (5/12)
- PowerShell Week: Aaron Nelson
- PowerShell Week Post 0 (5/17)
- PowerShell Week Post 1 (5/18)
- DBA Coach LaRock: PowerShell Week (5/20)
- PowerShell Week Post 2 (5/20)
- PowerShell Week Post 3 (5/20)
- Parallelism Week: Adam Machanic
- Parallelism Week: Introduction (5/24)
- Parallelism Week: Part 2, Query Processing (5/26)
- DBA Coach LaRock: Parallelism Week (5/26)
- Parallelism Week: Part 3, Settings and Options (5/28)
- Testing and Refactoring Week: Mladen Prajdic
- What and Why of Database Testing (5/31)
- What and Why of Database Refactoring (6/2)
- DBA Coach LaRock: Database Testing and Refactoring Week (6/2)
- Database Testing and Refactoring Tools and Examples (6/4)
- HA/DR Week: Ted Krueger
- Community Service Week: Ted Krueger and Jes Borland
- Meet the SQL Server Community! – (6/14) by Jes Borland
- SQL Server Forums-Helping to Build a Knowledge Base (6/15) by Ted Krueger
- Let’s Blog! - (6/17) by Ted Krueger
- SQL Community: Professional Association of SQL Server (6/17) by Jes Borland
- SQL Community Services – Resources Everywhere! (6/18) by Ted Krueger
- Women in Technology Week: Jennifer McCown and Jes Borland
- Intro to Women in Technology (6/21) by Jennifer McCown
- Women in Technology (WIT) Throughout History (6/23) by Jes Borland
- Issues for Women in Technology (6/25) by Jennifer McCown
- Database Design/Development Week: David Taylor (6/28)
- Database Design 101a (6/28)
- Database Design 101b (6/30)
- Database Design 101c (7/1)
- Degree Seeker (certification) Week: Robert Davis (7/5)
- Advanced Troubleshooting Week: Robert Davis (7/12)
- Indexing Week: Grant Fritchey (7/19)
- Capacity Planning: Steve Jones (7/26)
- Capacity Planning Week (7/26)
- Disk Capacity Planning (7/29)
Fall Semester 2009
- Syllabus
- Introduction (9/8)
- Orientation (9/23)
- Basic Tools Pt 1 (9/29): Jorge Segarra
- Basic Tools Pt 2 (10/1): Jorge Segarra
- Backups and Restores:Recovery Models (10/7): Argenis Fernandez
- Basketball Practice: SQLU Hoops First Practice (10/8)
- SQL Admin Pt 1 (10/13)
- SQL Admin Pt 2: SQL Server Error Logs (10/15)
- Basketball Practice: Hoops Practice (10/16)
- An Introduction to SQL Server System Databases (10/19)
- Security Week: K. Brian Kelley
- Authentication and Authorization (10/26)
- Diving into Authorization (10/28)
- Multiple Paths and Ownership Chaining (10/30)
- Basketball Practice: Basketball Practice (10/30)
- History Week: Jorge Segarra
- History Week Pt1 (11/3)
- History Week Pt II: Current Events (11/6)
- History Week Pt III: The Future ==You (11/11)
- Indexes (11/12): Gail Shaw
- Troubleshooting tips/techniques Week: Chuck Lathrope
- How to Troubleshoot Complex Systems (11/16)
- How to Troubleshoot Example (11/19)
- Intro to Business Intelligence/Reporting Week: Govind S. Yadav
- An Introduction to BI Pt 1 (11/23)
- Intro to SSIS Week: Josef Richberg
- Replication Week: Kendal Van Dyke
- Advanced Development Tips/Tricks Week: Govind S. Yadav
- Intro to Storage Week: Brent Ozar
- The Basics of Storage (12/21)
- Where We Store Stuff (12/23)
- Basketball Practice: SQL University Hoops Practice (season closer) (12/23)
Digg This Post
Stumble This Post








[...] today’s class at SQL University, (#SQLU on Twitter, the brain child of Jorge Segarra, who blogs at The SQL Update Statement, and [...]
[...] today, our last class together at SQL University, (#SQLU on Twitter, the brain child of Jorge Segarra, who blogs at The SQL Update Statement, and [...]
[...] main argument comes from those that get them and those that don’t. If you are a student of SQL University you may have caught Thomas LaRock’s (blog | twitter) lecture on Certification [...]
[...] SQL University [...]
[...] For some crazy reason (probably everyone is on vacation), Jorge Segarra (blog|twitter) who runs SQL University has asked me to submit some material. I’ve got three posts, all coming up next week, that [...]
[...] to the History department here at the Miskatonic branch of SQL University. Why the History department? Well, first, because I like history and have frequently thought I [...]
[...] community of which I am so proud to be a part. Every day folks were writing multiple blog posts, SQL University had a week on Certifications, just all kinds of resources to learn from. Actually, some of the [...]
[...] indexes, indexing, SQL Server, sql university) Welcome once more to the Miskatonic branch of SQL University. Please try to concentrate. I realize the whipoorwills singing outside the window in a coordinated [...]
[...] fight your way through the shoggoths outside to attend another lecture at the Miskatonic branch of SQL University. This will be the third and final part of the introduction to indexes lecture. Please, if [...]
[...] week I wrote a series about Certification for SQL University that would have been ideal for today’s topic. Alas, that was last week, and T-SQL Tuesday is [...]
[...] will be serving on the faculty of SQL University for two courses in the next two [...]
[...] I did a week-long blog series on PowerShell with SQL Server for SQL University. [...]
[...] in the headlights” look on many occasions. But it inspired me to start checking out SQL University, created and maintained by Jorge Segarra (aka SQLChicken). While I haven’t had much of a [...]