career development
SQL Session – Fast Times at SQL Server High
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Latest
career development
SQL Session – Introducing Resource Governor
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the
Posted in: Microsoft SQL
INSTEAD OF Triggers
OK, so we’re all familiar with triggers now, right? You have seen that using a trigger you can log a change to a table in a special log file, or we can create a related record in another table. But all of these events happen after the action that triggers...
SQL201
Variables And Parameters
Transact SQL (T-SQL) has two main wait of passing data, variables, and parameters. A variable is an object in T-SQL batches and scripts that can old a value.
SQL201
Flow Control
When you want to build more intelligent or more flexible T-SQL scripts, you're going to need to know how to control the flow of the program. You'll need the
SQL201
The Error Severity
Errors can have different levels of severity. Based on this severity, you may wish to handle the error in different ways (see my articles on TRY..CATCH). In
SQL102
Triggers Overview
OK, What do you know about triggers? Did you know you can use them to run a bit of T-SQL on data changes? Those would be called Data Manipulation Language
dba
Reindex All Tables in a Database
I just wanted to share a quick script that I used to help re-index all the tables in my database. If you have any questions about it, please let me know! USE
career development
SQL Session – Introducing SQL Server 2008 Performance Data Collector
If you're not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and
microsoft sql
Procedural, Transact SQL — Batches
When building solutions in T-SQL, you'll often be asked to generate a change script. This change script is a batch of SQL statements that when executed
personal
Owego NY
Penny and Mark's family was having a family reunion, and asked if I wanted to go. I'd never been to Owego, NY before, so I thought I'd go. I got to see the town
microsoft sql
DELETE Triggers
This is the last of my three posts on triggers. We've already covered INSERT and UPDATE TRIGGERS. This time we're doing DELETE triggers. All the same rules