Thanks for the note. I won't make it this time, but Andy Warren went and enjoyed it. I'll try to go when I come back in August.

In a source control session at SQL Saturday #22. Surprising that quite a few people don't use an VSC for their SQL Code.

What do you guys use? Manual versioning?

I'm sure they would pay $250/hr for 7 sec of advice. 😛

test, test, test. If you need it, give it a go. If not, hold off. I wouldn't blanketly apply this to all systems.

I heard from MS the other day that...

Well that was quick.

Do you know about this one? http://msdn.microsoft.com/en-us/library/cc280574.aspx

Jeff Moden (6/3/2010)

---

Steve Jones - Editor (6/1/2010)

---

There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a...

Saw this, interesting. Outsourcers hurt by recession, might not come back as strong.

http://itmanagement.earthweb.com/features/article.php/3885751/IT-Outsourcing-Trends-Slow-Growth-Cloud-Computing.htm

I have done separation like this, vertical partitioning for some data. I don't see an issue with it, and like Jeffrey, I wouldn't add an identity to this. I'd just...

This says it's possible: http://msdn.microsoft.com/en-US/library/ms143393%28v=SQL.90%29.aspx

I believe you run setup and pick upgrade and select your instance. Note that not all features in Dev edition are in Standard. You might have...

I agree, if you want to defend your decisions, you need reasons. I'll say I've defended a practice multiple times to new people, and eventually started telling people that "we...

It's always a balance, right? Sometimes the old ways work well and changing for the sake of change isn't worth it. Sometimes you need to move on.

It's a question of...

The open space might not work for you, but it's worked well for me at times. It's not completely unproductive. Joel thinks so, and they built their space differently: http://www.joelonsoftware.com/articles/BionicOffice.html

However...

I'm with the Ninja, why not just batch delete. If you ran this every night, you could end up deleting 1000 a night instead of trying to do 30,000 once...

A firewall is a wall with holes in it. The holes are there deliberately, left to open certain things up to pass through. For example, the firewall I have for...

Sample

CREATE TABLE MyNewTable

( id INT

, mychar CHAR(1))

GO

INSERT MyNewTable SELECT 1, 'A'

go

CREATE TABLE MyOldTable

( id INT

, mychar CHAR(1))

GO

INSERT MyOldTable SELECT 1, 'A'

INSERT MyOldTable SELECT 2, 'B'

INSERT MyOldTable SELECT 3, 'C'

INSERT MyOldTable...