SQLChicken.com

SQL Server DBA Tips & Tricks

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

=====================================================================

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

Share

123 Responses to SQL University

  1. Pingback: Policy Based Management: A Brief Walk-through | The SQL UPDATE Statement

  2. Pingback: SQL Server Central

  3. Pingback: SQL University:Fall 2009 Syllabus | The SQL UPDATE Statement

  4. Pingback: SQL University: Basketball program! | The SQL UPDATE Statement

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

  6. Pingback: Free Stuff Friday

  7. Pingback: Sing it with me: Free Stuff Friday!!

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

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

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

  11. Pingback: SQL Server Central

  12. Pingback: SQL Server Central

  13. Pingback: What Community Means to Me | Brent Ozar - SQL Server DBA

  14. Pingback: SQL Server Central

  15. Pingback: Something for the Weekend: SQL Server Links 30/10/09 | John Sansom - SQL Server DBA in the UK

  16. university says:

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

  17. Pingback: SQL University: The Basics of Storage | Brent Ozar - Too Much Information

  18. Pingback: אתר המשרות ל-DBA’s עלה לאוויר, מעבדות חינם אונליין, האקדמיה ל- SQL Server, ועוד כותרות השבוע - SQLServer.co.il

  19. Pingback: SQL University Feedback Survey | The SQL UPDATE Statement

  20. WP Themes says:

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

  21. TSwain says:

    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!

  22. Pingback: Start learning about SQL Server | Michael J. Swart

  23. Pingback: Enlist In Training The SQL N00B Crew With Me | The SQL Agent Man

  24. Pingback: SA Does Not Mean Speedy Access | The SQL UPDATE Statement

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

  26. Pingback: SQL University: School is Back in Session - The SQL UPDATE Statement

  27. Pingback: SQL University – Professional Development & Knowledge Sharing | SQL Server Blog - StraightPath Solutions

  28. Pingback: Day Job Lessons From The Garden | SQL Server Blog - StraightPath Solutions

  29. Pingback: The SQL MVTweep Awards ! (#sqlMVT) « mikeSQL's Blog

  30. Pingback: SQL Awesomesauce » Blog Archive » News and Upcoming, or, No Wonder I Get Headaches

  31. Pingback: SQL Awesomesauce » Blog Archive » SQL Saturday #35: 11 days to go!

  32. Pingback: Get You Some Tools – SQL University Spring 2010 | SQL Server Blog - StraightPath Solutions

  33. Pingback: Check Out These Tools – SQL University | SQL Server Blog - StraightPath Solutions

  34. Pingback: PowerShell Week at SQL University – Post 0 – SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V

  35. Pingback: Tweets that mention SQL University - The SQL UPDATE Statement -- Topsy.com

  36. Pingback: Adam Machanic : SQL University: Parallelism Week - Part 3, Settings and Options

  37. Pingback: I’m a #SQLU Faculty Member! « MERGE Learning AS Target USING SQL

  38. Pingback: Twitter asked “What’s happening?”, and 140 characters wasn’t enough « Jes Borland's Blog

  39. Pingback: Meet the SQL Server Community! « Jes Borland's Blog

  40. Pingback: T-SQL Tuesday #007 – Roundup - The SQL UPDATE Statement

  41. Pingback: Matt Velic » Blog Archive » Following the SQL Servo-sphere

  42. Pingback: SQL Awesomesauce » Blog Archive » Introduction to Women in Technology – SQL University

  43. Pingback: Matt Velic » Blog Archive » The Bionic Woman

  44. Pingback: Why I’m voting for @SQLChicken for Exceptional DBA….and you should too « mikeSQL's Blog

  45. Pingback: SQL University: Women In Technology (WIT) Throughout History « Jes Borland

  46. Pingback: Tweets that mention SQL University | The SQL UPDATE Statement -- Topsy.com

  47. Pingback: SQL Community; PASS Call for Nominations; Exceptional DBA; « MERGE Learning AS Target USING SQL

  48. Pingback: SQL Awesomesauce » Blog Archive » Issues for Women in Technology – SQL University

  49. Pingback: Database Design 101a, #SQLU « MERGE Learning AS Target USING SQL

  50. Pingback: SQL University « SQL Newbies Unite

  51. Pingback: Database Design 101b, #SQLU « MERGE Learning AS Target USING SQL

  52. Pingback: Database Design 101c, #SQLU « MERGE Learning AS Target USING SQL

  53. Pingback: MCP Benefits | Shawn Melton (Husband, Father, and DBA)

  54. Pingback: T-SQL Tuesday #008: Gettin’ Schooled | The SQL UPDATE Statement

  55. Pingback: SQL University: Introduction to Indexes « Home of the Scary DBA

  56. Pingback: SQL University: Introduction to Indexes, Part the First « Home of the Scary DBA

  57. Pingback: I’m an MCITP SQL Server 2008 DBA! « MERGE Learning AS Target USING SQL

  58. Pingback: SQL University: Introduction to Indexes, Part the Second « Home of the Scary DBA

  59. Pingback: SQL University: Introduction to Indexes, Part the Third « Home of the Scary DBA

  60. Pingback: T-SQL Tuesday #008: Tips for Giving a Good Interview for the New DBA | SQLSoldier

  61. Pingback: Extracurricular Activities | SQLSoldier

  62. Pingback: Atlanta MDF Code and Slides – SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V

  63. Pingback: Cruisin’ and All Good Things Must End | Obilankenobi's Blog

  64. Pingback: Dear Blog: Happy Anniversary « Jes Borland

  65. Pingback: Un-SQL Friday: Branding | The SQL UPDATE Statement

  66. Pingback: Where does one begin when you want to know everything that is knowable? | LearningSQL

  67. Pingback: Where does one begin when you want to know everything that is knowable? | SQL Server: To Know All That Is Knowable

  68. Pingback: SQL Awesomesauce » Blog Archive » Spotlight: Jes Borland

  69. Pingback: PASS Is Not The SQL Community | StraightPath Consulting's SQL Server Blog

  70. Pingback: Christmas is a Time of Miracles/New Year’s Resolutions | Made2Mentor

  71. Pingback: SQL University – Other Capacity Issues « Voice of the DBA

  72. Pingback: SQL University – Capacity Planning Week « Voice of the DBA

  73. Pingback: SQL University: Spring 2011 | The SQL UPDATE Statement

  74. Pingback: Weekly Challenges – 1/23/11 « SQL Feather and Quill

  75. Pingback: Episode 138 – Parind Shah from EqualLogic « PowerScripting Podcast

  76. Pingback: SQL University: State of the Union | The SQL UPDATE Statement

  77. Pingback: Thank so much #sqlcommunity ! « MERGE Learning AS Target USING SQL

  78. Pingback: Nine Reason Developers Should Learn SQL | Brent Ozar PLF

  79. Pingback: LulzSec: Why You Should Care | The SQL UPDATE Statement

  80. Pingback: How the Community Overcomes being Accidental | Matt Velic

  81. Pingback: SQL University – Internals and Deletes | Erin Stellato | Erin Stellato

  82. Pingback: SQLSaturday60: Who wants to be in my presentation? | Erin Stellato | Erin Stellato

  83. Pingback: Ready for Training: Focus on Learning | Erin Stellato | Erin Stellato

  84. Pingback: SQL University: Architecture for Small Businesses | The SQL UPDATE Statement

  85. Pingback: SQL University: SQL Server Editions for Small Businesses | The SQL UPDATE Statement

  86. Pingback: Small Business Hardware | The SQL UPDATE Statement

  87. Pingback: Setting up SSIS Auditing Part 1 | MikeDavisSQL

  88. Pingback: Setting up SSIS Auditing Part 2 | MikeDavisSQL

  89. Pingback: Argenis Fernandez : A (Late) Meme Monday Post: On SQLFamily

  90. Pingback: A (Late) Meme Monday Post: On SQLFamily | cheapest-server-hosting.info

  91. Pingback: SQL University: Virtualization Basics | The SQL UPDATE Statement

  92. Pingback: Monitoring SSRS Report Performance – Part 4 | SQL Servings

  93. Pingback: SQL University– SSIS 2012: Deploying Projects « The Datachix Blog

  94. Pingback: SQL University – SSIS 2012 Deployments, Lesson Two — Part A « The Datachix Blog

  95. Pingback: SQL University – SSIS 2012 Deployments, Lesson Two — Part B « The Datachix Blog

  96. Pingback: SQL University – Conceptual Modeling « The Datachix Blog

  97. Pingback: SQL University – Conceptual Modeling « The Datachix Blog

  98. Pingback: SQL University – Entity-Relationship Modeling (Part I) « The Datachix Blog

  99. Pingback: Data Inspirations » SQLU MDX Week: Location, Location, Location

  100. Pingback: Data Inspirations » SQLU MDX Week: Location, Location, Location

  101. Pingback: Data Inspirations » SQLU MDX Week: Writing Simple Queries

  102. Pingback: Data Inspirations » SQLU MDX Week: An Introduction to Sets

  103. Pingback: Steven’s Notebook » Blog Archive » Intro/Refresher Resources for SQL

  104. Pingback: April #Meme15 Assignment « Just A Bunch Of Gogorichie

  105. Pingback: Presenting at SQL Saturday Houston | Made2Mentor

  106. Pingback: Reasons Developers Should Learn SQL | Hakkı Konu Blog

  107. Pingback: T-SQL Tuesday #14—Julie’s 2011 Goals in “the Cloud” « The Datachix Blog

  108. sql server masters says:

    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/

  109. Jason Fernandes says:

    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.

  110. Pingback: Less Than Dot - Blog - Awesome

  111. Pingback: Less Than Dot - Blog - Awesome

  112. Pingback: Less Than Dot - Blog - Awesome

  113. Pingback: Less Than Dot - Blog - Awesome

  114. Pingback: Less Than Dot - Blog - Awesome

  115. Pingback: Less Than Dot - Blog - Awesome

  116. Pingback: Less Than Dot - Blog - Awesome

  117. Pingback: Less Than Dot - Blog - Awesome

  118. Pingback: Less Than Dot - Blog - Awesome

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">