GitHub

SQL Server DDL for metadata tables should use NVARCHAR to prevent performance degradation and deadlocks from implicit conversion

I'm reporting a significant performance issue and a potential for deadlocks when using Spring Batch with a SQL Server database. The root cause is a data type mismatch between the default Spring Batch ...
GitHub

SQL Server reports column size of 0 for nvarchar

I can't verify this bug with other databases, but I'm dealing with SQL Server 2014 via R-3.2.5 and RODBC-0.2.5 (haven't updated this one machine since you fixed my last issue, thanks!). When a schema ...
crossjoin.co.uk

Data Type Conversions For SQL Server Sources And Query Folding In Power Query

It’s surprisingly easy to stop query folding happening in Power Query by changing the data type of a column. This is mentioned in the docs here, and it’s something several people have blogged about ...
SharePains by Pieter Veenstra on MSN

SQL Functions for Encrypting and Decrypting Large text fields

After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption ...
Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...