Disaster Recovery PlanCompany: Priority:HIGHAffected Services: Issue Number: Key Dates: DRP Table of ContentsContentsCONTENTS…………………………………………………………………………………………………………………………………………………………………………..21. HIGH LEVEL OUTLINE OF DRP ………………………………………………………………………………………………………………………………………32. KEY PERSONNEL AND CONTACT INFORMATION ………………………………………………………………………………………………………….33. DATABASE BACKUPS ……………………………………………………………………………………………………………………………………………………43.1. PRODUCTION DB……………………………………………………………………………………………………………………………………….43.1.1. On-Prem […]
SQL Best Practice
Create 4 Drives Data for SQL DB F:\Logs E:\TempDB G:\Backups H:\Install DB to F:\MSSQLSERVER\Install Client Tools by Defaults and Anything else you might need Setup GMSA service accounts for […]
Teams calling – Missing Phone Number
Had an issue this morning where I needed to modify the call routing for a specific phone number – it was meant to ring multiple people but […]
Undeletable Exchange Online Mailbox
Symptom: After running disable-remotemailbox on shared mailboxes the mailboxes were still showing as active in Exchange Online.Cause: Disable-remotemailbox only works if a account is a user mailbox AND the user […]
Bloomberg Console – blpwebview.exe , libcef.dll and 0x80000003 – We are sorry we could not display the requested resource (RuntimeBroker , code : BROKER_TERMINATED).
Users trying to open the Webview in Bloomberg We are sorry we could not display the requested resource (RuntimeBroker , code : BROKER_TERMINATED).The program required to display content […]
ADConnect Account setup
Create Service Account for AADconnect Onprem ( then sync to Azure AD ) (obv put in Password state ) Add this to Hybrid Identity Admin ( NOT GLOBAL […]
How to compare two document libraries from different Office 365 Tenancies \ SharePoint Sites
Recently I had bit titan migration and the Sharepoint Document Library size of the Source Tenant was 2TB and the destination was only 200GB , quite a […]
Azure SQL Profiler – In order to run a trace against SQL Server you must be a member of sysadmin
You are not allowed to run a trace against Azure SQL Database. To do query profiling on Azure SQL, you can use Dynamic Management Views or take a look at the Azure SQL […]
Azure SQL export
Recently I was trying to Export a Azure database to a bacpac file , however SQL Management Studio gave the following error——————————One or more unsupported elements were […]
Azure Auto Tuning – Azure SQL Indexes
You have to evaluate the indexes based onCurrent indexes –Can it be combine with an existing index or is it really a new index to add i.e. […]