ORM's

Uncommented code

We convert between XML and JSON very regularly by using the JSON.NET library in c#.

you could write an exe that takes in the JSON and easily converts it to XML,...

I think there is a HUGE understanding of what Computer Science is (everywhere not here).

It is not supposed to be a training tool for IT, although it can be.

Computer Science...

Currently running 2012 , will upgrade to 2014 this year or next.

CREATE FUNCTION dbo.SubFunction

(

)

RETURNS XML

WITH RETURNS NULL ON NULL INPUT

BEGIN

DECLARE @xml XML

;WITH XMLNAMESPACES

(

'http://www.example-namespace.com' AS ns

)

SELECT @xml=(

SELECT

...

Dalkeith (1/7/2014)

---

Absolutely all Developers should have a clear understanding of primary and foreign keys and the idea of relationships between tables and how the differences between different query types. (...

I agree, on doing small slices of the data model, I guess I'm just worried about the re-factoring chunks near the end. But as was mentioned earlier, those...

So I'm completely...

I see mostly Contract jobs, or Temp to Perm jobs and mostly with consulting companies.

Very few perm non-consulting company work.

Toby Harman (11/13/2013)

---

Ultimately we will see more and more of this from the likes of LINQ and other ORM tools.

Admittedly these aren't particularly complex SQL most of the time, and...

I agree this is an interesting discussion topic.

Great update.

I added in some conditional highlighting if anyone was interested in seeing it. Currently it will turn the cell red if a differential backup is over x days....

I'm glad to see I'm not the only one who hates open floor plans.

"No I don't want to shoot nerf guns with you, or hear you play guitar or practice...

Sean Smith-776614 (9/12/2013)

---

Hi, Joe.

I just realized that this uses an undocumented feature. I already have one in the script and I try to avoid them like the plague (just in...

chumphrey 12211 (9/11/2013)

---

Joes ErrorLogReporting code uses SP xp_readerrorlog. If you cycle your SQL Server error log daily be sure to schedule your report BEFORE you cycle your error log...