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
- 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 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)
Very good so far! I am using SS2005 Workgroup edition, so I don’t see some of the same things you’re showing, but I have learned something with every class, thanks!
Good news David! You can check out all the features of SQL 2008 by heading over to the new computer lab at http://sqlserverbeta.com .You’ll have access to your very own instance of SQL 2008 Developer Edition!
Just wanted to point out that it’s been a week since I signed up at http://sqlserverbeta.com, and have sent two emails to support, with no response at all – Jorge, do you have an in, and know or can find out what gives?
David, I’m not sure what the hold up is as I signed up individually as well. I will email them and find out what the status is. I had asked them to setup a dedicated lab for SQL University as well so if your individual one doesn’t come in you should be able to use that one. I’ll keep you posted.
Well, I don’t know, but the same time I got notification of your comment, I got the following from gmail also…
Delivery to the following recipient failed permanently:
support@sqlserverbeta.com
So even emailing them isn’t helping. I’ll see what I can do with the dedicated lab for #SQLU
David, I spoke to Sarah and looks like they had a technical glitch on their side. From now on all emails to them should get there fine. They have since resent confirmation emails to everyone who signed up so check your mail (also check your spam folder as they said emails from admin(at)sqlserverbeta(dot)com ) might go there.
I like your site
I like how you write !:)
Thank you very much! I hope you find the posts/SQL U useful.
Amiable post and this fill someone in on helped me alot in my college assignement. Thanks you as your information.
There’s good info here. I did a search on the topic and found most people will agree with your blog. Keep up the good work mate!
That is a great list of topics even people working on SQL should go over again. Of course very useful as a 101 course for new learners.
hi…..
Hello…
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! Its always nice when you can not only be informed, but also entertained! Im sure you had fun writing this article.
Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!!
http://www.sqlservermasters.com/
The “SQL Admin Pt 2: SQL Server Error Logs” link is not working. 404.
Love the rest. Thanks for all the efforts you put in.
I really like. Great content.