Blogging from the Cayman Islands to the world...

How to split a 40GB file into smaller pieces

This is useful if you need to upload or FTP a really large file.  If you have ever tried to FTP more than say 10GB, there is a chance your connection could drop during the transfer, meaning you have to start all over…

Read more

Who’s taking the Office 365 Exam?

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…

Read more

Make results pretty with 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.

Read more

Error creating AdventureWorks2012

So you downloaded the AdventureWorks2012 database, and want to know what to do with the 190MB MDF file.  You cannot just go to New Database or Attach Database in the GUI.  Instead you need to run a query to create the database using…

Read more

Why take Database Fundamentals – Exam 98-364?

If you are new to Microsoft certifications but interested in Database Administration, this exam is perfect for you.  It doesn’t count towards your MCSA but it gets you ready for a much harder exam.

Read more

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…

Read more

TSQL – What’s the difference between the Decimal and Numeric data types?

Decimal and Numeric are functionally equivalent according to documentation. https://msdn.microsoft.com/en-us/library/ms187746.aspx

Read more

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…

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…

Read more

History of SQL – SQL vs the Relational Model

SQL was based on the Relational Model, but is not necessarily confined by all the rules of the relational model.

Read more

History of SQL – Set Theory and Predicate Logic

SQL evolved from two branches of Mathematics – Set Theory and Predicate Logic.  Here are some key points to understand.

Read more

Where can I download SharePoint 2010?

Now that SharePoint 2013 is out it’s a bit harder to find the link to download SharePoint 2010.  Some of the links on Microsoft’s site seem to take you right back to the 2013 page.

Read more

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…

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…

Read more

Download SharePoint 2010 Prerequisites as Standalone Packages

Here are the links to download the SharePoint 2010 prerequisites manually.  This is useful if you don’t have an Internet connection during the SharePoint setup process and need the standalone installers.

Read more