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
- Computer Lab
- Bookstore
- Sign up for our mailing list
- FAQ
- Course Feedback form (Please fill out per week/event)
Faculty
=====================================================================
Fall Semester 2011
Architecture (Small Businesses): Jorge Segarra 
(9/19/11)
- Architecture for Small Businesses (9/19)
- SQL Server Editions for Small Businesses (9/21)
- Small Business Hardware (9/23)
Advanced SSIS: Josef Richberg 
(9/26/11)
- Named Pipes – Fundamentals (9/26/11)
- Named Pipes – Producer (9/27/11)
- Named Pipes – Consumer (9/28/11)
Troubleshooting: Mike Walsh (10/3/11)
- Troubleshooting Week (10/3/11)
Compression: Bradley Ball (10/10/11)
- Lesson 1 About Compression (10/10/11)
- Lesson 2 Internal Structures, Vardecimal & Row Compression (10/11/11)
- Lesson 3 Page Compression (10/17/11)
SSIS Auditing: Mike Davis (10/17/11)
- Setting Up SSIS Auditing Part I (10/17/11)
- Setting Up SSIS Auditing Part II (10/20/11)
Auditing and Security: K. Brian Kelley (10/24/11)
- SQL Agent Jobs That Run at SQL Agent Start (10/27/11)
- Understanding Kerberos Pt III (10/28/11)
Professional Development: Mike Walsh / Brian Moran (10/31/11)
- Full Week Exploring Goals by Brian Moran (10/31/11)
- Are Your Goals S.M.A.R.T.? (11/4/11)
- Are Your Strategic Goals Smart? (11/10/11)
Indexing (Advanced): Gail Shaw (11/7/11)
- Advanced Indexing Sorting and Grouping (11/7/11)
- Advanced Indexing Filtered Indexes (11/9/11)
- Advanced Indexing Indexing Strategies (11/11/11)
Virtualization: Jorge Segarra (11/14/11)
- Virtualization Basics (11/15/11)
PowerPivot: Jen Stirrup (11/21/11)
- PowerPivot and ATOM Feed Mashup to PerformancePoint (11/23/11)
- Introduction to PowerPivot and Mobile Business Intelligence (11/24/11)
- PowerPivot, Tableau and Jedi Knights (11/26/11)
SSIS Deployment: Julie Smith (11/28/11)
- SSIS 2012: Deploying Projects (11/29/11)
- SSIS 2012: Deployment Lesson I Part A (12/1/11)
- SSIS 2012: Deployment Lesson II Part B (12/2/11)
Data Modeling: Audrey Hammonds (12/5/11)
- Conceptual Modeling (12/5/11)
- Entity-Relationship Modeling Part I (12/7/11)
- Entity- Relationship Modeling Part II (12/9/11)
MDX 101: Stacia Misner (12/12/11)
- SQLU MDX Week: Location, Location, Location (12/13/11)
- SQLU MDX Week: Writing Simple Queries (12/14/11)
- SQLU MDX Week: A Gentle Introduction to Sets (12/15/11)
PowerShell: Aaron Nelson (12/19/11)
=====================================================================
Spring Semester 2011
PowerShell I: Aaron Nelson (1/18/11)
- PowerShell Week at SQL University – Post 4(1/18/11)
- DBA Coach LaRock: PowerShell Redux (1/19/11)
- PowerShell Week at SQL University – Post 5 (1/20/11)
- PowerShell Week at SQL Univesrity – Post 6 (1/20/11)
Advanced SSIS: Josef Richberg (1/24/11)
- SQL-U Day One Advanced SSIS : Multi-path execution of Data Flow Component (1/24/11)
- SQL-U Day Two Advanced SSIS: Sourcing a Stored Procedure (1/25/11)
- SQL-U Day Three Advanced SSIS: Custom Destination Components(1/26/11)
- DBA Coach LaRock: Advanced SSIS Week (1/26/11)
- SQL-U Day Four Advanced SSIS: Enhanced File Importing (1/27/11)
Reporting Services: Jes Borland (1/31/11)
- SQL University – SQL Server Reporting Services Configuration Files Overview(2/1/11)
- DBA Coach LaRock: SSRS Week (2/2/11)
- SQL University – SQL Server Reporting Services: Exploring the RSReportServer.config File (2/3/11)
Security: K. Brian Kelley (2/07/11)
- SQL University – Architecting SQL Server Security, the Big Picture (2/7/11)
- SQL University – SQL Server Security Architecture – 3rd Party, No Options(2/8/11)
- DBA Coach LaRock: Security Week (2/8/11)
- SQL University – SQL Server Security Architecture – 3rd Party, Some Options (2/9/11)
- SQL University – SQL Server Security Archtecture – Home-Grown, No Options!?! (2/10/11)
- SQL University – Home-Grown, with Real Options! (2/11/11)
Data Warehousing: David Stein (2/14/11)
- SQL University – Dimensional Modeling and Why it Doesn’t Suck (2/14/11)
- SQL University – Creating a Data Warehouse Step 1 (2/15/11)
- SQL University – Dimensions, It’s All Meaningless Without Them(2/16/11)
- DBA Coach LaRock – Data Warehousing Week (2/16/11)
- SQL University – Facts, Show Me The Money! (2/17/11)
- SQL University – Resistance is Futile (2/18/11)
Professional Development: Andy Leonard / Ted Krueger (2/21/11)
- Professional Development Week, an Introduction by Ted Krueger (2/21/11)
- Professional Development Week, Comfort Zoneby Ted Krueger (2/22/11)
- DBA Coach LaRock – Professional Development Week (2/22/11)
- SQLU Professional Development Week: The Difference Between Your Business and Community Presence by Andy Leonard (2/23/11)
- Professional Development – Building Relationships by Ted Krueger (2/24/11)
- SQLUniversity Professional Development Week: Learning to Fly by Andy Leonard (2/25/11)
Administration: Mike Walsh / Robert Davis 
(2/28/11)
- SQL DBA Week – You Can Restore It! (Right?)by Mike Walsh (2/28/11)
- DBA Coach LaRock – SQL University Administration Week (2/28/11)
- SQLU DBA Week – Recovering Lost Data by Robert Davis (3/1/11)
- SQLU DBA Week – Set It And… by Mike Walsh (3/2/11)
- SQLU DBA Week – Be An Efficient DBA by Robert Davis (3/3/11)
- SQLU DBA Week – DBA Progress Report by Mike Walsh (3/4/11)
Women in Technology: Audrey Hammonds / Jennifer McCown / Jes Borland / Julie Smith / Wendy Pastrick (3/7/11)
- SQL University Women in Technology Week: My Name is Jes, and I’m a WITby Jes Borland (3/7/11)
- DBA Coach LaRock – Women in Technology Week (3/7/11)
- SQL University – We Could Be Heroines…Not Just For One Day by Julie Smith (3/8/11)
- SQL University – Sometimes Saying Yes is All About Saying No by Audrey Hammonds (3/9)
- SQL University – Teach Your Children Well by Jennifer McCown (3/10)
- Wrapping Up WIT Week at SQL University by Wendy Pastrick (3/11/10)
SPRING BREAK (3/14/11)
- No classes
- Live Lecture: Women in Technology (recording)
Storage: Denny Cherry (3/21/11)
- Expanding Local Storage with Minimal Downtime(3/21/11)
- DBA Coach LaRock – Storage Week (3/21/11)
- Why Can’t I Just Use RAID 10 For Everything? (3/22/11)
- DAS, NAS, and SAN Oh My! (3/23/11)
- What is Faster SAN or DAS (local disk), and Most Importantly Why? (3/24/11)
- SQL Backup Compression and Backup Dedup are Mortal Enemies (3/25/11)
Cloud Technology: Buck Woody (3/28/11)
- SQL U Cloud Computing – Class 1(3/28/11)
- Coach LaRock – Cloud Week (3/28/11)
- SQL U Class 2 – Use Cases (3/30/11)
- SQL U Class 3 – Objections to Cloud Computing (4/1/11)
Performance Tuning: Grant Fritchey / Ted Krueger (4/04/11)
- SQL University: Recommendations for a Clustered Index by Grant Fritchey (4/04/11)
- SQL University – Performance Weekby Ted Krueger (4/05/11)
- Coach LaRock – Performance Tuning Week (4/05/11)
- SQL University: Index Usage by Grant Fritchey (4/06/11)
- Compress Data Partition Snapshots with SSIS by Ted Krueger (4/07/11)
Administration VLDB: Robert Davis (4/11/11)
- SQLU VLDB Week – Intro to VLDBs (3/7/11)
- SQLU VLDB Week – Intro to VLDBs, part 2(4/11/11)
- Coach LaRock – VLDB Administration (4/12/11)
- SQLU VLDB Week – Index Maintenance (4/12/11)
- SQLU VLDB Week – Backups (4/13/11)
- SQLU VLDB Week – Integrity Checks (4/14/11)
- SQLU VLDB Week – Archiving and Purging Data (4/15/11)
High Availability/ Disaster Recovery: Geoff Hiten / Robert Davis / Allan Hirt (4/18/11)
- SQLU Post #1: What’s In a Name? (Part One)by Allan Hirt (4/18/11)
- Coach LaRock – HA/DR Week (4/19/11)
- SQLU HA/DR Week – Database Mirroring Performance Counters by Robert Davis (4/20/11)
- SQLU Post #2: Remote Hosting, Availability, and You: (Im)Perfect Together? by Allan Hirt (4/24/11)
PowerShell II: Aaron Nelson / Grant Fritchey / K. Brian Kelley (4/25/11)
- Who Has Access to My Server?by K. Brian Kelley (4/26/11)
- Coach LaRock: PowerShell Week Part Deux (4/25/11)
- SQL Azure and PowerShell by Grant Fritchey (4/28/11)
Advanced SSIS II: Jorge Segarra (5/02/11)
- SQL University: Parents Just Don’t Understand(5/3/11)
- Coach LaRock: Advanced SSIS Week Part Deux (5/2/11)
- SQL University: Precedence Constraints (5/5/11)
Analysis Services: Stacia Misner (5/9/11)
- SQLU SSAS Week: Why Do I Need a Cube & How Do I Get Started?(5/9/11)
- Coach LaRock: SSAS Week (5/9/11)
- SQLU SSAS Week: Dimension Design 101 (5/11/11)
- SQLU SSAS Week: Cube Construction 101 (5/12/11)
- SQLU SSAS Week: Cube Enhancements 101 (5/15/11)
- SQLU SSAS Week: Cube Deployment 101 (5/17/11)
Internals: Erin Stellato (5/16/11)
- SQL University – Internals By The Numbers(5/16/11)
- Coach LaRock: Internals Week (5/18/11)
- SQL University – Internals and Updates (5/18/11)
- SQL University – Internals and Deletes (5/20/11)
Troubleshooting (5/23/11): Dave Levy
- Troubleshooting Week Syllabus (5/23/11)
- Troubleshooting Week: Communication (5/24/11)
- Troubleshooting Week: Keeping an Open Mind (5/26/11)
- Troubleshooting Week: Having a Plan For Every Situation (5/27/11)
=====================================================================
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)
- Other Capacity Issues (7/30)
=====================================================================
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
- [Updated link coming soon] 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
- 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)
Pingback: Data Inspirations » SQLU MDX Week: Writing Simple Queries
Pingback: Data Inspirations » SQLU MDX Week: An Introduction to Sets
Pingback: Steven’s Notebook » Blog Archive » Intro/Refresher Resources for SQL
Pingback: April #Meme15 Assignment « Just A Bunch Of Gogorichie
Pingback: Presenting at SQL Saturday Houston | Made2Mentor