Tag Archives: sql server

Virtual Lab – Setting up a new VM

This is part of a series where I set up a virtual lab for testing and misc. work. The other parts in the series are here: Building a Virtual Lab with Hyper-V. I have my disks set up, now it’s … Continue reading

Posted in Blog | Tagged , , , , , | 1 Comment

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

Auditing Matters

There’s been some reporting about Yahoo Mail getting hacked and potential issues recently. I ran across this piece that talks about what happened and it’s an interesting read, but there’s one quote that stuck with me: “Yahoo reported on its Tumblr that it had … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Auditing Matters

The SQLCLR Impact

While I’m sure there are a few of you still using SQL Server 2000 instances, I think at this point that most companies have moved to SQL Server 2005 and later. Even if you still manage a pre-2005 instance, chances … Continue reading

Posted in Editorial | Tagged , , | 1 Comment