Link : Move Database Data Without Taking the Database Offline

This article shows how you can move database data to a new .MDF data file via the ALTER DATABASE and DBCC SHRINKFILE commands.

Pros

1. Can be done online 

Cons

1. Speed 
2. Cannot move system objects 
3. Index Fragmentation may be caused

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

MCSE : Data Platform SQL 2012

Over the past 3 weeks I have taken (and passed) the following three SQL Server 2012 upgrade exams -

• 70-457 : Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 
• 70-458 : Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 
• 70-459 : Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

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