mohan.bndr (3/29/2012)

---

Hi,

I am going to handle new project in my org., before that i need to know technlogies,versions,application softwares and databases etc. that they are using. So I require help...

Google the following:

site:*gov data publications

For example:

http://www.census.gov

Seeing the shattered remains of all these businesses in the wake of a tornado or hurricane is also a reminder of the importance of off-site backups. Insurance will cover the...

Grant Fritchey (4/5/2012)

---

No online ones coming up. SQL Saturday in Atlanta a week from Saturday... Um... Rally in Dallas, SQL Saturday in Rochester. Those are the best opportunities I have...

If you can implement this requirement as a table check constraint, then that would perhaps be the best solution, because it would involve no programming work arounds. For example, let's...

I use TFS, but up until about three years ago, I was still using Visual Source Safe 6.0. It was good enough for versioned source control, which is why it...

It's a heck of a lot earier and cleaner to install guard rails around the edge of a bridge to prevent people from leaping, than it is to install a...

I maintain DDL scripts for each object in the database. I don't maintain a series of incremental change scripts, but rather there is one script per object. Typically, the script...

S_Kumar_S (4/5/2012)

---

A bad update can be anything that makes the data which it should not be. e.g. someone running update statement without where clause or someone updating incorrect values e.g....

S_Kumar_S (4/3/2012)

---

We have a table which is used by many pages on our website.So it's an important table.

Now during development( I am talking about development environment here, no production),...

n00bDBA (4/3/2012)

---

Thanks Eric,

I just don't want to start asking around and saying im planning on doing this super great thing.. then fail horribly at it! I work in a...

If you are building this data warehouse...

n00bDBA (3/31/2012)

---

Hello!

We have a lot of database used in 3rd party apps. Things like shop sales. and marketing data.

As i understand it. The best way to Analyse the data...

Sean Lange (4/2/2012)

---

Eric M Russell (4/2/2012)

---

jamesforest (3/21/2012)

---

In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I...

jamesforest (3/21/2012)

---

In testing with auto increment I havde noticed the ID field gets incremented even when the insert fails resulting in missing entries. I have tested on 2 build...