• Can’t Connect to SQL when provisioning a Project App in SharePoint

    Posted 10 months ago
    by SQL Server Support Content}
    The customers issue was that they were trying to provision a Project site within the Project SharePoint Application. This was done via a PowerShell script that they ran on one of the SharePoint App Servers. They had two SharePoint App Servers – AppServerA...

  • How to move databases configured for SQL Server AlwaysOn

    Posted 10 months ago
    by SQL Server Support Content}
    How to move databases configured for SQL Server AlwaysOn   This article describes how to change the location of the data files and the log files for any Microsoft SQL Server 2012 database which are configured with SQL Server AlwaysOn with minimal...

  • As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity

    Posted 10 months ago
    by SQL Server Support Content}
    It felt a bit like ‘As The World Turns’ as I unraveled how the following worked so the title is a bit of a tribute to my grandmother.  She could not miss here ‘stories’ in the afternoon. Proximity Before I dive into the details I would like to talk...

  • Generating a trusted TDE Certificate in the proper format from a Certificate Authority

    Posted 10 months ago
    by SQL Server Support Content}
    I recently worked with a customer who was attempting to deploy Transparent Database Encryption using a trusted certificate which was generated by a certificate authority (CA). They were unable to import the certificate using the CREATE CERTIFICATE command...