Separate Reads
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
2024-11-13
152 reads
software development
Tech Debt Perils
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
2024-10-21
182 reads
Everything is Code
The executives at CrowdStrike testify before the US Congress, noting their software development process needs work.
2024-10-11
183 reads
Keep. It. Simple.
How simple should software development be? Steve notes it can be simple, but not too simple.
2024-10-09
203 reads
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.
2024-10-04
Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
478 reads
Event Streams for Persistent and Asynchronous Microservice Communication
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
2024-09-11
A Lack of Architecture and Planning
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
2024-08-19
219 reads
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
2024-07-19
184 reads
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
2024-07-01
186 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers