SQL University:Fall 2009 Syllabus

Posted on

Listed below is the Fall 2009 Syllabus for SQL University. Please refer back here often as weekly topics/presenters/dates may be subject to change. Each week each professor is asked to present between 2 and 3 articles on a given topic. The days where you see as Optional are listed in case the presenter that week […]

SQL University:Faculty and Bookstore

Posted on

Good morning everyone! I just wanted to pass along this announcement that we now our page up for our inaugural faculty for SQL University. You can find the Faculty page here. Yesterday we unveiled our new SQL University bookstore. At the bookstore you can find book titles that are highly recommended by fellow DBA’s, developers […]

SQL University: Basic Tools Pt. II

Posted on

In Tuesday’s class we covered the different authentication methods as well as did a quick walk-through of the SQL Management Studio interface. In today’s lecture we’ll continue looking at SSMS. Some of the things we look at include how to create a query against a database, brief intro to the Profiler tool as well as […]

Policy Based Management: A Brief Walk-through

Posted on

Over the last few months I have been doing the rounds at various user groups and SQL Saturday events presenting on Policy Based Management. In the spirit of my on-going SQL University project as well as the upcoming book I’m co-authoring with Ken Simmons (Blog | Twitter) and Colin Stasiuk (Blog | Twitter), I’ve thrown […]

SQL University: Basic Tools

Posted on

Welcome to the first day of SQL University. Today we’re going to be talking about basic tools you’ll be using as a database administrator (DBA). Throughout our lessons you will notice I will be linking heavily to SQL Server Books Online. Books Online is the official documentation for all things SQL Server. This is important […]

SQL University: Orientation

Posted on

Ok everyone, please take your seats. Thank you. Welcome to SQL University, my name is Jorge Segarra and I’ll be helping you start on your journey to SQL Server. You’re here because you either are curious about SQL Server and wish to start down that path or you’ve become an accidental DBA in your organization […]

SQL University: A Primer for SQL Server Beginners

Posted on

Recently I was thinking about my experiences with all of the SQL Server learning events and while they have all been absolutely awesome I realized one thing: they’re that awesome for me because I know what’s going on. By that I mean I’ve been around SQL Server for awhile now so when I attend the […]