Sometimes a minor failure, more like a temporary set back, results in a re-evaluation of our career, and it is actually becomes the impetus for moving to the next level...

Most organizational employers expect data analysts to be subject matter experts with some background in SQL, and they expect DBAs to be database/network/ETL/Windows/Linux experts. An exception would be startups, who...

robert.diley (5/14/2014)

---

I do have a text in front of me: Fritchey, Grant (2012) SQL Server Execution Plans, 2nd ed.

From p. 88:

"we can discuss the Hash Match join operator.

It occurs when...

It's nice that we have cloud computing and database providers that are guaranteeing 99.9% uptime, but who has an internet service provider that can guarantee the same?

Soon the morning news...

patrickmcginnis59 10839 (5/13/2014)

---

I know next to nothing about the technical implementation or bitcoin or even how it work conceptually, but relational databases typically use unique key constraints to prevent events...

patrickmcginnis59 10839 (5/13/2014)

---

Gary Varga (5/13/2014)

---

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

---

Gary Varga (5/12/2014)

---

There are but have been deemed too expensive and unnecessary for what NOSQL was originally intended for. Basically, it...

Eric M Russell (5/9/2014)

---

Andy,

I'm curious about why you chose the title "Datatypes In Your Mind".

Did you expect this TinyInt vs Bit question of the day to create some controvery...

Andy,

I'm curious about why you chose the title "Datatypes In Your Mind".

Did you expect this TinyInt vs Bit question of the day to create some controvery and debate?

Obviously running ad-hoc queries against unstructured data is a use case for a NoSQL database, and MongoDB is good for that. This would include things like ecommerce shopping carts and...

In some sense the DevOps movement is built around merging these two frames of reference into the minds of all those involved. I hope that movement continues to grow and...

Tinyint is an underappreciated datatype. I leverage it a lot for small range keys like marital_status or for things like service_years. A lot of developers punt and always use 4...

Usually when we interview candidates, the recruiter has already required them to complete a standard technical assessment exam and HR has qualified them based on their education and visa status....

homebrew01 (5/5/2014)

---

What type of SQL Database questions would you ask of a prospective junior PHP web developer. We know he is fairly new at it, so no tricky "gotcha" questions....

Sorry - you were wrong

Correct answer: TinyInt

Explanation: There are four data types that are integer/exact number: bigint, int, smallint, and tiny int. The ranges of...

That's one the biggest database design mistakes. First, there are a...