Creating vs. Maintaining
When you create something, do you think about the future? Steve asks the question today.
2025-01-29
137 reads
When you create something, do you think about the future? Steve asks the question today.
2025-01-29
137 reads
2025-01-17
118 reads
There are a number of ways to run SQL Server for free (or low cost) for development. Read a bit about how to do this.
2024-02-23
5,261 reads
One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.
2023-05-22
When I first started work as a software developer, I knew that getting an environment set up where I could compile a project might take a few hours or a few days. The complexities of how people built software projects, the dependencies, and more were handled in a very immature manner. These days I can […]
2022-11-16
203 reads
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
2021-10-06
371 reads
2020-11-13
118 reads
The challenges of state in databases can impact our development efforts.
2020-08-31
89 reads
In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to get even better performance.
2020-07-17
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
2019-11-25
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Kevin3NF
Things your cloud vendor may not tell you Here’s a common theme I...
I will have to test this next week, but will not have a chance...
I want to add a condition in the joining columns part of the merge...
Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers