mdsantos (5/13/2015)

---

Hi to all,

In my company we are dealing with a very strange problem in the last couple of week in a SQL 2012 server. And maybe you could give...

Some unit tests are derived from high level assertions (ie: each active sales person should be assigned to at least one but no more than three sales regions), and these...

TrailRunner,

You mentioned training for DB2, MySQL, MongoDB, AWS (EC2 + RDS), Netezza, Linux, and Attunity within the past year. Are all these platforms leveraged on the same project, or do...

Iwas Bornready (5/13/2015)

---

TrailRunner (5/12/2015)

---

I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good...

Jeff Moden (5/13/2015)

---

Eric M Russell (5/13/2015)

---

In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition...

Use this to get more detail about the internal storage of your table (clustered index) and non-clustered indexes, which includes avgerage fragmentation percentage and average page density.

select

schema_name(o.schema_id)schema_name,

...

In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which is about $50...

We really should setup a file share...

TrailRunner (5/12/2015)

---

I switched to the new job for more learning opportunities, so learning new / different things is very important to me. However, too much of a good thing is...

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