Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
2008-10-11
82 reads
Editorial - MP3
Database Health
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
2008-10-09
94 reads
Project Management Management
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
2008-10-08
92 reads
Take the Plunge
Today Steve Jones talks about starting your own business and should you do it with online tools.
2008-10-07
88 reads
A Better Database Engine
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
2008-10-06
74 reads
Social Hacks
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
2008-10-05
81 reads
The Weekly News for Oct 6, 2008 (Database Weekly)
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
2008-10-04
765 reads
Speed or Value?
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
2008-10-02
74 reads
Managerial Relations
Steve Jones talks a bit more about the employee manager relationship in this turbulent times.
2008-09-30
70 reads
The Relational Manager
Managing DBAs can be a challenge for both sides. Steve Jones talks a bit about some of his relationships with managers and the trouble that sometimes occurs.
2008-09-29
69 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