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

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