One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for a system but might require more effort work from developers to write queries. Many […]
2023-09-22
1,395 reads
A fun contest from Steve asks you to design a system that tracks travels for a fictitious business.
2023-08-11
1,597 reads
The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".
2023-08-07
4,154 reads
This article examines some basic database design principles that help ensure your queries can execute more quickly.
2023-05-15
7,890 reads
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
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
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
332 reads
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 a database like a series of micro-services? Steve draws an analogy today.
2021-11-12
173 reads
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,655 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
I am getting the following error when I launch web service url in sql...
Trying to deploy reports in visual studio 2022, reporting service login is asking for...
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...
Ask SSC