DEV Community

DbVisualizer profile picture

DbVisualizer

DbVisualizer is used for development, analytics, maintenance, and more, by database professionals all over the world. It connects to all popular databases and runs on Win, macOS & Linux.

Location Nacka, Sweden Joined Joined on  Personal website https://www.dbvis.com/ github website
Secure Sensitive Data: Discovery Practices and Tools That Work

Secure Sensitive Data: Discovery Practices and Tools That Work

Comments
1 min read
How to Discover and Protect Sensitive Data Using CLI and SQL Tools

How to Discover and Protect Sensitive Data Using CLI and SQL Tools

Comments
2 min read
How to Use SQL Server DATEADD for Real-Time Date Calculations

How to Use SQL Server DATEADD for Real-Time Date Calculations

Comments
2 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
Simplifying SQL DELETE for Developers: Syntax and Best Practices

Simplifying SQL DELETE for Developers: Syntax and Best Practices

Comments
1 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
SQL HAVING Explained: Filter Grouped Data With Ease

SQL HAVING Explained: Filter Grouped Data With Ease

Comments
2 min read
SQL INTERSECT Explained: Find Shared Rows Easily

SQL INTERSECT Explained: Find Shared Rows Easily

1
Comments
2 min read
Write Clean SQL: Tools That Format Your Queries for You

Write Clean SQL: Tools That Format Your Queries for You

Comments
1 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
A Developer's Guide to PostgreSQL Full Text Search

A Developer's Guide to PostgreSQL Full Text Search

Comments
1 min read
SQL UNION ALL: Combine Queries and Keep Duplicates

SQL UNION ALL: Combine Queries and Keep Duplicates

Comments
2 min read
How to Use SQL UNION and UNION ALL to Merge Query Results

How to Use SQL UNION and UNION ALL to Merge Query Results

1
Comments
2 min read
How to Use SQL CONVERT for Clean Type Conversions

How to Use SQL CONVERT for Clean Type Conversions

Comments
1 min read
SQL CASE Statement Explained with Real-World Examples

SQL CASE Statement Explained with Real-World Examples

Comments
1 min read
SQL REPLACE Function: Quick Guide with Real Examples

SQL REPLACE Function: Quick Guide with Real Examples

Comments
2 min read
SQL ORDER BY: Quick Sorting Examples and Tips

SQL ORDER BY: Quick Sorting Examples and Tips

Comments
2 min read
SQL EXCEPT: Find the Difference Between Two Tables

SQL EXCEPT: Find the Difference Between Two Tables

1
Comments
2 min read
How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

Comments
2 min read
Essential SQL Commands for Developers (With Code Samples)

Essential SQL Commands for Developers (With Code Samples)

Comments
2 min read
Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Comments
2 min read
A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

A Developer’s Guide to SQL NOT IN: Smarter Queries, Faster Results

1
Comments
2 min read
SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle

SQL Add to Date: Simple Guide for MySQL, PostgreSQL, SQL Server & Oracle

Comments
1 min read
Learn SQL’s CAST Function for Clean Type Conversion

Learn SQL’s CAST Function for Clean Type Conversion

Comments 1
1 min read
PostgreSQL Upsert: INSERT ON CONFLICT Explained

PostgreSQL Upsert: INSERT ON CONFLICT Explained

1
Comments
2 min read
Make Your SQL Cleaner with Common Table Expressions (CTEs)

Make Your SQL Cleaner with Common Table Expressions (CTEs)

Comments
2 min read
Enhancing SQL INSERT INTO Performance: Tips and Tools

Enhancing SQL INSERT INTO Performance: Tips and Tools

Comments
2 min read
Why Data Visualization Tools Matter for Developers, Managers, and Analysts

Why Data Visualization Tools Matter for Developers, Managers, and Analysts

1
Comments 1
1 min read
Postgres TEXT vs VARCHAR: When to Use Which

Postgres TEXT vs VARCHAR: When to Use Which

Comments
2 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

Comments
2 min read
Schemas in PostgreSQL: A Practical Guide for Developers

Schemas in PostgreSQL: A Practical Guide for Developers

Comments
2 min read
Database Schema Design: How to Structure Your App’s Data Effectively

Database Schema Design: How to Structure Your App’s Data Effectively

Comments
2 min read
Clean SQL with Comments: Syntax and Practices for All Engines

Clean SQL with Comments: Syntax and Practices for All Engines

Comments
1 min read
How to Start with Database Migrations

How to Start with Database Migrations

1
Comments 1
2 min read
Efficient String Splitting in PostgreSQL: 5 Essential Functions

Efficient String Splitting in PostgreSQL: 5 Essential Functions

Comments
1 min read
PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

PostgreSQL CASE: Conditional Logic for Powerful SQL Queries

Comments
2 min read
PostgreSQL CASE: Build Smarter Queries with Conditional Logic

PostgreSQL CASE: Build Smarter Queries with Conditional Logic

Comments
1 min read
Outer Joins in SQL: The Key to Keeping Unmatched Rows

Outer Joins in SQL: The Key to Keeping Unmatched Rows

Comments
2 min read
SQL DDL Commands Explained: Structuring Your Database

SQL DDL Commands Explained: Structuring Your Database

Comments
2 min read
How to Use SQL Views to Simplify Data Access and Reporting

How to Use SQL Views to Simplify Data Access and Reporting

Comments
1 min read
Three practical ways to create a database in MySQL

Three practical ways to create a database in MySQL

Comments
2 min read
Essential PostgreSQL Data Types Explained

Essential PostgreSQL Data Types Explained

Comments
2 min read
Handling Big Data in SQL Databases – Pitfalls to Avoid

Handling Big Data in SQL Databases – Pitfalls to Avoid

Comments
2 min read
SQL Temporary Tables: A Quick and Practical Guide

SQL Temporary Tables: A Quick and Practical Guide

1
Comments
2 min read
pg_dump PostgreSQL Backups: A Quick and Practical Guide

pg_dump PostgreSQL Backups: A Quick and Practical Guide

Comments
2 min read
SQL DATEDIFF Explained: Syntax and Database Differences

SQL DATEDIFF Explained: Syntax and Database Differences

Comments
1 min read
PostgreSQL Data Types: An Essential Guide

PostgreSQL Data Types: An Essential Guide

Comments
1 min read
Mastering SQL Server CONTAINS for Advanced Text Search

Mastering SQL Server CONTAINS for Advanced Text Search

Comments
1 min read
SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

Comments
2 min read
Getting Started with SQL DISTINCT

Getting Started with SQL DISTINCT

Comments
2 min read
Ace Your SQL Interview with These Query Tips

Ace Your SQL Interview with These Query Tips

Comments
1 min read
Fixing MySQL Shutdown Unexpectedly Error

Fixing MySQL Shutdown Unexpectedly Error

1
Comments
2 min read
Simplify SQL Queries with COALESCE

Simplify SQL Queries with COALESCE

Comments
1 min read
Mastering MySQL Security: Key Steps to Protect Your Database

Mastering MySQL Security: Key Steps to Protect Your Database

Comments
2 min read
Database Security Made Simple: Essential Practices

Database Security Made Simple: Essential Practices

Comments
2 min read
Simplified Guide to SQL DELETE Queries

Simplified Guide to SQL DELETE Queries

Comments
1 min read
Quick Guide to UPDATE Queries: How to Modify Data Efficiently

Quick Guide to UPDATE Queries: How to Modify Data Efficiently

Comments
2 min read
Faster SELECT Queries: Key Tips for Efficient Database Reads

Faster SELECT Queries: Key Tips for Efficient Database Reads

Comments
2 min read
MySQL INSERT Queries Made Simple

MySQL INSERT Queries Made Simple

Comments
2 min read
How Database Indexes Improve SQL Query Performance

How Database Indexes Improve SQL Query Performance

Comments
2 min read
loading...