Lopes Cloud
Linkedin X (Twitter)

[MICROSOFT SQL] – CHANGE DB OWNER

To change the owner of a DataBase to the following:

ALTER DATABASE DATABASE-NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER AUTHORIZATION ON DATABASE::[DATABASE-NAME] TO [sa];
GO

ALTER DATABASE DATABASE-NAME SET MULTI_USER
GO

Compartilhe:

Bruno Lopes

Bruno Lopes

Hey there! I'm Bruno Lopes a consultant based in São Paulo, Brazil. I have been working in the IT industry for over 18+ years and have worked in a variety of roles, from helpdesk to systems administration and now as a cloud consultant. I worked in all aspects of Microsoft technology from end-user computing to on-premises data centers but now I spend all my time working with Microsoft Azure and Microsoft 365, deploying and automating solutions for customers across a wide range of industries. When I'm not focusing on IT, I enjoy music and reading, spending as much time as possible with my wife and daughter.

Continue lendo...

[AWS] – AZURE AD SSO – ENTERPRISE APPLICATION

This guide outlines setting up Azure AD SSO with AWS, streamlining access management for enterprise applications.
Leia mais

[MICROSOFT 365] – FORCE AD USER SYNC WITH ENTRA ID

Issue: Facing synchronization challenges with Active Directory (AD) users in Microsoft Entra ID (formerly known as Azure AD)? You’re not alone. It’s a common scenario where AD users fail to

Leia mais

[HYPER-V] – KILL VM PROCESS

To kill a VM process follow the steps below: Open POWERSHELL as administrator:

Leia mais

[ACTIVE DIRECTORY] – SYSVOL and NETLOGON not syncing

SYSVOL and NETLOGON folders weren’t syncing between domain controllers or the folders did not exist at the secondary DC. If you have this issue, users that authenticate at the DC

Leia mais