2020-06-30
171 reads
software development
Building Better Software for Everyone
Building better software might be a bit more work when we consider ensuring everyone can use our work.
2020-05-25
93 reads
Writing Before Reading
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
2020-05-21
91 reads
2020-05-19
88 reads
Keeping Unique Aliases
Steve prefers having standards, and today notes that aliases should be included in your standards document.
2020-04-28
135 reads
Teams That Ship
Running software teams isn't as easy as it may seem, and the way you manage a startup is different than a mature organization. Steve has a few comments on the process one angel investor implements.
2020-04-14
104 reads
Looking Back
Today Steve talks about retrospectives and how we learn and grow as software professionals.
2022-08-24 (first published: 2020-03-30)
206 reads
A Problem with Cowboy Coding
Cowboy coding can be a problem, and in a case Steve talks about, a temptation for someone to get more work.
2020-01-08
506 reads
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
2020-01-04
281 reads
Become a Technological Historian
This week Grant muses on how history can impact our decisions moving forward, and having a little empathy can be useful when re-examining the past.
2019-10-26
132 reads
Blogs
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
Forums
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Duplicate Documents
Hi Experts, I am trying to find duplicate documents stored in our Filestream database....
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers