ssis
SQL 301 – ETL With SSIS, Part 2
In my last post on SSIS, I started you into developing an ETL solution with SSIS. I walked you through setting up your solution, renaming the package, and
Latest
t-sql
SQL 102 – CLUSTERED vs. NONCLUSTERED Indexes
Previously, I covered the basics of creating an index using CREATE INDEX. Today, I'm going to dig a little deeper. I'd like to teach you the difference in an
microsoft sql
70-433:Good, Better, Best Index Selection
With SQL Server 2008, you've got some additional tricks you can pull off with indexes. With 2005 you could INCLUDE columns in your index, now with 2008 you can
ssis
SQL 301 – ETL With SSIS, Part 1
I’ve discussed SSIS on this site before, but I’ve heard the feedback, you want real world examples. So, I decided to use the business case I address most often
t-sql
SQL 301 – Views
At this point I'm sure you know how to CREATE and ALTER a VIEW. But today I'd like to go into a little more detail on views. I'd like to cover updatable views,
personal
Things Do Not Change; We Change.
It's a quote from Henry David Thoreau. Well, It's been about two weeks since I left my last job. And even in that period of time lots has happened. I believe my
t-sql
Find Tables Containing a Certain Column
Today I had to find all the tables that contained a certain column. I was going to rename the column, so it made more sense when you see it in my tables. In
career development
SQL Session – Tips and Tricks for Writing Better Queries
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
microsoft sql
sp_executesql
I'm pretty sure this is the first time I've brought up dynamically generated SQL statements. But it's time you learn about them. There are times where you'll
SQL102
Nesting an Exception
Like just about every other technique in Microsoft SQL you can nest your exception handling. The basic template is: BEGIN TRY BEGIN TRY -- Nested try
Good News Everyone!
Nov 20 Good News Everyone! It’s been a while since I’ve been on here, but I have good reasons. I’ve been working at my current employer for three and a half years. I no longer see this place in a positive light. So I’ve worked hard to find a better...
SQL102
DDL Triggers
Introduction OK, we all know that when we create objects in a database, we're using Data Definition Language (DDL) commands. Every time we create an object,