SQL# contains just about everything I'd want to do that isn't already in T-SQL.

It think SQLCLR has yet to have its day. I firmly believe that it has potential...

I really must replace my 8 year old PC running XP. It's good enough for web browsing, running MS Word, tinkering with SQL 2008R2 and a few others. ...

A present headache is trying to employ agile methodologies across geographically disperse teams. One of the things about agile is that it encourages all participants to be co-located and...

The tech debt things certainly rings true for me. There's nothing like working through the source code for an old report and finding that what it was reporting was...

The trick is to have a defined baseline for the database for the CI build to deploy onto. In effect the first DB step in a CI deployment is...

Nothing. This article is demonstrating a proof of concept using a library without having to install Excel on...

I've given an oddball answer to a straight question.....and got the job.

It was the "have you got any questions for me" question.

My answer was "have you got any wire because...

@odeddror I think the answer is in the Terminate function

public SqlDouble Terminate()

{

if (count > 0)

{

SqlDouble value = (count * SumXY - (SumX * SumY)) / Math.Sqrt((double)((count * SumX2) - (SumX...

Fortunately its not that bad. Cloud based machines behave just like any other virtual machine and depending on what you rent you can choose...

Round and round we go.

Outsource your peripheral functions (like payroll) but keep your assets close. The cloud is a natural extension of this.

For development work spinning up a temporary...

odeddror (2/5/2014)

---

Hi there,

I'm using SQL Server 2012 x64 and VS 2013

I follow your code and

The T SQL return -0.99988192786007

And CLR return 0.999766931939805 (positive number...

Jim, my experience is that you will rarely get isolated pockets of woes.

If you don't like the SQL then a good developer will find that the code is wonky. ...

I've just spent two days fighting something similar importing a text file.

I found that adding a data conversion component did work, but turned a simple import of 1.6 million rows...

@jason, that is a very good point. Under the UK data protection act an individual can ask that their records be removed in certain conditions. Imagine having to...

My first task in my first IT job was to take a lump hammer to a set of Wang minicomputer hard disks!

Probably my first experience of job satisfaction.