Preparing for the Office 365 Exam 70-346

I created these questions based on notes from watching a really good MVA course and I am only guessing that you ought to expect questions like these on the exam.  I constructed my notes in the form of questions because, well what better way to study than to write your own questions?  I am using… Read More »

TSQL – row_number()

You can use row_number() to sort and number the results.  This can be useful for creating a view that shows a custom sorting order.  But first, here are some different ways you can work with this function.

Study Tips – How to remember numeric data types?

How boring is it to learn a page full of data types just for an exam?  That’s like learning the periodic table inside out.   Besides, you can always google these things when you need them.  Wrong answer!  If you want to be a master of this you should knows these things blindfolded.

Studying for Exam 70-461?

If you are studying for the 70-461 exam like myself, then purchase Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 from Amazon.  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… Read More »

SQL – Logical Query Processing Phases

Here we are going to learn a little more about how queries are written and processed.  Please note that SQL queries should be written in a certain order of operation (known as “keyed-in order”), and this order is not the same as the order the query is processed in.

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… Read More »

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?!!