Best Quad Core Processors for SQL Server 2014 Enterprise

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 … Continue reading “Best Quad Core Processors for SQL Server 2014 Enterprise”

SHA256 Hash Stored Procedure for SQL Server 2008

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 … Continue reading “SHA256 Hash Stored Procedure for SQL Server 2008”