The New Leader - Database Weekly (Sept 29, 2008)
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
780 reads
Editorial - MP3
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
76 reads
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
2008-09-24
71 reads
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
2008-09-23
76 reads
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
2008-09-22
79 reads
Face to Face
The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.
2008-09-21
105 reads
Good Data Loss - Database Weekly (Sept 22, 2008)
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
2008-09-19
766 reads
The Glue that Binds
This Friday Steve Jones polls the community of developers about the time they spend dealing with data access.
2008-09-18
67 reads
The Release Schedule
Coordinating the release of software among all the groups involved can be quite a chore. Steve Jones comments on some of the challenges.
2008-09-17
97 reads
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
2008-09-16
75 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