Category Archives: Uncategorized

Better Presentations–Hide those Windows

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

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

  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

Manage By Delegation

More and more SQL Server instances are being deployed all the time. In fact, with the ease with which we can build a new virtual machine (VM) through snapshotting and cloning, it seems that many administrators are finding that the … Continue reading

Posted in Uncategorized | Tagged , , | 1 Comment