Database deployments have unique challenges like: altering or dropping/recreating schemas while preserving existing data, object dependencies, schema variations between development, QA, UAT, and production.

However, the most problematic issue is...

Database cloud services in 2012 are sort of like web application frameworks back in 1996; the basic technology infrastructure is there, but folks are still debating about what to do...

Just as cell phone providers have been using aggressive marketing and competitive pricing plans for decades, perhaps cloud database providers will also use highly publicised outages and security breaches to...

A lot of the advise here is appropriate for a production database (don't shrink the files, etc.) where the goal is to preserve restore history and optimize performance.

However,...

ranganathleo (11/29/2012)

---

Have been asked by a customer to reduce the database size to latest 10% of its data. Not sure how to achieve this. Any help regarding this would be...

When we submit change orders...

If an application is loosely coupled (if the term is appropriate here) with the database using stored procedures, web services, and meta-data configuration, then even significant changes to the database...

David.Poole (11/21/2012)

---

Anyone have a view...

SQL Server has actually had NoSQL data storage and analysis products bundled with it for over a decade. Take for example, Analysis Services. People don't generally think about OLAP products...

poratips (11/13/2012)

---

Hi,

I have few more questions too.

I have also few Databases coming from one DB server and other one DB coming from other DB server so I will...

poratips (11/13/2012)

---

I will be building brand new test enviornments ans need to restrict user for security purpose so need to create Group for each Role

anad assign user to each Role...

Practically all of the really large databases I've worked with in the past could have benefitted from better normalization and data type usage. For the most part, I think that...

poratips (11/6/2012)

---

Thanks So much.

I have another situation that my developer wants some tables from Prodction DB server to their desktop m/c.

We have already sql express installed and Database and tables...

Eric M Russell (11/7/2012)

---

When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:

- If Col1 = 'A'...

When it comes to data quality in large enterprise organizations, what's essential is that the rules be formally documented (before development begins).

For example:

- If Col1 = 'A' then Col2 must...