Michael Valentine Jones (2/22/2013)

---

I don’t see how this list could be complete without mentioning COBOL.

From the 1960s until about 1990 it was the language of choice for business programming with...

I think the average age for database developers and sysadmins must be like 40. Maybe a few years more for sysadmins.

My first computer was a Commodore 64, basically the same as a VIC 20, except it has a whopping 64 KB of RAM instead of the VIC's 5 KB. Like...

crazyEmu (2/21/2013)

---

Was confronted by a trigger just yesterday, wonderful use of nested cursors. Just had to post it as an example.

It is supplied by a vendor (Sage \ SalesLogix) so...

But I'm somewhat amazed how many fragmentation questions, posts, articles, and more that I still see on a regular basis. Shouldn't this be a low level feature of SQL Server...

After sitting around the office all day long, it's refreshing to get outside and either take a couple hour hike or mow the grass or something. As for shoveling horse...

keith.fearnley (2/20/2013)

---

Though wary of re-igniting the discussion (informative and lively though it has been), I wonder how this relates to the HL7 RIM model (look up RIMBAA) - as I...

Fortunately SQL Server is self documenting, at least in terms...

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