Category Archives: Uncategorized

Normalizing Performance

Posted on November 2, 2014 by way0utwest

This week I ran across a post from Glenn Berry on hardware performance that I thought framed the concept of performance value well. In the post, Glenn talks about the latest TPC-E benchmark and the SQL Server performance values that … Continue reading →

Posted in Uncategorized | Tagged , , | Comments Off on Normalizing Performance

Better Presentations–Hide those Windows

Posted on August 26, 2014 by way0utwest

This is part of a series of tips for speakers to make your presentations better. I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, … Continue reading →

Posted in Blog, Uncategorized | Tagged , | 8 Comments

Fixing CREATE TABLE

Posted on February 27, 2014 by way0utwest

I’ve always wondered about this. When I create a stored procedure I do this: CREATE PROCEDURE MyProc @param1 int as BEGIN   — add code here END; As is often the case, I realize that I’ve made some mistake and need … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Fixing CREATE TABLE

Two Steps Ahead

Posted on October 25, 2012 by way0utwest

  Exceptional DBAs do more than respond to events and issues in their environments. In many cases, I think they even go beyond using metrics that detect problematic activity on their systems before users notify them. I think the best DBAs … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Two Steps Ahead