For most things I use Navicat, for more complex stuff I use DBeaver. But what I've really wanted is what Microsoft had over 20 years ago:
- a visual database diagram
- a visual query builder
- their Index Tuning Wizard
They had these things in the nineties and I've not seen something that comes close since (they've even made it worse for their own stuff). All the alternatives are janky java approximations that have terrible auto formatting options or keep to the very basics SQL.
- a visual database diagram
- a visual query builder
- their Index Tuning Wizard
They had these things in the nineties and I've not seen something that comes close since (they've even made it worse for their own stuff). All the alternatives are janky java approximations that have terrible auto formatting options or keep to the very basics SQL.