Tag Archives: sql server

Transferring Table Types

Posted on September 25, 2012 by way0utwest

An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move a table type between schemas?” Suppose I had two schemas: CREATE SCHEMA OldSchema ; GO CREATE SCHEMA NewSchema ; GO … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Transferring Table Types

Creating a User Defined Table Type

Posted on September 19, 2012 by way0utwest

I saw a post about a user defined table type in SQL Server and I was sure it was a typo. I kept thinking the poster meant table variable, but when I searched the term in Books Online, I was … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Finding DDL Triggers

Posted on September 13, 2012 by way0utwest

Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious way to tell that a table has a trigger on it and since most tables don’t have triggers, this is … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Finding DDL Triggers

Enable Transparent Data Encryption

Posted on August 28, 2012 by way0utwest

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do, and it’s rather mechanical, so I just show the image that has the steps from MSDN and leave it at … Continue reading →

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