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 …

Powershell – How to use Transcripts to keep history of commands and output

The primary tool for logging Powershell activity has been the Start-Transcript cmdlet. Simply enter this cmdlet followed by a path and filename for the log file that you want to create. PowerShell will populate the log file with every subsequent command that is entered. 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 …