SharePoint 2016 Beta – Azure SQL PaaS Content Database

New with SharePoint 2016 is the hidden ability to use Azure SQL PaaS as a content database.  While the product is still in preview I have found that the sites spawned in this database respond fairly well and function correctly.  My server architecture is SharePoint installed to Azure IaaS with a SQL database also installed to an IaaS virtual machine.  The Azure SQL PaaS only hosts a content database and is hosted in the same Azure data center as my SharePoint farm.


First you must create a new database using the collation Latin1_General_CI_AS_KS_WS  — Be aware, this is different from the default of SQL1_Latin.  You cannot change the collation after spawning and SharePoint will not allow you to use anything but Latin1_General_CI_AS_KS_WS so make sure this is correct!  For my test I only used 5 DTUs.  While the initial creation of the content database was slow the upload, download and creating of sites was fast enough for a proof of concept.

database settings

Next step is optional but you should create a new SQL user for your SharePoint install.  If this is just a proof of concept you can use your master account and skip these steps.
Run the following against your master database:
EXEC sp_addrolemember ‘loginmanager’, ‘sp';

Run the following against your newly created database:
EXEC sp_addrolemember ‘db_owner’,’sp';

Now switch over to your SharePoint 2016 farm and run the following command.  Replace the highlighted text with your own values.  When prompted for credentials use your database user or the user you created in sql earlier.
New-SPContentDatabase -Name AzureDatabaseName -WebApplication (Get-SPWebApplication http://webapp) -DatabaseServer FullAzureDatabaseURL -DatabaseCredentials (Get-Credential)

This step took 26 minutes for me using a 5 DTU basic server.  After this is created spawn some sites in this content database by bringing your original content database offline in SharePoint content database settings and creating a new site collection.  You are now using Azure PaaS SQL as your content database!

Please post your findings below!

Error installing .net framework on Windows Server 2012 in Azure

I recently ran into this error while trying to activate the .net framework feature on Windows Server 2012 in azure:

The source files could not be found.
Use the “Source” option to specify the location of the files that are required to restore the feature. For more information on specifying a source location, see

The fix is actually not to find the source but to actually remove the following KB articles:

Uninstall KB2966827 / 2966826 / 2966828

SteamCMD Error When Updating 0x1

If you receive and error like this when using SteamCMD to update your servers try deleting the Steam directory in the root of your game server, the old hldsupdatetool is not compatible with SteamCMD!


app_update 740 validate
Steam> Initial App state (0x2) update required
App state (0x10102) reconfiguring, progress: -nan (0 / 0)
Error! App ‘740’ state is 0x1 after update job.

VMWare Workstation Performance Settings

If you are hosting large performance intensive virtual machines in Windows 7 / Vista you will start to notice even if you allocate a large amount of memory to the virtual machine windows will not use it and will even start having paging issues trying to clean up memory used by the machine.  Below are settings for VMWare Workstation’s config.ini.  These settings are global so just make them once and they will effect every VM that you have.  What these settings are doing is telling windows to allocate the memory at boot time and not to dispose when the vm is not using it.  I noticed my VMs speed increase dramatically after these settings were changed.

prefvmx.useRecommendedLockedMemSize = “true”

prefvmx.minVmMemPct = “100”

mainmem.useNamedFile = “false”

bios.bootdelay = “5000”


The config.ini file is commonly located in: C:Documents and SettingsAll UsersApplication DataVMWareVMware Workstation

New iPad Application Release: Kid Letters

A new kids learning application for iPad has been released, Kid Letters.  This application is geared to 6m – 2 years to teach children hand eye coordination, letter recognition and sounds for each letter.  The application does not allow children to leave the application so there is less parent involvement needed.  The application will be updated to the users wishes.  Want numbers?  Comment in the app store and our developers will create that for you.  Find the application here, you wont be disapointed:

Having Problems?  Email us at


Disney Vacation Club Calculator

Well, it’s that time of year again, vacation time!  Many of us are going to Disney and may even go back every year.  For those people there is a special timeshare called the Disney Vacation Club.  While it is a very expensive club to join it could save thousands if used wisely.

With all large purchases there are a lot of questions to consider… is this right for my family?  Do I need to go to Disney for the next  40 years?  Will this even save me money?  Since the first two (and many more) are person questions, I can try to help you with the money choice.  Below is a Microsoft Excel spreadsheet that will calculate the cost of your normal Disney vacations at two different hotels, the DVC direct from Disney as well as resale.  Each also includes costs for your own food budget or using the Disney Dining plan.  To use this spreadsheet all your need to do is edit the far right section with information about your family, your trip and how many points you think you need.  You will then see the costs for the next few years to see what makes sense money wise.

Here is a link to the spreadsheet filled out with a week stay at DVC Saratoga Springs Resort, hotel 1 set to a moderate hotel and hotel 2 is a value resort:


Feel free to play with it and leave feedback in comments!


vmx86.sys bluescreen when starting VMWare Virtual Machines

Running Windows 7 64 bit a common VMWare (and many other programs) problem is that a driver will cause a Blue Screen of Death, or BSOD. An easy way to allow these drivers to run and have windows ignore the issues is by disabling “Driver Verifier” in windows 7. These is a quick and easy way to try to solve your problems with your .sys drivers.

  1. Hit windows key + r to bring up the run window and type “verifier” without quotes.  Click OK.
  2. Choose “Delete existing settings and click “Finish.”
  3. Restart your computer

Hopefully this will help with your BSOD problems.  If you are having such bad problems you can not even get into windows before your BSOD, try this same method using Safe Mode.  Let me know in the comments if this worked for any of you!

Windows Media Center Movie Library with xbox 360

If you are like me, you have been banging your head against the wall trying to get your xbox 360 working correctly with your Windows Media Center’s Movie Library. I went on and on figuring it was a codec problem. The issue you are seeing should be that when logged directly into the media center it sees your movies, but the xbox 360 shows an error: “There are no items in the library yet …”

The solution is stupid… you just need to add the folder FROM the xbox 360. You would think it would pull the settings directly from the media center PC just like it does for music and pictures library, but it does not. Anyways, just go to settings, Media Libraries and add a movie library to the share (or folder) where you have your videos.

Now, if only these videos had cover art etc. Well, you could add each video and find cover art for the video and spend the rest of your life doing that for each video… or you could use an easy windows service that will easily find the name of your video and download cover art and even extra meta data. It doesn’t work for every movie but in my collection it covered about 80%.

The tool you need to download is called Yammm (Yet Another Media Meta Manager). Before you install though you should know that each video needs to be in its own folder. You can easily complete this by running this dos command inside your videos folder:

FOR %i IN (*.*) DO (IF NOT EXIST “%~ni” MD “%~ni”) & (MOVE “%i” “%~ni”)

When this command completes point Yammm to the root of your movie folder, click save and walk away. It will create artwork for any new movies you put in this folder as well!

Permalink for WordPress – IIS 6 mod_rewrite FIXED – Free

If you install WordPress on IIS you will notice your friendly URLs do not work.  This is because WordPress wants to use an apache add-on called “mod_rewrite.”  The quick rundown of that this does is it will take your friendly browser URL and actually change them to index.php on the back end.  One problem with this method is that IIS does not load apache mods.  Here is an easy and free way around this:

  1. On your IIS Server download and install ISAPI_Rewrite Lite.  This filter does the job of mod_rewrite for IIS.  When downloading make sure to use the free Lite version.  This Lite version does not limit the product very much and will be perfectly fine (and free) for our wordpress blog.  Just install Rewrite Lite to the default locations for this tutorial.
  2. Next add the ISAPI filter to your IIS Site.
    You will find this setting by right clicking yourIIS site -> properties -> ISAPI filters tab -> Add …  Name the filter whatever you wish and your path to your executable should be:
    C:Program FilesHeliconISAPI_Rewrite3ISAPI_Rewrite.dll
    Click OK on both windows to save your settings.
  3. Next navigate to C:Program FilesHeliconISAPI_Rewrite3
    Here we will edit httpd.conf  (Note:  This is the difference between the pay version and the Lite version.  In the pay version you will need to edit the .htaccess file on your web folders root)
  4. Open the httpd.conf file in wordpad and paste in these lines:
    RewriteBase /
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php?p=$1 [NC,L]
  5. Save and exit this file.
  6. To complete your IIS changes, Go to start, run and run the command:  iisreset /restart
  7. Now lets change your WordPress settings.  Navigate to http://yourblog/wp-admin
  8. Navigate to the left side menu bar -> settings -> Permalinks
  9. Now you get to choose how you want your posts to look.  I choose a custom setting and just: /%postname%  This is how you see this blog working today.
  10. Click “Save Changes” and you should see your new friendly URLs!

Steam Version of BioShock – Cheats working!

For all of you trying to get cheats working in your BioShock game you bought on steam, you may notice they do not activate and trainers will not work.  Follow this tutorial to get cheats working:

  1. Navigate to your steam folder, normally:  C:Program FilesSteam
  2. Enter the folder: steamappscommonbioshockbuidsrelease
  3. Edit the file DefUser_int.ini
  4. Do a find and replace on the key you would like to find for what cheat
    Such as replace… “F10=” with”F10=god”

Here are some more codes you can try out!

Code:                  Result:

fly                          Fly Mode

ghost                    No Clipping Mode

teleport                Teleport to Crosshair

walk                      Remove Fly and Ghost modes

killpawnsKill        All Enemies on Level

slomo                   Slomo Mode

suicide                 Kill Self

givehealth           Gives Health

givebioammo     Gives EVE

igbigbucks          Give $500