SQL

No Picture

CLR stored procedures in sql server

September 13, 2018 jlion 0

To create a CLR stored procedure in SQL Server….

I used this nice blog posting by Scott Sutherland as a starting point:
https://blog.netspi.com/attacking-sql-server-clr-assemblies/

If you are using SQL Server 2017 it will be necessary to sign your CLR assembly.

If you are doing this in a development environment, you may wish to create a public/private key pair:
https://docs.microsoft.com/en-us/dotnet/framework/app-domains/how-to-create-a-public-private-key-pair

Once you’ve …

No Picture

LINQ vs SQL

July 20, 2016 jlion 0

The excellent Joseph Albahari, author of LINQpad, wrote a blog post: Why LINQ beats SQL and while I really like LINQpad (how else would I debug LINQ?)  I do think Joseph misses the point a little with SQL. He says: “Compared to SQL, LINQ is simpler, tidier, and higher-level” and my first reaction is that SQL and LINQ …

No Picture

How to generate random data

June 9, 2016 jlion 0

I’ve been doing some performance testing of sql recently and wanted lots of data to work with. I didn’t want real data, with names and other confidential information. I’ve been using a function I created a few years ago and which is presented below. The function can be used to generate either numerical data, alpha data, or a combination, within …