How to Improve Database Design to Speed Up SQL Queries
This article examines some basic database design principles that help ensure your queries can execute more quickly.
2023-05-15
9,589 reads
Database Design
How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop
Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization.
2022-10-12
How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
2022-09-14
One or Many Databases
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
465 reads
SQL Server and Oracle Create Table Comparison
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
2022-04-01
Is the Database a Series of Microservices?
Is a database like a series of micro-services? Steve draws an analogy today.
2021-11-12
220 reads
Missing Data
When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.
2021-04-12
2,828 reads
A Beginning Project
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
283 reads
Gitflow Workflow Feature Branching for SQL Database Projects
Learn how to use Gitflow workflow to meet the needs of developing new database related features and how to deploy these database changes.
2021-01-21
What is a Relational Database Management System
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
2021-01-07
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers