SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service

Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core service, it should start first, and there is little point to running the SQL Server Agent without it MCITP Certification, MCITP Training.

Off the top of my head, I can offer the following quick reasons for this sequence:

* The SQL Server Engine does not only run jobs for SQL Server Engine itself. It also runs jobs for other core services like the SQL Server Analysis Service, Integration Service, Reporting Service etc.;
* The SQL Server Agent can run almost any kind of task that an Operating system can run. For example invoking any program or running shell scripts;

* The SQL Server Agent also starts jobs which are scheduled to run the second the SQL Server Engine starts, and for this reason it is needed; and
* Replication, mirroring and a few other tasks also depend on Agent Jobs.

These are the reasons that I have come up with so far. Can you think of any more? Let us have your views.

Certification Watch Volume 13 #8

Certification news regarding name changes for Microsoft and ISC(2) certifications, changes to Cisco CCIE lab exams, a new CCNA certification, Microsoft certification on Bing, and the Microsoft Second Shot program.

Microsoft MCAS Reverts to MOS
Beginning June 2, 2010, the certification program for Microsoft Office products will resume using one of its previous monikers, Microsoft Office Specialist (MOS), instead of the current Microsoft Certified Application Specialist (MCAS) title. Apparently the MCAS name never caught on. Current MCAS holders will automatically be considered MOS 2007 certified, but if you want a new certificate, you’ll have to purchase one for “a small fee” through the Certiport portal. Certiport will continue to administer the MOS program.

Get ISACA Certified!

ISC(2) Changes CAP Designation Name, Domains to Follow
As of May 21, 2010, (ISC)2 changed the name of its Certification and Accreditation Professional (CAP) credential to Certified Authorization Professional (still CAP). Individuals who earned the certification under its old name will automatically receive a replacement certificate and lapel pin with the new name. ISC(2) says the name change was made “to reflect updated nomenclature” in the National Institute of Standards and Technology (NIST) publication SP800-37 regarding risk management and federal information systems. The domains for CAP will also be changed from 4 to 7 for the same reason, effective November 2010.

Easy Come, Easy Go for CCIE Core Knowledge Questions
Cisco Systems recently announced that the four “core knowledge” short answer questions that were added to the CCIE R&S and Voice lab exams less than a year ago have been removed. Cisco reports that the rest of the exam does a fine job of validating expert skills, so the four questions are no longer needed. They will continue to appear, however, in other CCIE lab exams. Core knowledge questions are given at the start of the exam, typically require five words or less to answer, and no documentation may be used. More details and related discussions are available on Cisco’s website.

CCNA Service Provider Operations Released
In other Cisco certification news, a new CCNA Service Provider Operations (CCNA SP Operations) designation is available for candidates who want to certify that they have the basic knowledge and skills of a Tier 1 support engineer within a carrier class IP NGN network infrastructure. Candidates who already hold another CCNA certification need only pass the new Supporting Cisco Service Provider IP NGN Operations (SSPO) exam to earn this certification. Candidates without a current CCNA must also pass the ICND1 exam, the exam that leads to Cisco’s entry-level CCENT designation.

MCTS: Bing Arrives
Interested individuals can now earn a Microsoft Certified Technology Specialist (MCTS Training) designation related to Bing. MCTS Certification : Bing Maps Platform, Application Development is a one exam certification covering using Microsoft Visual Studio to create Web applications that use the Bing Maps platform for creating geospatial apps. There is no official course or training material available yet, but you can get warmed up at the Bing Maps Developer Center.

Microsoft Second Shot to Expire June 30
Microsoft’s Second Shot program, which allows candidates a free retake of a failed exam, is slated to conclude on June 30, 2010. The retake must be completed by then. This program will likely be back, but why wait? You must sign up in advance on Prometric’s website to take advantage of this program.