Category Archives: SQL server

Monitoring Read/Write Latency


https://sqlperformance.com/2015/03/io-subsystem/monitoring-read-write-latency Advertisements

Posted in SQL server | Leave a comment

Move SharePoint Databases Using SQL Client Alias


Before attempting to move the databases associated with your SharePoint instance, make sure you backup your farm before continuing. For example, the following PowerShell script performs a full backup of the farm: Backup-SPFarm -Directory c:\backuppath -BackupMethod Full Depending on the … Continue reading

Posted in SQL server | Leave a comment

SQL Scripts: How To Check Logins And Permissions


When was the last time a login was used? –list of logins and last time each logged in SELECT [Login] = login_name,[Last Login Time] = MAX(login_time) FROM sys.dm_exec_sessions GROUP BY [login_name] Which logins have logged in within the last X … Continue reading

Posted in SQL server | Leave a comment

YOUR BACKUP IS FROM A DIFFERENT VERSION OF MICROSOFT SHAREPOINT FOUNDATION AND CANNOT BE RESTORED


Some content on this page was disabled on November 20, 2017 as a result of a DMCA takedown notice from Mohamed El-Qassas – blog.devoworx.net. You can learn more about the DMCA here: https://en.support.wordpress.com/copyright-and-the-dmca/

Posted in SHAREPOINT ADMIN, SQL server | Leave a comment

RESTORE / MIGRATE A SHAREPOINT WEB APPLICATION TO ANOTHER FARM FROM SQL DATABASE BACKUP


Some content on this page was disabled on November 20, 2017 as a result of a DMCA takedown notice from Mohamed El-Qassas – blog.devoworx.net. You can learn more about the DMCA here: https://en.support.wordpress.com/copyright-and-the-dmca/

Posted in SQL server | Leave a comment

CANNOT CONNECT TO THE CONFIGURATION DATABASE


Some content on this page was disabled on November 20, 2017 as a result of a DMCA takedown notice from Mohamed El-Qassas – blog.devoworx.net. You can learn more about the DMCA here: https://en.support.wordpress.com/copyright-and-the-dmca/

Posted in SQL server | Leave a comment

Best Practices for SQL Server Temp db


This part of a three-part article consolidating a number of best practices for configuring SQL Server tempdb focuses on tempdb placement. You won’t just find prescriptive rules here, but also the background to the recommendations and guidance on how to … Continue reading

Posted in SQL server | Leave a comment