2009-01-22
848 reads
Editorial - MP3
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2009-01-21
779 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-20
774 reads
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
2009-01-16
88 reads
Surface Possibilities
The Surface is Microsoft's tabletop computer that can be controlled with your hands and doesn't require a keyboard. Is there value in this system for DBAs?
2009-01-16
839 reads
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
2009-01-14
78 reads
The Hassles of Travel
As he prepares for a trip across the Atlantic, Steve Jones talks about some things he doesn't like about travel.
2009-01-14
71 reads
No More Lottery
Steve Jones talks about the lack of a big payday for tech workers. Not that most of us were expecting one.
2009-01-13
448 reads
2009-01-11
776 reads
Little Security Issues
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
2009-01-11
507 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