t-sql
SQL 102 – Indexes With Included Columns
I've shown you how to create indexes, CLUSTERED versus NONCLUSTERED indexes, today I want to build on that. Let's say you have a lookup query that takes names,
Shannon Lowder
Certification
70-433:OUTPUT and IDENTITY
Let's look at a scenario you'll need to be able to handle if you hope to pass the 70-433. This scenario requires you to understand the IDENTITY property for a
Certification
70-432: Unique Constraints
Let's cover another scenario that uses knowledge you'll need in order to pass the 70-432. This time we're going to work with constraints. We all know that
Certification
70-432: Revoking Permissions
Today we're going to cover a scenario you might face at work, one that's also a topic you'd need to know in order to pass the 70-432 Database Administrator's
career development
SQL Session – Fortress SQL Server
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
ssis
SQL301-ETL With SSIS, Part 4
We're back to our ETL with SSIS project, and today we're going to pick up with transforming the data from our raw format to the final destination for our
dev
SQL 102 – UNIQUE INDEX
Ok, you understand how to create an INDEX. You understand the differences in CLUSTERED and NONCLUSTERED indexes. Did you know you could index a view? You can.
ssis
SQL 301-ETL With SSIS, Part 3
Ok, so in our SSIS package we currently have all our variables set up, we have a for each loop that will look in a certain folder for all files matching a
t-sql
Code to Write Code
I've read "When you start writing code that writes code for you, you've moved up from a beginner to a professional." Today I'd like to walk you through an
career development
Server 2008 Firestarter Event
The SQL Server 2008 Firestarter event is a 1/2 day, free event for SQL Server developers and administrators. You'll be able to learn about the newest features
t-sql
Get Rid of the Duplicate Records
Time after time I'll get a table that has duplicates in it and I have to clear out all the duplicate entries while leaving a distinct set of records. There's a
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