The MicroTrain Blog

Why words in T-SQL turn blue?

by Cecille Ramirez on January 31st, 2011

This is a pretty common question for students beginning with SQL Server writing queries regardless of the version. Why some words turn blue when you type it in the query window using any T-SQL statement?

These are reserved keywords. Microsoft SQL Server uses these for defining, manipulating and accessing databases and all objects in it. It is part of the grammar of the T-SQL that allows SQL Server to parse and understand T-SQL statements. It maybe sometimes allowed using these reserved keywords for object names in a script but not recommended.

It is best to always use unique names for every object in your database. Make it a habit so you don’t encounter errors in the future. It will be difficult to analyze eventually what’s causing the error when you have overlooked the use of reserved keywords.

For the list of SQL Server 2008 reserved keywords, you can find it in this link:  http://msdn.microsoft.com/en-us/library/ms189822(v=SQL.100).aspx

Preparing To Be Prepared

by Kassandra McGhee on January 31st, 2011

"He who fails to plan is planning to fail." –Winston Churchill

Is your 2011 job search off to a great start?  Or are you having problems following your path to success? 

Well, getting started can be easy…but staying motivated can be difficult.  So what’s the secret?  It’s all about the plan and setting milestones along the way to the ultimate goal of your dream job!

Revisit your job search plan and ask yourself:

  • Is my career goal still realistic?
  • Am I achieving my daily, weekly and monthly job search goals?
  • What obstacles have I faced in achieving my goals?
  • Is there anything I need to do differently?

February is fast approaching and now is the time to make sure your 2011 foundation is solid!  Having a clear map and not diverting from what’s working is essential to your success! 

Prepare and stay prepared!  Plan and keep on planning!  This is a great skill that will also be quite valuable to your employer!

Take the time to get it right and reap the rewards!  2011 Dream Job…let’s go!!

Raves & Praise

Christopher Fowler

MCSA

Very thorough, good mix of lecture and lab work. Al is great! Keeps classes interesting and supplements required test material with need-to-know items from real world experience.

Karine Bucci

Project Management

Great class, loved the interaction and team-building exercises. Plenty of materials and learning tools supplied. Although it was a full week's class, never boring. Donna [Russell] was awesome and gave many supporting examples for better understanding.

Kaycee Ekufu

MCSA

The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.

Jean S.

PMP Certification Training, Lombard, 2008

I was laid off for many months and not really getting many callbacks for my resume and no job offers. After I put the letters PMP on it, not only did I see an increase in quantity, but also quality of interviews. I had been spinning my wheels for 5 months, and after the PMP went on, I had 2 job offers in 6 weeks. It really was the "golden ticket"

Ron Cwik

PMP Certification Training, 2008

Great training facility. Great instructors. Great experience.

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top