Miles Neale (2/19/2013)

---

While I agree that there can...

fatinnadiah88 (2/13/2013)

---

anyone knows the different between Application DBA and Production support DBA? In my understanding, production support is the person whom maintaining the database, then what about application DBA?

Many thanks!...

Last year at PASS I heard one person proudly proclaim that we "like our databases dumb!" He, like many others, wanted to avoid putting any logic in the database in...

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