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 […]
(No Ratings Yet)
Loading...
(1 votes, average: 5.00 out of 5)Loading...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 […]
(No Ratings Yet)Loading...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. […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...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 […]
(No Ratings Yet)Loading...Add User to Azure SQL DB and Assign permissions
How to assign User Connect Permissions to Azure DB[pastacode lang=”sql” manual=”CREATE%20USER%20%5Bemail%40domain.com%5D%20FROM%20EXTERNAL%20PROVIDER%3B” message=”” highlight=”” provider=”manual”/]How to find current Roles assigned to Azure DB[pastacode lang=”sql” manual=”SELECT%20DISTINCT%20pr.principal_id%2C%20pr.name%2C%20pr.type_desc%2C%20%0A%20%20%20%20pr.authentication_type_desc%2C%20pe.state_desc%2C%20pe.permission_name%0AFROM%20sys.database_principals%20AS%20pr%0AJOIN%20sys.database_permissions%20AS%20pe%0A%20%20%20%20ON%20pe.grantee_principal_id%20%3D%20pr.principal_id%3B” message=”” highlight=”” provider=”manual”/]How […]