A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...
2019-12-04 (first published: 2019-11-22)
The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.
2019-09-24 (first published: 2014-01-09)
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...
2019-05-27 (first published: 2019-05-09)
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
2019-05-20 (first published: 2019-05-05)
(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...
2019-05-03 (first published: 2019-04-22)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
(last updated: 2019-03-07 @ 15:40 EST / 2019-03-07 @ 20:40 UTC )
I ran across something the other day that I thought would be...
2019-03-15 (first published: 2019-03-01)