Study Tips – How to remember number data types?

How boring is it to learn a page full of data types inside out just to get tested on it?  That’s like a chemist learning the periodic table inside out.   You can always look these things up when the time comes but if you want to be a real database professional you should knows these things blindfolded.

Continue reading Study Tips – How to remember number data types?

Studying for 70-461 and Reading the book

If you are studying for the 70-461 exam like myself, reading the book (Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012) from Microsoft is undoubtedly the way to go.  So far I have waddled through the first 150 pages, some parts requiring more time to absorb than others.  I’ve been stuck on chapter 4 for quite some time as the concepts start to build on each other slightly, but nevertheless moving forward.

Continue reading Studying for 70-461 and Reading the book

SharePoint 2010 Evaluation License

Usually the trial version and full installation packages are the same, and you get the option to skip this step and use the trial.  However, in SharePoint 2010 you get a rather bold screen that forces you to enter a key.  If you are wandering, yes there is a Trial license key that you can use.  In fact, there are about 4 to choose from.

Continue reading SharePoint 2010 Evaluation License

Install ADOMD.NET for SharePoint 2010 Prerequisites

If you are downloading the prerequisites for SharePoint 2010 manually, you will most likely pull your hair out (and scream a few times) trying to find the right version of Microsoft SQL Server 2008 Analysis Services ADOMD.NET.  You have probably already tried several different versions and still cannot pass the check.  What’s going on?!!

Continue reading Install ADOMD.NET for SharePoint 2010 Prerequisites