Writing Before Reading
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
2026-05-13 (first published: 2020-05-21)
214 reads
software development
2020-05-19
101 reads
Keeping Unique Aliases
Steve prefers having standards, and today notes that aliases should be included in your standards document.
2020-04-28
161 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
123 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)
278 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
538 reads
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
2020-01-04
326 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
230 reads
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
439 reads
It's Natural to Avoid Problems
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
276 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