Friday, 26 April 2013

Link :32Bit SQL on a 64 Bit Box

I've seen this on a number of boxes now.
32bit SQL in a 64bit environment.

{screams silently}

Thomas LaRock has a script to test for this -

HOW TO: Determine If You Are Running A 32-bit Version Of SQL Server On A 64-bit O/S

Wednesday, 3 April 2013

MCSE : Data Platform SQL 2012

Over the past 3 weeks I have taken (and passed) the following three SQL Server 2012 upgrade exams -
The first 2 exams made me an MCSA, completing the third made me an MCSE for Data platform. A little confusing as I was already an MCSE some years ago. To clarify...

The old world MCSE (I did mine on Windows 2000) stood for Microsoft Certified Systems Engineer.
The new MCSE is an acronym for Microsoft Certified Solutions Expert.

All the new professional exams are MCSEs with the exact titles differing as per the product specialism.

Link : New MCSE Certifications

Monday, 1 April 2013

Link : Relational Databases Aren't Dead.

I like this link.

I like it because academic developers whom are keen on CV polishing are convinced the RDBMS is old news. If it's not an ORM model or even better a NoSQL implementation like Cassandra or MongoDB then it's old hat.

Yes, they can scale immensely which is fantastic but they are not suitable everywhere, Those implementations don't lend themselves to structure, to referential integrity and the beauty of having one master version of a data set.

I'll let the title speak for itself ...

Relational Databases Aren't Dead. Heck, They're Not Even Sleeping