Google, Microsoft, and Amazon are large enough players that they could provide both the cloud database services and the internet infrastructure for high or middle tier business customers. Perhaps some...

Gary Varga (5/12/2015)

---

Eric M Russell (5/12/2015)

---

I'd be willing to trust the cloud database provider, especially if it were Azure. They understand things like disaster recovery and service level agreements.

Who...

I'd be willing to trust the cloud database provider, especially if it were Azure. They understand things like disaster recovery and service level agreements.

Who I don't trust are the...

Steve Jones - SSC Editor (5/12/2015)

---

I think for the DBAs/developers, who perform the ETL stuff, we do need to think about knowing JSON, XQuery, and more to help us transform...

I'm assuming you want to allow users to query Customers by Email Address, but you don't want to allow them to query Customer email addresses in bulk, and you'd rather...

Companies that originate large databases that would be of public interest (FaceBook, Amazon, NetFlix, etc.) do open up their data, but for a number of obvious reasons they prefer do...

marcia.j.wilson (5/7/2015)

---

Eric M Russell (2/10/2012)

---

Another scenario is where the developer includes un-needed table joins and returns additional columns that are never referenced by the application or reporting tool. I've even...

Gary Varga (5/8/2015)

---

I have seen this in a large number of places with the belief that it was just better...

Bradley Deem (5/7/2015)

---

Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the point in time...

Creating objects is straightforward, but I've found the most problematic DDL deployment scripts are those that alter tables. However, INFORMATION_SCHEMA and SYS tables can be leveraged to determine to current...

Yet Another DBA (5/6/2015)

---

Been writing my release scripts like this for years. Like you I didnt know there was a specific term for it.

As one co-worker said: "write it like...

djackson 22568 (5/6/2015)

---

Eric M Russell (5/1/2015)

---

djackson 22568 (5/1/2015)

---

...

I recall a discussion here regarding whether college is useful. This is an area where I think a good education is useful....

For slowly changing reference tables, something like States or ProductCategory, I prefer to maintain the entire collection of inserts bundled into one "idempotent" deployment script. When adding a new row,...

Steve Jones - SSC Editor (5/5/2015)

---

Eric M Russell (5/5/2015)

---

In most scenarios the auditing operation should be done asynchonously, if possible, for performance reasons. But you can't do that if the...

For me, proactive performance optimization is analyzing Estimated Excution Plans within the SSMS Query window, as I'm in the process of writing the stored procedure. Also, I'll querying Actual Execution...