Data Reconciliation can involve things like identifying the uniqueness, completeness, and validity of records. That logic may not be part of the injest, but rather a process that analyzes and...

I read the 2nd edition of this book several years back. It's not about how to use BI tools at all, but rather more about how to apply data mining...

As a result of updates, heap (nonclustered) tables can accumulate a type of fragmentation called "Forwarded Records". If the updated row incrases in length and SQL Server can't fit it...

Regarding the issue of how to implement a rollback when deploying DDL/DML scripts, I'd prefer to deploy major changes (altering or bulk updating large tables) at an off hour with...

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