Background As a Database Administrator get so see a bit of SQL Statements. Avenues The SQL gets to the DBA through various avenues, inclusive :- Developers Submitted to review and execute against Production Database Monitoring Tools In quite a few cases, the first thing one has to do is space things out a bit. SQL … Continue reading SQL Beautifier
Database ( Technical )
“Entity Relationship” meets poetry
Background Researching an issue and wanted to see the best choice for a name. Googled on it and found good reasoning. Question The Question is :- Image Text Table: Color Columns: Id, ColorName, ColorCode Table: Shape Columns: Id, ShapeName, VertexList What should I call the table that maps color to shape? Table: ??? Columns: ColorId, … Continue reading “Entity Relationship” meets poetry
DBeaver
Background Here I am having used SQL Server Management Studio ( SSMS ) for so long, I am satisfied. It's GUI is versely superior to SQL 2000 Query Analyzer and it exposes just about every SQL Functionality that I use on daily basis. Stumped Spent hours trying to capture a query's grid display unto … Continue reading DBeaver