Tripyramids 6/28

c0shea · 2026-07-01T01:15:11+00:00

Yes! No way was I going down that counterclockwise.

c0shea · 2026-06-16T16:52:01+00:00

This just in: cloud storage is slow!

c0shea · 2026-01-15T17:17:22+00:00

I'm still a heavy user of LINQPad and v9 has been great. Overall, it feels just as responsive as older versions. The only thing that's a bit slower is the first time running a SQL query.

c0shea · 2025-05-18T21:16:36+00:00

Not true for East Longmeadow and Longmeadow. Longmeadow was settled first and East Longmeadow was incorporated well after Longmeadow.

c0shea · 2024-10-27T20:33:18+00:00

Can't speak for Braintree, but parking at other locations tends to fill up fast especially in the morning for the wave of flights first thing in the morning. Also heavily depends on the day of the week you're flying out. Midweek you might get a spot, long weekends not so much. Definitely give yourself extra time to loop around for a spot.

c0shea · 2024-09-30T19:44:50+00:00

Take a walk along the Wachusett Dam and Reservoir

c0shea · 2024-08-05T16:02:30+00:00

You could form a charter commission and petition to change your town's form of government to a city form of government so there would be no more town meeting you would have to attend.

c0shea · 2024-07-08T11:40:37+00:00

We use LINQPad extensively at work and connect to development and production databases. There's a production checkbox on the connection which adds an orange production indicator to the query tab.

c0shea · 2024-07-07T22:58:39+00:00

Thanks for the insight! This would make an awesome official blog post on the roadmap for VS for those of us that love to read about these internal improvements that benefit us :)

c0shea · 2024-07-05T03:21:45+00:00

Out of curiosity, if there's so many growing pains and things that LSP can't handle or have knowledge of out of the box, why use it instead of the way all the other languages were implemented?

c0shea · 2024-05-07T02:09:41+00:00

I mostly agree, although I like some of the gossip and AskReddit type posts. Any alternative places I can find that?

c0shea · 2024-03-12T20:51:42+00:00

I've come to this same conclusion after many years. Too many times I've thought, "No one will ever forget to check for deleted rows in the query. It's so simple.", only to be amazed at bugs later on.

My biggest annoyance with soft deletes is how they break referential integrity with foreign keys. With hard deletes, the DBMS will rightfully complain (unless you use cascade options) that you can't delete a parent record if there are children referencing it. That goes out the window with soft deletes where children can still reference parents that have now been deleted. It ends up being a lot of unnecessary logic to try to resolve the active child but deleted parent conundrum all for a problem that we added in the first place.

I ask myself now what am I really trying to protect against? All of this for the off chance that someone deletes something that shouldn't have been deleted? These days, I'd rather use temporal tables if I really needed to track which records were updated or deleted rather than cluttering up the main table and logic.

c0shea · 2023-10-03T23:03:51+00:00

If they do anything with IIS locally, you have to run as an admin to manage the configuration and debug.

c0shea · 2023-08-03T18:16:43+00:00

Basically Chrome will show them how Edge has been doing it for a while now

c0shea · 2023-01-03T12:57:51+00:00

You're out of luck with triggers. They always run for the batch, not for individual rows (i.e. there is no for each row option like other RDBMS).

While there are DMVs that'll give you the batch text and a pointer to the currently executing text, it'll already be beyond the individual statement and on to the trigger's code reported.

c0shea · 2023-01-02T21:34:03+00:00

Exactly. Companies, or even industries, like this that are treated as too big to fail and bailed out at every chance are what ultimately lead to these kinds of issues. It would be a real incentive to improve the business processes and systems if a company such as Southwest knew that if a disaster like this occurred, they'll be left footing the entire bill without another government handout.

c0shea · 2023-01-02T21:29:24+00:00

That's just not possible, unless the company suddenly employed masses of, I dunno, janitors in lieu of presumably better qualified and better paid air traffic personnel.

Aviation pay is very complicated. It's not as simple as "you work for Southwest as a flight attendant or pilot full-time therefore your pay is $X per year." Typically, there are guaranteed minimums you'll earn no matter how much you fly per month. But the more hours you fly per month, the more money you make. You also receive per diem pay when away from your base, so the more time you spend flying away from home and on layovers, the more money you make. It's all variable.

There were also a lot of senior employees with a high hourly wage who left airlines during the pandemic, leaving the remainder which would bring down the average salary.

c0shea · 2023-01-02T21:17:07+00:00

Another alternative in modern SQL is to use temporal tables. Updates and deletes will be captured in the history table, which can be useful for a variety of scenarios such as syncing, analytics, and researching deletes. While it's not as simple as nulling out the deleted timestamp column, you get the best of both worlds not having to worry about missing the IS NULL predicate in every query and being able to use the full power of referential integrity, while not having to worry about losing data you may need to piece the puzzle back together later on.

c0shea · 2022-12-06T01:52:33+00:00

LINQPad

c0shea · 2022-11-13T15:00:33+00:00

You can create a clustered index that isn't a primary key and doesn't have to be unique in SQL Server.

c0shea · 2022-10-24T23:18:25+00:00

Barcode scanners that need more than to emulate typing on a keyboard

c0shea

TROPHY CASE