Tag Archives: sql server

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

Auditing Matters

Posted on February 24, 2014 by way0utwest

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

Posted on February 21, 2014 by way0utwest

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

Virtual Lab – Creating Differencing Disks

Posted on February 20, 2014 by way0utwest

This is part of my series on building a virtual lab for use with SQL Server and Windows. You can see the entire series here: Building a Virtual Lab with Hyper-V. The whole point of virtualization is better use of … Continue reading →

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