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,614 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
472 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
222 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,839 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
284 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
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers