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...

wayne.mcdaniel (3/30/2012)

---

I've been working on something similar to this for a while. We wanted our database update utility to do an automatic backup before it started changing tables and...

Really, this article could be more of a general primer on how to call a stored procedure from a windows form application. If it included a best practive example of...

I think the best way to kick off backups would be to schedule them via SQL Server Agent job. If you're going to kick off your backups from something like...