It’s 2005 and I just started with GCS. I was just getting to know my team-mates when one of them told me “you really should check your spelling before you publish a page on your website.” I didn’t know how to respond. I asked my soon to be friend to explain what they were talking…
SQL 202-Covered Indexes
By this point you should feel pretty comfortable with what an INDEX is and what it does for your queries. Basically it provides the server to find your data rows more quickly by creating a look-up to find key values. When teaching indexes I usually open the book closest to me, and show them the…
T-SQL Tuesday-Resolutions
The challenge went out to talk about my techie resolutions. I know I’ve discussed this earlier, but in just a week, I’ve made some progress. Certifications My goal is to complete not one MCITP path, but two! I scheduled my first exam for January 10, 1pm EST. Yes, when this post goes live that will…
SQL 202-Theoretical Exection Orders
When you send a query to the server, there’s an order to the steps the server will take to retrieve the data you’re looking for. It’s important to have an understanding on what order those steps are, so you know where to start making changes in order to minimize the time it takes to optimize…
Online Profiles Vs Online Resumes
Starting the end of 2008 I started noticing a change in my job search I noticed I was getting a lot of emails informing me “I found your resume online, and I believe you would be a great candidate for this position.” At first I didn’t really think a lot about it, since I had…
Checking for Computed Columns
So I’ve been building an auditing system for my new employer that will help track all the changes to the data. Right now, some changes could be made, and we wouldn’t be able to tell who made the change, or when the change was made. I had an “Ah-ha” moment pretty early on. “Let’s use…
SQL 202-Performance Tuning
Honestly, choosing which level to put this content under was one of the harder decisions I had to make when putting this content together. Before you get into this stuff, You need to understand queries pretty well. You should also have the fundamentals on what an index is, and how to manage them (add, alter,…
Happy New Year
2011 is going to be a big year! I’m getting my certification exams out of the way. I’m heading to PASS Summit 2011. I’m pushing myself harder this year, because I know I can do more. What does this mean for you, my very special reader? More content! I’m pushing for more content in 2011…
Product Review: DTS xChange
Late last week I was informed our new servers would be available January 3, and I should be ready to set up my new SQL 2008R2 two-node cluster. I can’t begin to tell you how excited I am about this project! I’d already downloaded the latest backups for my databases, and restored them to my…
SQL 402:Deprecation in SQL Server
Last week at the Charlotte SQL Server User Group, Aaron Bertrand covered What’s New in Denali. During that presentation he mentioned a few of the things that would not be supported in Denali. That got me thinking. I know there are techniques I’ve used that are no longer supported. I made my self a task…