Execution plans are your window into SQL Server’s query optimizer. Learning to read them is essential for performance tuning. Here’s how to get started. Getting an Execution Plan Key Operators to Know Table Scan: Reading every row. Usually bad. Index Seek: Using an index efficiently. Good. Index Scan: Reading whole index. Check if seek is […]
Read more →Month: May 2019
React State Management: Local State, Context, and When You Need More
State management in React can be simple or complex. Here’s how to choose the right approach for your application. Level 1: Component State Start here. useState is perfect for local UI state: Level 2: Lifting State When siblings need to share state, lift it to the common parent: Level 3: Context For state used across […]
Read more →Node.js with TypeScript: Project Setup and Best Practices
TypeScript makes Node.js development much more pleasant. Types catch bugs early and improve editor support. Here’s how to set up a TypeScript Node project properly. Project Setup tsconfig.json Package Scripts Basic Express App Development Tools Best Practices Enable strict mode from day one Install @types packages for libraries Use interfaces for request/response shapes Keep src […]
Read more →React State Management: Context API vs Redux
With React 16.8’s Context API improvements, do you still need Redux? The answer is nuanced. Here’s my take on when to use each. Context API Context is built into React. Great for passing data without prop drilling: Redux Redux is a predictable state container. Actions describe what happened, reducers update state: When to Use Context […]
Read more →Outbox Pattern: Reliable Messaging in Distributed Systems
The Outbox Pattern solves a common problem: how do you update a database AND publish a message reliably? Without it, you risk losing messages or creating duplicates. The Problem If the publish fails, your database has the order but no event was sent. Downstream systems never know about it. The Solution Write events to an […]
Read more →SPFx Application Customizer: Adding Headers and Footers
Application Customizers let you add global headers and footers to SharePoint pages. Perfect for branding, notices, or navigation. Create the Extension Using Placeholders Deployment After deployment, activate the extension tenant-wide or per-site using PowerShell or the CLI for Microsoft 365.
Read more →