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 …

Windows – Clear Group Policy Cache

That’s quite uncommon, but if we need to clear the local cache of Group Policies Objects (GPO) on a workstation/laptop joined to a domain, there are three main methods we can use to accomplish this activity. Read More …

Excel – Allow Certain Users to Edit Cells Range

Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …

Set up Port Forwarding (Windows)

Port Forwarding is a technique that allows remote computers, usually computers or systems on the Internet, to connect to a specific system or service within a private local-area network (LAN), so an internal network. Read More …