Overview :  Azure SQL is incredible.  There are a lot of options when choosing how to host database and performance good.   " handles ...

Overview :  I am working on a Power Platform solution and I need to use CDS.  Basically, I need to be able to see and edit values within CDS...

Problem :  I have a dedicated SQL 2017 VM on Azure that is joined to my Azure AD tenant e.g. int.contoso.com (Azure AD Domain Service).  I ...

Overview : TDE is Transparent Data Encryption, where you can encrypt your "data a rest", this encrypts the SQL mdf and ldf files....

Overview :  This post looks at reducing the footprint of the ldf file.  SharePoint related databases with using the Full recovery mode keep...

  Checklist for SQL Server 2012 for SharePoint 2013 Use multiple: SQL Aliases (separate 1 for search). Dedicate SQL Server for SharePo...

Create SQL Aliases example Powershell For DR and Moving/splitting up SQL Server load use aliases, costs you nothing and later on you can ...

Overview :  I like automation.  I use AutoSPInstaller for SharePoint even on developer VM's and taking this further I want to automated...

Problem : When setting up a development machine, I install SQL before SharePoint.  When I try access SQL Server 2008 R2 using "SQL Ser...

Overview :  Today I met a small company looking to put in SharePoint 2010, I was surprised at the requirement for 35 users but after some re...

I attended a suguk.org event in London about a week ago.  John Timney did the 1st presentation session and asked a couple of questions on ...

Alan White's article helped me figure out where my default databases would be created. To open SQL Powershell type "sqlps" ...

SharePoint Server 2010 needs 64-bit SQL Server 2008 SP 1 CU2 (Cumulative Update) or 64-bit SQL Server 2005 SP3 CU3. Determine you storage...