Archive

Archive for June, 2008

Microsoft Velocity

Microsoft Project Code Named “Velocity”

"Velocity" is a distributed in-memory application cache platform for developing scalable, high-performance applications. "Velocity" can be used to cache any CLR object and provides access through simple APIs. The primary goals for "Velocity" are performance.
 
There is an interesting technical article in the MSDN library: Microsoft Project Code Named “Velocity”.
 
Otherwise, the PPT deck from Tech Ed 2008 is here: 

http://cid-24acf41e6619b235.skydrive.live.com/embedrowdetail.aspx/Public/VelocityTechEd2008.pptx

 
Categories: Microsoft

SQL Server 2005 Service Pack 2 CU 8

Microsoft Released SQL Server 2005 Service Pack 2 Cumulative Update 8

SQL Server 2005 Service Pack 2 Cumulative Update 8 (CU8) is available from Microsoft Help and Support.

Since SQL Server 2005 Service Pack 2 Microsoft has released 8 Cumulative Updates, fixing over 550 bugs:

 

Cumulative Update

Date

Bugs Fixed

SP2

05-Mar-2007

152

CU1

03-Apr-2007

29

CU2

14-Jun-2007

81

CU3

11-Aug-2007

53

CU4

02-Oct-2007

53

CU5

09-Dec-2007

61

CU6

09-Feb-2008

38

CU7

10-Apr-2008

39

CU8

16-Jun-2008

44

The Cumulative Updates reflect Microsoft’s new Incremental Servicing Model for SQL Server, which aims to release the latest updates for SQL Server using a regular schedule (every 8 weeks).

Otherwise, I maintain an Excel 2007 spreadsheet that contains a list of all bug fixes for analysis:

http://cid-a65be80360df3915.skydrive.live.com/embedrowdetail.aspx/Resources/SQLServer2005.CumulativeUpdates.xlsx

Categories: Patches

SQL Server 2008 Release Date

SQL Server 2008 Release Imminent

SQL Server 2008’s release must be imminent…

How else could you explain that the new logo has been "leaked":

I would not be surprised if it was "released in the wild" by late July…

Categories: SQL 2008

SQL Server 2008 Certification

Microsoft Releases Details of SQL Server 2008 Certification

With SQL Server 2008’s release imminent , Microsoft has released the details of the Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) certifications.

(Microsoft have also released a new certification, called Microsoft Certified Master, as I have blogged about before.)

I have posted some resources (somewhat dated) on SkyDrive that you might find handy:

The official preparation guides for all of the SQL Server 2008 exams can be found here:

  • TS: SQL Server 2008, Implementation and Maintenance (70-432)
  • TS: SQL Server 2008, Database Development (70-433)
  • TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (70-448)
  • PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 (70-450)
  • PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 (70-451)
  • PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 (70-452)

It will be interesting to see how the industry adopts the new certification. From my experiences around the world, industry no longer seems to value Microsoft Certification like it once did. Whether it’s due to the current lack of IT professionals in the industry, or a lack of confidence in the MCITP certification is worth blogging about later. The fact remains that the industry is continually seeking highly-skilled DBAs and DBDs.

Perhaps in response to some of the above "concerns", Microsoft has recently revamped it’s certification with announcements about the Microsoft Certified Master (MCM) and Microsoft Certified Architect (MCA) certifications.

The more cynical of us will also note that the New Generation Certification Lifecycle Policies "force people to re-certify". Interesting Microsoft changed their initial communication which stated that a "refresh" would be required every 3 years. The current status is that a MCITP certification will be retired when mainstream support for the related technology retires according to the Microsoft Support Lifecycle.

Undoubtedly all existing Microsoft Certified Trainers (MCT) will be getting their SQL Server 2008 certification as soon as possible. They have to, as without them they cannot officially teach SQL Server 2008 Microsoft Official Curriculum (MOC) courses. Actually, MOC is now referred to as Official Microsoft Learning Products (OMLP), but I digress…

The fact remains though,  that as of April 2008, the statistics for Microsoft Certification worldwide in SQL Server 2005 were:

Certification

Numbers
MCTS: SQL Server 2005 29,038
MCTS: SQL Server 2005 Business Intelligence 1,279
MCITP: Database Administrator 4,701
MCITP: Database Developer 1,841
MCITP: Business Intelligence Developer 556
MCA: Database 13

Which can be hard to interpret, but consider SQL Server 2000:

Certification

Numbers

MCDBA

150,347

Of course you might recall that to get a MCDBA certification, an MCSE only had to do 2 additional elective exams. But there is still some orders of magnitude difference between the MCDBA and the MCITP: DBA.

You can find out more about SQL Server 2008 certification at http://www.microsoft.com/learning/mcp/sql/2008/default.mspx

Categories: Certification

MCITP: SQL Server 2008

Change in the Microsoft Certified IT Professional: SQL Server 2008 Certification

Attaining a Microsoft Certified IT Professional (MCITP) level certification for SQL Server 2008 will be easier than in SQL Server 2005.

Why? Quite simply because you will have to pass less exams.

For the MCITP: Database Administrator 2008 you will need to pass just the following exams:

  • TS: Microsoft SQL Server 2008, Implementation and Maintenance (70-432)
  • PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 (70-450)

For the MCITP: Database Developer 2008 you will need to pass just the following exams:

  • TS: Microsoft SQL Server 2008, Database Development (70-433)
  • PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 (70-451)

With respect to the BI track you will still have to pass 2 exams (as before) for to become a MCITP: Business Intelligence Developer 2008:

  • TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (70-448)
  • PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 (70-452)

So why the change?

Perhaps to encourage a higher adoption of certification… I certainly would suggest that the MCITP certification has not been "pursued" as much as Microsoft would have liked. Reducing the number of exams required to attain a MCITP certification might encourage IT professionals, who would otherwise be "daunted" by the number of exams required, to go for it… The danger, of course, is that the industry might perceive this as "diluting the quality" of the MCITP certification.

I certainly am glad I’m not trying to get the MCITP: Enterprise Administrator on Windows Server 2008, it requires passing 5 exams!

More information: Microsoft Certified IT Professional Developer (MCITP) Certifications for Microsoft SQL Server 2008

Categories: Certification

MCTS: SQL Server 2008

Change in the Microsoft Certified Technology Specialist: SQL Server 2008 Certification

Earlier this year I was involved in helping create the Objective Domain(s) for the new Microsoft Certified Technology Specialist (MCTS) certification for SQL Server 2008.

The decision was made to separate the MCTS exam into 2 separate exams, for:

  • Database Administrators (DBA)
  • Database Developers (DBD)

You will recall that for SQL Server 2005 there was a single exam (70-431) that covered both the DBA and DBD domains.

The consensus was that it was not fair to test both domains in a single exam where a candidate potentially wanted to be only a MCITP:DBD or MCITP:DBA. The other consideration was that we could not adequately test these two domains in a finite pool of questions.

Consequently, for SQL Server 2008 there will be 2 separate MCTS exams:

  • TS: Microsoft SQL Server 2008, Implementation and Maintenance (70-432)
  • TS: Microsoft SQL Server 2008, Database Development (70-433)

More information: Microsoft Certified Technology Specialist (MCTS) Certifications for Microsoft SQL Server 2008

Categories: Certification

Firefox 3.0 Release Date

FireFox 3.0 Download Day

Finally… Mozilla Firefox 3 will be released on Tuesday 17th June, 2008.

Firefox will be able to be downloaded next Tuesday as part of Firefox Download Day when, "hopefully", millions of users will attempt to set the Guinness World Record for the most software downloads in 24 hours.

You can pledge to download Firefox 3 on the 17th June at http://www.spreadfirefox.com/worldrecord/.

Categories: Uncategorized