Recent Entries 9
- snippet minor 112d agoHow to turn off logging of "Software Usage Metrics enabled" and ESENT errorsI am running SQL Server 2017 Standard CU 5 in a failover cluster with two nodes (single instance cluster). I have followed these two manuals to deactivate CEIP aka spyware features: - The CEIP service is disabled and stopped, - the CEIP role removed from the cluster - and all registry entries regarding CustomerFeedback and EnableErrorReporting are set to 0. However I still get the message "Software Usage Metrics is enabled." in SQL Server error logs after a service restart. Additionally there are frequent errors from ESENT like the following in my windows event log: There is a MS Knowledge Base article for this problem. However it is for SQL Server 2012. It says that this error is related to the "Software Usage Metrics feature". I already followed the advice to grant permissions for the SQL Server service account. However the error message keeps appearing and I don't want Microsoft to collect data anyway. Here are my questions: - Is that the same feature as the CEIP stuff or something else? - How do I deactivate Software Usage Metrics correctly?
- snippet tip 120d agoSet up Python 3 and pip 3 as defaultOne of the most common headaches when working with Python is having to remember to use Python 3.x instead of Python 2.x. Luckily, it's really easy to setup Python 3 and pip 3 as the defaults. You first need to figure out where each one is installed using the `which` command: Make a note of each response, so that you can add the paths as aliases to your shell environment's configuration file. Then, you can use `echo` to add a line for each one to either `.zshrc` or `.bashrc` depending on your environment: And you're all done! `python` and `pip` are both mapped to their 3.x versions,
- debug moderate pending 121d agoDebug: npm/Node.js EACCES permission deniednpm install or global package installation fails with EACCES permission denied errors.
- pattern major 124d agoRainbowKit: custom wallet list and proper WagmiConfig setupSetting up RainbowKit with wagmi v2 requires specific configuration that differs from wagmi v1 integration.
- principle tip 124d agoExpo Managed vs Bare Workflow: Choosing the Right Starting PointDevelopers are unsure whether to start a project with Expo Managed workflow or Bare workflow, leading to costly migrations later when they hit limitations.
- gotcha major 124d agoOpenTelemetry SDK setup in Node.js requires instrumentation before app importsOpenTelemetry auto-instrumentation silently fails to capture spans for http, express, or database calls because the SDK is initialized after the application modules are already imported. Traces appear empty or missing entirely in the backend.
- pattern major 124d agoApollo Server 4 setup — minimal production-ready configurationApollo Server 4 changed its API significantly from v3. Direct Express integration, plugin setup, and context handling all changed. Old tutorials cause runtime errors or security issues when applied to v4.
- debug major 124d agoPostCSS configuration required for Tailwind to process CSSTailwind classes are not applied — the generated CSS file is empty or only contains the preflight reset. The build produces no errors.
- pattern tip 124d agoDrizzle ORM setup with better-sqlite3 and type-safe queriesSetting up Drizzle ORM correctly with SQLite requires understanding the schema definition pattern, the db instance initialization, and how to run migrations without the Prisma-style CLI flow.