Stefan Krzywicki (2/4/2011)

---

Steve Jones - SSC Editor (2/3/2011)

---

Tom, I'm less than concerned with debates in the editorial forum, or this Anything Not about SQL forum. Those are there for opinionated...

I think of life in terms of it being a game, so pretty much everything is a toy to me. Even such dangerous tools as tablesaws and nuclear bombs...

Web services aren't being deprecated, just the SOAP connections directly to SQL Server. You can still set up web services, until something better comes along. Just do them...

You're welcome.

Tom Brown (2/4/2011)

---

If Gus could repost his explanation of this LEET/4chan speak here it would be informative. It was the only info on 'that thread' that I'd like...

If you really need to do this, and I recommend against it, then all you have to do is expose the database server by setting it up to have an...

I'd just make it the default value in the stored procedure that inserts the data in the first place, assuming you're using procs.

Whenever I have to deal with this category of situation, I use a calendar table. You can define quarters, fiscal years/months, et al, in one, tied to actual dates....

Brandie Tarvin (2/3/2011)

---

This leads to another question. How easy is it to get a future tech job when you...

WayneS (2/3/2011)

---

Hmm, neither of these go anywhere (well, the first goes to the main forum...

You can expose SQL Server to the web and access it that way, but it's a really, really, really bad idea from a security standpoint.

Is there any way for you...

What data type is the timestamp column?

You need two tests for datetime intersection.

If A.Start < B.End and A.End > B.Start then they intersect. This covers A starting before B and ending after B starts. ...

Brandie Tarvin (2/2/2011)

---

Next question:

How did you half-management / half-DBA types deal with the overload of DBA tasks?

I.E., say there's too much workload for the DBA team to handle in...

It happens.