Learning in the Open

Books
- Blogging
  - WordPress
- Authors
Climate
- Climate Change
Culture
Life
Medical
- Pharmacy
Music
- Singers
Magazine
Romance
Science
- Evolution
Short Story
Social Networks
Spiritual
Technical
Modeling

HomeTechnicalDatabase ( Technical )

Database ( Technical )

SQL Beautifier

July 9, 2019March 28, 2020 Daniel Adeniji Microsoft, SQL Beautifier ( Database - Technical ), SQL Server, Technical

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

“Entity Relationship” meets poetry

May 28, 2019May 28, 2019 Daniel Adeniji Database Modeling, Dimensional Modeling, Entity ( Database Modeling ), Modeling, Relationship Tables ( Database Modeling - Entity ), Stack Exchange Network, Stack Overflow

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

April 26, 2017April 26, 2017 Daniel Adeniji Client Tools, Database ( Technical ), DBeaver, Technical

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