Generating Art
Using metadata to drive software is very useful, which means that having clean data and lots of metadata can help create better software.
2021-03-30
94 reads
software development
How Quickly We Forget
One of the interesting things about modern software is how updates are handled.
2021-03-29
87 reads
2021-03-25
170 reads
UX Matters
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
2021-02-25
114 reads
Do it. Try it. Fix it.
Building better software requires some experimentation, but also some learning. Building better software as an organization requires even more.
2021-02-04
328 reads
Cutting Edge Technology
Cutting edge technology might vary for many people, and Steve wonders what you think.
2021-01-29
119 reads
The Responsibility for Bugs
Today Steve wonders who should be responsible for software bugs, something of which we have no shortage of in our industry.
2021-01-11
124 reads
Practice Your Skills with the Advent of Code
The annual Advent of Code challenge is underway, and you can use it to help grow your career.
2020-12-08
242 reads
A Technology Collapse
Today Steve looks at legacy systems and the challenges they pose as we try to adapt them to new requirements.
2020-12-05
254 reads
2020-11-23
131 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