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 […]
Category: Research
Research Undertaken
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. […]
How to migrate mailbox over 50GB or 100GB size to 365 with Bit-Titan
Normal Office 365 accounts would only have a 50gb mailbox, any more then this and I would recommend enabling Archiving which can go to 1TBAdd Trial verison […]
How to add more security to Microsoft Authenticator App – Additional Context and Number Matching
https://docs.microsoft.com/en-us/azure/active-directory/authentication/how-to-mfa-additional-context Can get Location and the App Name asking for AuthUse number matching in multifactor authentication (MFA) notifications (Preview) – Azure Active Directory – Microsoft Entra | Microsoft […]
Veeam Backup – A data integrity checksum error occurred. Data in the file stream is corrupt
22/08/2022 12:39:26 AM :: Failed to pre-process the job Error: Agent: Failed to process method {Transform.Patch}: A data integrity checksum error occurred. Data in the file stream […]
Veeam Backup – The file is locked or in use — File open failed: File not open –tr:Failed to start file downloading. VMFS path
22/08/2022 2:13:58 AM :: Processing XXXXX Error: Failed to prepare VM for processing: DiskLib error: [13].The file is locked or in use — File open failed: File […]
iPerf – Network Speed
There’s a tool called iPerf which is essentially a CLI speed test server and client. It runs better on Linux because there’s less shenanigans that go on […]
Automatic tuning – Azure SQL Drop Indexes
Careful about enabling his , it can still report the duplicates and then the indexes can be evaluated to see if they are indeed duplicates. If they […]