Posey's Tips & Tricks


An old-fashioned telescope

The New Copilot Function Vastly Improves Microsoft Excel, Part 2

Microsoft’s new Copilot function in Excel lets users generate, analyze and explain data directly from cell formulas, marking a major step toward full AI integration within spreadsheets.

Blue Squares Graphic

The New Copilot Function Vastly Improves Microsoft Excel, Part 1

Excel’s newest Copilot integration finally delivers the data intelligence Microsoft promised years ago, transforming how users clean, organize and understand information within their spreadsheets.

Exploring a Free Tool To Improve Windows Privacy

A lightweight free utility gives Windows users an easy way to review and control system-level privacy settings without digging into the registry.

Preventing Microsoft 365 Phishing Attacks, Part 3: Damage Control

Microsoft 365 administrators can fine-tune Defender's anti-phishing policies to determine how detected spoofed or impersonated messages are handled, from quarantine and deletion to user safety tips that flag suspicious senders.

Preventing Microsoft 365 Phishing Attacks, Part 2: ID Check

Microsoft 365 administrators can use built-in Defender for Office 365 tools to enable impersonation and domain protection, reducing phishing risks by identifying spoofed senders and untrusted domains.

Preventing Microsoft 365 Phishing Attacks, Part 1

Microsoft 365 includes built-in tools to defend against phishing attempts that use domain and user impersonation, but administrators need to understand how these protections work to avoid unintended disruptions.

PowerShell-Based SQL Server Backups Revisited, Part 2

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity.

PowerShell Based SQL Server Backups Revisited, Part 1

Let's refine some of my earlier work to make things more efficient.

Getting Executive Leadership Onboard with Attack Simulation Training

Getting executive buy-in for Microsoft 365 attack simulation training is essential, as leadership accounts often carry the highest risk and the greatest impact if compromised.

Dynamically Construct a PowerShell GUI, Part 2

Learn how to dynamically generate PowerShell GUI elements from a SQL data source and update values with user input.

Dynamically Construct a PowerShell GUI, Part 1

Learn how to use loops and dynamic object naming in PowerShell to build GUI settings interfaces that can adapt as new parameters are added.

Make Secure Score Work For You, Part 2

Weigh Microsoft 365 Secure Score recommendations by balancing security impact, user experience, cost and acceptable risk to build a strategy that fits your organization.

Make Secure Score Work for You, Part 1: Shoot for Almost Perfect

Use Microsoft 365 Secure Score as a strategic guide rather than a numbers game, focusing on balance and meaningful risk reduction over chasing a perfect score.

When AI Goes Wrong: The Hidden Risks of Conditional Access Controls, Part 3

Overly aggressive AI-driven conditional access controls could not only lock employees out of needed resources but also trigger HR systems to misinterpret risk scores as poor performance, potentially jeopardizing careers.

When AI Goes Wrong: The Hidden Risks of Conditional Access Controls, Part 2

AI-driven conditional access systems can unintentionally lock trustworthy employees into a cycle of escalating mistrust, turning minor incidents into lasting reputational damage through bias and negative feedback loops.

Subscribe on YouTube