Every stored procedure I inherit tells me something about the engineer who wrote it. The ones with no error handling tell me they never had to debug a silent failure at 2 a.m. The ones with a bare EXEC sp_something and no transaction management tell me nobody ever
t-sql
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,
Certification
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
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
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
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
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
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
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
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
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
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