The Challenge of Early Tech Decisions
We often live with our early decisions on technology, which can be a challenge over time.
2022-09-12
175 reads
software development
2022-06-27
216 reads
Flawed Data Integration
These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.
2022-06-13
156 reads
The Craziness of Code
Building software can seem like a crazy process, especially to a developer who joins a project.
2022-04-25
286 reads
The Backlog
A backlog is important for software development, and Steve has a few thoughts on how to add things to the backlog.
2022-04-08
279 reads
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
2022-03-14
143 reads
Speedy Break Fix
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
2022-02-07
272 reads
It Isn't Worth Automating
Every year I'm responsible for a portion of the Database Weekly newsletters. I used to do half, but right now Kathi, Grant, and I are on a rotation. Our boss puts out a schedule each year, which tells me the weeks for which I am responsible. Each January I then set up a recurring appointment […]
2022-01-17
202 reads
Coding for the Future
Writing code that solves problems and adapts to the future is a challenge, but it's something we should think about.
2022-01-12
289 reads
Worse Before Better
We need to approach software development with a balance of making things better, and ensuring they work.
2021-12-08
235 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