SQL Archives

Best Quad Core Processors for SQL Server 2014 Enterprise

May 2, 2014May 2, 2014 by Benjamin Bryan

SQL Server 2014 Enterprise Licensing Efficiency on Four Cores Microsoft Core Licensing Microsoft pricing per core is $13,748 (your price may vary depending on your licensing program) per set of two cores, with a four core minimum per processor (a dual core counts as a four core so it doesn’t make sense to go with … Read more

SHA256 Hash Stored Procedure for SQL Server 2008

January 25, 2014 by Benjamin Bryan

The other day I was writing an ETL where I expected duplicate data to be accidentally sent over quite often so I needed an SHA-256 function to guarantee that a set of incoming rows were unique (notice I said the set of rows, not individual rows so that rules out using an index to prevent … Read more