SQL University

The new SQL University Logo

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


Fall Semester 2011

Architecture (Small Businesses): Jorge Segarra  (9/19/11)

Advanced SSIS: Josef Richberg Redgate Exceptional DBA of the Year 2009 (9/26/11)

Troubleshooting: Mike Walsh (10/3/11)

Compression: Bradley Ball (10/10/11)

SSIS Auditing: Mike Davis (10/17/11)

Auditing and Security: K. Brian Kelley (10/24/11)

Professional Development: Mike Walsh / Brian Moran (10/31/11)

Indexing (Advanced): Gail Shaw (11/7/11)

Virtualization: Jorge Segarra   (11/14/11)

PowerPivot: Jen Stirrup (11/21/11)

SSIS Deployment: Julie Smith (11/28/11)

Data Modeling: Audrey Hammonds (12/5/11)

MDX 101: Stacia Misner  (12/12/11)

PowerShell: Aaron Nelson  (12/19/11)

Spring Semester 2011

PowerShell I: Aaron Nelson (1/18/11)

Advanced SSIS: Josef Richberg Redgate Exceptional DBA of the Year 2009 (1/24/11)

Reporting Services: Jes Borland (1/31/11)

Security: K. Brian Kelley (2/07/11)

Data Warehousing: David Stein (2/14/11)

Professional Development: Andy Leonard / Ted Krueger (2/21/11)

Administration: Mike Walsh / Robert Davis (2/28/11)

Women in Technology: Audrey Hammonds / Jennifer McCown / Jes Borland / Julie Smith / Wendy Pastrick (3/7/11)

SPRING BREAK (3/14/11)

Storage: Denny Cherry (3/21/11)

Cloud Technology: Buck Woody (3/28/11)

Performance Tuning: Grant Fritchey / Ted Krueger (4/04/11)

Administration VLDB:  Robert Davis (4/11/11)

High Availability/ Disaster Recovery: Geoff Hiten / Robert Davis / Allan Hirt (4/18/11)

PowerShell II: Aaron Nelson / Grant Fritchey / K. Brian Kelley (4/25/11)

Advanced SSIS II: Jorge Segarra (5/02/11)

Analysis Services: Stacia Misner (5/9/11)

Internals: Erin Stellato (5/16/11)

Troubleshooting (5/23/11): Dave Levy


Spring Semester 2010


Fall Semester 2009

124 thoughts on “SQL University

  1. […] SQL University « SQL University: Basic Tools […]

  2. […] SQL University Comments There are no comments on this post Leave a Comment Only members of SQLServerCentral may leave comments. Register now for your free account or Sign-In if you are already a member.   […]

  3. 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!

    1. 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!

  4. […] got some (actually, 25) lovely and free cheat sheets for web devs. Check out SQLChicken's SQL University!  It's all online, all free, and looks pretty cool (I'm going to get caught up this […]

  5. […] SQLChicken's SQL University!  It's all online and all free, all the time. -Jen McCown, http://www.midnightdba.com/ […]

  6. 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?

  7. 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.

  8. 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:


    So even emailing them isn’t helping. I’ll see what I can do with the dedicated lab for #SQLU

    1. 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.

  9. […] back to class, folks, here at SQL University. This week we're going to take a look at the basics of security for SQL Server. Since this is […]

  10. […] good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on Authentication. Today we're going to […]

  11. […] out of nowhere, Jorge Segarra announced SQL University – a series of blog posts to do exactly the same thing. Instead of trying to take it on […]

  12. […] back to our last class this term on security in SQL Server here at SQL University. According to the syllabus, you should be picking up history next week with Jorge Segarra. SQL […]

  13. […] University Hoops Practice – If you have not heard of the SQL University then you need to pull your head out of the sand. Basically it’s FREE grass roots SQL Server […]

  14. I like your site
    I like how you write !:)

    1. Thank you very much! I hope you find the posts/SQL U useful.

  15. […] University: The Basics of Storage Good morning, class.  Thanks for attending SQL University today.  I have to start by saying I’m more than a little disappointed that most of you […]

  16. Amiable post and this fill someone in on helped me alot in my college assignement. Thanks you as your information.

  17. 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!

  18. […] a side note, Jorge Segara started a similar initiative in 2009 called SQL University along with some of the top SQL Bloggers/Educators/Presenters out there today.  We all get busy of […]

  19. 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.

  20. […] week is SQL University’s “Professional Development” week. Andy Leonard is a pro when it comes to this topic […]

  21. […] I’ll spin the SQL side, obviously… Since it is still Professional Development week at SQL University, I figured I’d post this week. Maybe you’ll take something useful from it, or maybe […]

  22. […] of us realize the value of participating via this service with things like #sqlhelp ,  #SQLU , sharing links to blogs/tips/whitepapers, etc.  Of  course,  there’s also the […]

  23. […] Segarra's (Twitter) SQL University is in full swing. If you've been ditching class, go back and read through the blogs so far: […]

  24. […] our dear friend Jorge (of SQLChicken blog and Twitter fame, and dean of the FREE and ongoing SQL University) bought a MidnightDBA mug, and showed it off […]

  25. […] is Week 4 of the Spring 2010 semester of SQL University – Tools Of The Trade Week. Thanks, Jorge for setting this up! I’m your official […]

  26. […] neat (and free) tools to help you out with SQL Server. This is my second contribution to the SQL University “Tools of The Trade” week […]

  27. […] to PowerShell Week at SQL University.  For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get industry […]

  28. […] This post was mentioned on Twitter by Jorge Segarra, Laerte Junior. Laerte Junior said: RT @SQLChicken: Reminder, next week is Parallelism Week at #SQLU with Professor @AdamMachanic http://sqlchicken.com/sql-university […]

  29. […] You've made it back for the the third and final installment of Parallelism Week here at SQL University. So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how […]

  30. […] will be taking a week of lessons as a faculty member of good old #SQLU, SQL University, that awesomeness created by Jorge Segarra, better known in the Twitter world as @sqlchicken. My […]

  31. […] to announce that Jorge Segarra, @SQLChicken, (Twitter | blog) has asked me to join the faculty of SQL University! I will be assisting with Community Service Week and Women In Technology […]

  32. […] the SQL Server Community! Jump to Comments Welcome to SQL University Community Week. The SQL Server user community is, in one word, awesome. There are hundreds, no, […]

  33. […] at SQL University, it’s Community Service Week and they’ve already had three great posts by Jes Borland, […]

  34. […] to week 11 of the Spring 2010 semester of SQL University – it’s Women in Technology Week.  My colleague, Prof. Jes Borland (blog, Twitter), will […]

  35. […] the introductory post for Women in Technology week over at SQL University, Jen McCown (Blog | @MidnightDBA) asks some good questions, which I’ve reprinted here and […]

  36. […] Started SQL University , which has turned into a tremendous […]

  37. […] back to SQL University! My esteemed colleague, Prof. Jen McCown (blog | Twitter), and I are bringing you lessons on Women […]

  38. […] This post was mentioned on Twitter by Jorge Segarra, Rebecca Mitchell. Rebecca Mitchell said: Been meaning to! :-) RT @SQLChicken: @k7cb @sqlprincess report for class then! http://bit.ly/dlFVSK #sqlu also follow @sqluniversity […]

  39. […] In my last blog post, I mentioned one way I am giving back; I get to be part of the faculty of SQL University. That’s a great honor. Another, ongoing way I give back, and I am not sure how many know […]

  40. […] Friday and you’re already looking out the window, but let’s get through one more SQL University WIT lecture before we hit the lakes/beaches/yardwork.  Please hand Monday’s […]

  41. […] SQL University, known as #SQLU on Twitter, is the brain child of Jorge Segarra, who blogs at The SQL Update Statement, and can also be found championing the Social side of DBAness as @SQLChicken on Twitter. The community owes Jorge a deep debt of gratitude for making #SQLU possible. The gathering and dissemination of knowledge is one of the highest achievements to which a community can aspire, and it takes great leadership to do such, which is why, I am sure, Jorge has been nominated for the prestigious Exceptional DBA Award. […]

  42. […] in to DBA as a career, I found a multitude of great resources, but one in particular caught my eye, SQL University. SQL University is the brain child @SQLChicken aka Jorge Segarra. It is a collaboration of SQL […]

  43. […] today’s class at SQL University, (#SQLU on Twitter, the brain child of Jorge Segarra, who blogs at The SQL Update Statement, and […]

  44. […] 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 […]

  45. […] 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 […]

  46. […] 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 […]

  47. […] 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 […]

  48. […] 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 […]

  49. […] 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 […]

  50. […] 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 […]

  51. […] 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 […]

  52. […] will be serving on the faculty of SQL University for two courses in the next two […]

  53. […] I did a week-long blog series on PowerShell with SQL Server for SQL University. […]

  54. […] 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 […]

  55. […] up to me at SQL Saturday and tell me how much they learned from a post. I am a faculty member of SQL University. I think Steve Jones even put one of my blog posts in the SQLServerCentral.com weekly […]

  56. […] how awesome 2010 was – I really stepped up with Twitter and blogging and SQL Saturdays and SQL University, and that has paid off in a big way for me. I got the new job, working for Kimberly Clark, and I […]

  57. […] Brent encouraging others to give back and blog, speak, share. I think of Jorge Segarra with his SQL Universityproject that is lumping a lot of SQL Server professionals into targeted blog posts with one goal in […]

  58. […] University. In February, I’ll be teaching a week of Data Warehouse Modeling for The SQL University. I’m honored to be asked and really looking forward to contributing to that […]

  59. […] is the final lecture this week at SQL University. We are covering the topic of capacity planning this week for SQL Servers. In the first lecture we […]

  60. […] by way0utwest on July 26, 2010 I am honored to be a guest lecturer this week for SQL University. There have been some amazing professors helping guide you through SQL Server this semester, and I […]

  61. […] SQL University’s PowerShell Stuff – Nice work! […]

  62. […] Aaron Nelson has been posting PowerShell Week at SQL University info. More about SQL University is at SQLChicken.com […]

  63. […] Smith (Blog | Twitter), Audrey Hammonds (Blog | Twitter), Jes Borland (Blog | Twitter), All the SQL University professors; all of these people and so many more have helped me, taught me, made me a better person, […]

  64. […] SQL University 0 Comments – Leave a comment! « Previous Post […]

  65. […] it’s not revolving, it’s a highly structured and planned class schedule. It’s SQL University curated by Jorge Segarra. Jorge hand picks SQL Server and Business Intelligence experts and forms semester’s worth of […]

  66. […] Friday everyone!  Today’s post is the third and final for SQL University’s Internals week.  Thank you to those of you that have been reading this week, it has been an […]

  67. […] time for some education, peeps, and I am not talking about SQLUniversity, which started two weeks ago.  These are the final days before the first SQLSaturday event in […]

  68. […] during those four years of undergrad.  No go?  Well, until that happens, I’ll keep going to SQLUniversity to learn from the […]

  69. […] Auditing in SSIS can be a real headache. In this two part series blog I am going to try to make it a little easier. You can also download my white paper and sample files on Auditing SSIS here. You can also see this post and more at SQL University. […]

  70. […] my white paper and sample files on Auditing SSIS here. You can also see this post and more at SQL University. Part 1 of the blog is […]

  71. […] of SQL Server is at the beginner level, really – you have no excuse to get better. Just go to SQLUniversity and learn from there. Don’t get […]

  72. […] of SQL Server is at the beginner level, actually – you have no excuse to get better. Just go to SQLUniversity and learn from there. Do not get […]

  73. […] Finally, check out the settings in the rsreportserver.config file. Again, Books Online has a breakdown of each option (RSReportServer Configuration File). Some of the settings here can really be helpful in getting the best performance out of your SSRS server. Remember the Memory Pressure State performance counter I mentioned earlier? Here is where you can define what memory pressure is. There are some great articles online about what each option is used for. One of the best (Exploring the RSReportServer.config File) was written by Jes Schultz Borland (Blog | Twitter) for SQL University. […]

  74. […] take all that we learned and use it to execute packages!  Be sure to check out other lessons at SQL University– LD_AddCustomAttr("AdOpt", "1"); LD_AddCustomAttr("Origin", "other"); […]

  75. […] We’ll finish this tomorrow.  Thanks Jorge for SQLU! […]

  76. […] to Jorge for starting SQLU, and for inviting me to present on a topic I find really exciting.  Be sure to check out […]

  77. […] to SQL University’s Fall 2011 Semester week of Data Modeling.  I’m thrilled to be a part of this great endeavor again, and a giant thank […]

  78. […] to SQL University’s Fall 2011 Semester week of Data Modeling.  I’m thrilled to be a part of this great endeavor again, and a giant thank […]

  79. […] there! Welcome back! Or just Welcome, whichever applies. This week at SQL University (organized by SQLChicken himself, Jorge Segarra) we’re discussing data modeling. On Monday, we […]

  80. […] again, I am serving as the professor at SQL University during MDX week. MDX stands for MultiDimension eXpression language and we use it to add business […]

  81. […] again, I am serving as the professor at SQL University during MDX week. MDX stands for MultiDimension eXpression language and we use it to add business […]

  82. […] post is the second in a series of topics on MDX for SQL University. In my first post, Location, Location, Location, I introduced the tuple as a way to retrieve data […]

  83. […] to my third post in a series of topics on MDX for SQL University. If you’re just now joining me, you should check out the first post, Location, Location, […]

  84. […] You may also wish to check out the SQL University (start […]

  85. […]  http://sqlchicken.com/sql-university/ Great for the newbies and awesome reference points I hope this page never goes away. […]

  86. […] Articulate my official position on the topic of “Women In Technology”.  I have until March when we’ll be blogging on the topic for SQL University. […]

  87. 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!!


  88. 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.

  89. […] SQL University is one of the greatest concepts I’ve seen in the SQL Community. Thanks to Jorge Segarra (Blog | Twitter)for coming up with it and organizing it. Today we are going to talk about something dear and close to the concept of SQL University. Blogging! Blogs are an important part of the concept of SQL University. With them we can easily bring this wealth of knowledge in the course syllabus format with writers from the SQL Community in a vast geographical range and range of expertise. […]

  90. […] ideas. I’ve been honored to be asked to participate in a couple of them. I’ll be a SQL University professor, be a SQL Person, storm the internets for the SQL Denali News Team, and help the PASS WIT […]

  91. […] to SQL Server Reporting Services week at SQL University. This is a great blog project put together by Jorge Segarra (Twitter | Blog), and contributed to by […]

  92. […] to Women In Technology week at SQL University! This is a great blog project put together by Jorge Segarra (Twitter | Blog), and contributed to by […]

  93. […] week is SQL University Performance week.  Grant Fritchey (Blog | Twitter) and myself are on point (get it?).  There are many things we […]

  94. […] that hit home pretty hard and fast.  I was writing an SSIS package to go along with one of my SQL University posts and posted an image of my first initial execution of the package.  See, all of the boxes […]

  95. […] to another day of the Community Service week for SQL University. Jes Borland (Blog | Twitter) wrote an excellent class yesterday on the SQL Community and areas […]

  96. […] to the last day of Community Service week for SQL University. Before we get started, I’d like to say it has been nothing short of a pleasure writing the last […]

  97. […] Cool Community Projects: I’m on the board for MADPASS and PASS WIT. I was a professor for SQL University SSRS week and WIT week. I hosted T-SQL Tuesday. I have other projects coming up. I’m still […]

  98. […] SQL University – This site has information for those people just getting started with the Microsoft stack to more advanced topics. […]

Leave a Reply

Your email address will not be published. Required fields are marked *