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

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.

Scott Wilson - Team Bradley

Employer Partner Feedback

Dawn has been a pleasure to work with. She is diligent in her efforts to give MicroTrain’s students the best opportunities to connect and network with various companies and players in the job market. The curriculums and certification programs are in line with today’s current IT needs. It’s good to see that they evolve with what employers are most seeking out there. I would recommend to any employer that hires skilled IT workers that they look into MicroTrain’s career services department as a potential source of candidates. The business of hiring can be quite costly, and Dawn and her staff provide a free service to outside companies. This value-add for MicroTrain’s students aligns with their mission in both training and job assistance to set up a win/win scenario for all involved.

David

A Cisco Success Story

I attended a resume writing seminar & conducted mock phone interviews with a Microtrain career counselor. These two activities gave me a leg up on distinguishing myself from all the other people looking for work. Since the career counselor's at Microtrain had a track record of getting people hired, their insight and positive past experiences helped me tremendously in getting hired with a Cisco Voice Systems Integrator in the Chicago area. I was hired as a Cisco Voice Tech Engineer with a starting salary of $65,000 / year with a Cisco voice systems reseller located in the Chicagoland area. Microtrain was very instramental in making this a reality. From expediting my WIA grant, to providing excellent hands-on training from knowledgable instructors I was able to achieve becoming certified with my CCNP. Microtrain's career services was the final catalyst in connecting me with this company by communicating with them on my behalf and with me in setting up the interview. One week later and I was hired. No joke. Thanks Microtrain!

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.

Jennie

Student Employment Success - Project/Process Manager

My Career Services Manager was very friendly and helpful and had excellent follow-up. She seemed to really care how things were going and kept me moving in the right direction. The resources available in job search were great and the visibility that there were jobs out there looking for my skillset was promising. Additionally, the training, as well as having an updated resume stating the Microtrain course work I had taken made me feel more confident and marketable as I looked for employment. It showed that I was dedicated and took project management and process management seriously.

Connect with MicroTrain

Begin building a successful long-term career pathway.

(630) 981-0200

Back to Top