Below I've setup a practical illustration of why this matters. Using the exact same SQL query, the sum of payments is 100.00 when LANGUAGE is set to US_ENGLISH, but the...

Lynn Pettis (2/18/2013)

---

Eric M Russell (2/18/2013)

---

SQL Server doesn't store date/times values in a format, it's just a typed integer.

However, SET DATEFORMAT setting influences how date/time values are displayed in...

SQL Server doesn't store date/times values in a format, it's just a typed integer.

However, SET DATEFORMAT setting influences how date/time values are displayed in a resultset and how strings...

TravisDBA (2/18/2013)

---

You can't reallistically farm out long-term IT technical support to outside contractors without it costing a bunch of money the government claims it doesn't have nowadays. IT support is...

There are some Android apps out there that claim connectivity and querying functionality for Oracle, MySQL, or SQL Server.

http://www.appszoom.com/android_applications/business/mysql-sql-client_bbwxj.html

There is a Microsoft JDBC Driver for SQL Server:

http://msdn.microsoft.com/en-us/sqlserver/aa937724

Also several...

TravisDBA (2/15/2013)

---

Eric M Russell (2/15/2013)

---

TravisDBA (2/15/2013)

---

i agree, but the problem with that many times is that...

TravisDBA (2/15/2013)

---

i agree, but the problem with that many times is that narrative turns out to...

I know that a candidate needs to present themselves well in an interview and be able to write SQL, or manage an instance, but when you are examining dozens of...

I'm not directly involved in hiring decisions, but I do field resumes and then participate in interviews and rate candidates afterward. There really is no one thing I'm looking for...

TravisDBA (2/14/2013)

---

I completely agree with Gary, it depends on the culture, particularly if you work for the government. They look at this a whole different way. For example, once I...

Competition for jobs gets more intense all the time and the employees that look for problems and provide solutions without being asked will be the most valuable. They will stand...

PaulB-TheOneAndOnly (2/8/2013)

---

nick.mcdermaid (9/20/2012)

---

In Oracle, client tools are painful. You need to buy TOAD for a GUI, and has some good features (CTRL-Clkick to get table info) but it's basically a...

Here’s how Watson works: The computer has been preloaded with information taken from encyclopedias, news articles and even the Internet. Other components include software that analyzes the question or clue...

Miles Neale (2/7/2013)

---

Eric M Russell (2/7/2013)

---

Miles Neale (2/7/2013)

---

Back in 1975 IBM or one of it's team unofficially stated it would take a two story computer the size of the state...

Miles Neale (2/7/2013)

---

Back in 1975 IBM or one of it's team unofficially stated it would take a two story computer the size of the state of Texas to replicate the...