SQLSaturday 31 Chicago: Recap

Posted on

Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d like to again give a HUGE thanks the organizers of the event: Wendy Pastrick (Blog | Twitter), Aaron Lowe (Blog | Twitter) and Ted Krueger (Blog | Twitter) as well as all of the awesome […]

Upcoming Presentation: SQL Server 101 Series

Posted on

I’m extremely proud to announce that I’ll be a part of a fantastic webinar series being put on by Pragmatic Works on SQL Server 101. Basically a 2-week-long series of webinars covering all the information you need to know to get started in SQL Server. I’ll be leading off the week with Introduction to Managing […]

Beware Vendor Databases

Posted on

This is just a quick post to serve as a warning sign to those who are DBAs in shops where you routinely get vendor pre-packaged databases (which should encompass about 99% of you). Today we had a vendor installing a new application which required a SQL database, to which I am ever thankful. Unfortunately this […]

SQL University History Week II: Current Events

Posted on

Welcome back students! In our last lesson we covered the history of SQL Server, the product. This is important stuff to know in order to understand the evolution of the technology you’re working with. SQL Server has made many strides and it continues to do so to this day. Today’s lesson we’re going to cover […]

SQL University:Computer Lab at SQLServerbeta.com

Posted on

Good afternoon students, this is just a quick announcement to let you know that SQL University (sort of) is offering a computer lab for students to cut their teeth on SQL 2008 technology. I say sort of because this lab is actually offered via a partnership with PASS, Maximum ASP, and DELL Computers at http://www.sqlserverbeta.com . […]

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: 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 […]

PASS Virtualization VC Webcast: Virtualizing SQL Servers

Posted on

For those who don’t know, PASS has several Virtual Chapters. Each VC has its own distinct topic they focus on. The most recent VC established is the Virtualization Virtual Chapter (say that 3 times fast). Our group is dedicated to helping spread the education of virtualization to folks who are thinking of jumping into the […]

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