Tag Archives: presentations

Common SQL Server Mistakes – Multi Row DML Triggers

Posted on September 23, 2010 by way0utwest

How often have you seen someone write a DML trigger like this: create trigger mytrigger on Mytable for insert as declare @id intselect @id = id from inserted update xx set yyy = zzwhere id = @id return There seems … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – Multi Row DML Triggers

Common SQL Server Mistakes – SELECT *

Posted on September 1, 2010 by way0utwest

I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I go to events. One of the topics that I think has some value, especially for .NET and sysadmin groups, is … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – SELECT *

SQL Saturday #28 – Keynote

Posted on August 26, 2010 by way0utwest

I was honored to be asked to do the keynote for SQL Saturday #28 in Baton Rouge recently. It’s taken me longer than expected to process this and upload it, but here is my keynote speech from a couple weeks … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Saturday #28 – Keynote

SQL Saturday #28 – Slides and Impressions

Posted on August 26, 2010 by way0utwest

I’m late, I suck, but here’s some things I started in Baton Rouge and am just now getting out.   First, I’ll add my slides to the SQL Saturday site soon. I did two presentations and the keynote, which I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Saturday #28 – Slides and Impressions