Free SQL Server
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
1,217 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
1,217 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
185 reads
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
2021-10-06
318 reads
2020-11-13
114 reads
The challenges of state in databases can impact our development efforts.
2020-08-31
85 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
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
2019-10-24
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
2019-08-01
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers