I'm not saying that the whole idea is bad (or wrong). Just the step where SQL Server makes a JSON document on the server side could be easily moved to...

SQL Server is expensive (compared to web servers and other software). Standard Edition costs >1K per core and Enterprise is about 6-7K/core. Why would you want to use it to...

Mixed mode assembly will (most probably) need to be created as UNSAFE (since it's a mix of C# and C++ code).

Also the C++ part of it will have to be...

You could be right. At some point (after upgrading to SQL 2005) we switched from VBScript + COM to

C# code (for scripting all our objects into search engine).

There is very little reason to use IronPython when CPython offers so many great (well tested) libraries for everything you could possibly need (and code snippets are available on the...

You need to sign assembly with certificate, and then you don't need to make your database trustworthy. Most of the time you will see articles (on internet) that use trustworthy...

... and you can load any COM junk (with memory leaks...

Hi, the problem is not in the nvarchar type but in the limitation of sp_OAGetProperty in the line:

EXEC @hr = sp_OAGetProperty @Obj, 'ResponseText', @json OUTPUT

🙂 https://www.hackerrank.com/challenges/array-and-simple-queries ...

I hope you get that job.

Hi, i think you can speed up your list "slice and dice" if you convert list to (byte) string using struct module and pack/unpack.

from struct import *

def string_query(s, t, i,...

I use Python for everything (related to administration) and most of the ETL stuff (using xsd and XML Bulk Load (SQLXML).

Check out if you have a battery on your raid controller.