Versioning Over Time
How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.
2008-12-10
781 reads
Editorial - MP3
Alone Time
Working in a distributed team can be challenging, but working in an office can be just as difficult. Steve Jones talks a bit about time management today.
2008-12-09
805 reads
2008-12-08
736 reads
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-06
754 reads
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
2008-12-04
82 reads
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
778 reads
2008-12-01
136 reads
The Ebb and Flow of Community
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
2008-11-26
778 reads
2008-11-25
513 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
776 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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...
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