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)
3,821 reads
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)
30,628 reads
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)
1,257 reads
Specific String Pattern Magically Hidden From Step Output in SQL Agent History. Who Knew?… Continue reading Specific String Pattern Magically Hidden From Step Output in SQL Agent History ?
2019-06-21
159 reads
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)
798 reads
(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)
2,872 reads
(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)
511 reads
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,394 reads
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...
2019-03-25
484 reads
(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)
3,658 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...