SQL Server – Temporary Tables

SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …

Active Directory – Check Which Domain Controller your Machine is Getting Authenticated

If you have multiple domain controllers in your environment and you want to check with domain controller is authenticating your Read More …

Sharepoint – CAML queries and examples

CAML stands for Collaborative Application Markup Language. It is an XML based language that is used in SharePoint. CAML query Read More …

Error “The RPC server is unavailable” – Part 2

Remote Procedure Call (RPC) is an inter-process communication technique to allow client and server software to communicate on a network. The RPC protocol is based on a client/server model. The client makes a procedure call that appears to be local but is actually run on a remote computer. Read More …

Fix Master Browser (MRXSMB) Event ID 8003

The Event ID 8003 (Master Browser) error messages, on some Windows Server systems (specially older ones) is probably one of the most searched on this environments due to the fact that this event is linked to WINS (the predecessor of DNS on Windows systems) and the Computer Browser system service (still available even on newer Windows 10 clients and Windows Server). Read More …

Active Directory Delegated Permissions (View/Remove)

Active Directory (AD) delegation is critical part of many organizations’ IT infrastructure. By delegating administration, you can grant users or groups only the permissions they need without adding users to privileged groups (e.g., Domain Admins, Account Operators). Read More …

Active Directory – Recycle Bin Feature

If an object has been deleted in your Active Directory, and you want it recovered, there are a number of things you can do. Simply put, ADRB allows you to recover objects immediately, without the need to use your System State backups, latent sites, or 3rd party add-ons. Read More …

Windows Server 2016 – Configure DNS Zone Transfer

DNS (Domain Name System) is one of the many systems that keeps the Internet humming and is responsible for resolving human-readable hostnames into machine-readable IP addresses. DNS servers host what are known as zones. Read More …

Active Directory – Check if a DC is a Global Catalog

There are several ways to find out if a Domain Controller has the Global Catalog role enabled. In this article, Read More …

Microsoft – Changing SID of cloned VMs

On the machine level, every computer is identified by a unique value; named Security ID or SID. SID is calculated in the process of the installation of every Windows machine. Whether the computer is part of the workgroup (or it’s just a stand-alone computer), the value of SID is not crucial. Read More …