TThyne Ventures2h ago · 2 min readWhich Snowflake users still log in with a password and no MFA? One read-only query to checkPassword-only Snowflake logins without MFA are one of the easiest account takeovers to prevent — and one of the most common gaps after a few years of hiring. The admin-role check catches the highest-pthyneventures.hashnode.dev
BBen Barazandeh1d ago · 6 min readBuilding a Trucking Company List From FMCSA Open Data (SoQL Pitfalls Included)This is a copy of my Dev.to post. Disclosure: I'm Ben, and I built the Apify Actor mentioned later in this post. I charge per result for it. The tutorial part uses only free public data. Freight insurdedicatedcrest.hashnode.dev
MMin SiThu22h ago · 6 min readSQL and Business Metrics: Asking a Database the Questions That MatterTo put it simply, a business metric is a number a company watches on purpose — revenue this month, customers lost this quarter, sales per visitor — and SQL is the language you use to ask a database foitsmeminsithu.hashnode.dev
TThyne Ventures1d ago · 4 min read12 Snowflake interview questions that separate seniors from juniors (with SQL)12 Snowflake interview questions that separate seniors from juniors (with SQL) Snowflake interviews rarely fail people on "what is a virtual warehouse." They fail people on judgment: when to size up vthyneventures.hashnode.dev
TThyne Ventures1d ago · 2 min readWho has ACCOUNTADMIN in your Snowflake account? One read-only query to checkACCOUNTADMIN can change billing, drop any database and grant itself anything else. Snowflake recommends keeping it to a small number of people, but grants pile up over time. This read-only query liststhyneventures.hashnode.dev
AAbdus Salam1d ago · 5 min readSQL Joins Finally Clicked — the 4 Diagrams That Did ItI failed SQL joins three times. I could repeat the definitions word for word, and still stare at a query like it was written in another language. Then a friend drew four circles on a napkin, and it claheadkit.hashnode.dev
EEjaz Arain1d ago · 5 min readParitas, an Oracle-compatible PostgreSQL that tells you where compatibility endsFirst published on the Tech Style blog. When a company moves off Oracle, most of the effort goes into converting the code. The part that hurts later is quieter. PostgreSQL is not Oracle, and in placesrutba.hashnode.dev
TThyne Ventures2d ago · 2 min readWhich Snowflake tables has nobody read in 90 days? One read-only query to checkTables that nobody reads still cost storage every month, and they clutter every search for the right dataset. On Enterprise Edition or higher, Snowflake records which objects each query touched in ACCthyneventures.hashnode.dev
RRavi Sah2d ago · 6 min readHow to Stop Deadlocks in SQL Server: 5 Production Patterns and Their FixesHow to Stop Deadlocks in SQL Server: 5 Production Patterns and Their Fixes We’ve all been there: a production application suddenly stumbles, errors spike, and your telemetry logs reveal the dreaded Erprodsolutions.hashnode.dev
PPrachit Parikh2d ago · 27 min readSQL data profiling: 8 queries I run on a brand-new table before anyone writes a testSomeone points you at a table. It showed up in staging last week, it has a sensible name, and the request is short: "Can we build the weekly report off this?" Nobody has written requirements against iprachitparikh.hashnode.dev
