SQLTeach (Part of the DevTeach Conferences in Canada) has enjoyed success for many years.  I enjoyed the opportunity to speak at and attend SQLTeach at various times over the years.  Since SQLTeach is part of DevTeach, the ''feel'' of the event is very different from PASS or SQLRally or even a SQL Saturday where SQL is the primary ...

I get several more ''generic'' IT mags sent to my home.  I usually get them in an attempt to keep up with what is going on in the outside world.  Typically, I look at the lead story and find a nugget or two in the rest. In my recent issue of TechNet magazine, the cover story is on how to Tune up your database by Paul Randall.  He ...

In SQL Server 2008, you can have what is called a ''Filtered Index''.  What does this mean?  An index may be created for a subset of rows in your table.  For instance you could create a filtered index for a ''state'' column if the value is ''CA'' for California; the rest of the states would not have a value.  When you create ...