(last updated: 2019-03-15 @ 02:45 EST / 2019-03-15 @ 06:45 UTC )
Binary collations are, in many ways, simpler to understand than non-binary collations...
2019-03-13
13,470 reads
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
1,011 reads
(last updated: 2019-01-31 @ 22:45 EST / 2019-02-01 @ 03:45 UTC )
Today’s “Question of the Day” on SQL Server Central, Cleaning up the...
2019-02-20 (first published: 2019-01-31)
5,947 reads
(last updated: 2019-01-15 @ 19:50 EST / 2019-01-16 @ 00:50 UTC )
I haven’t seen a lot written about these particular behaviors so I...
2019-01-28 (first published: 2019-01-15)
2,398 reads
(last updated: 2019-01-08 @ 13:53 EST / 2019-01-08 @ 18:53 UTC )
There are times when I am working on a SQL script that...
2019-01-08 (first published: 2018-12-28)
4,855 reads
Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2019-01-03 (first published: 2018-06-12)
8,702 reads
(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...
2018-11-12 (first published: 2018-10-31)
3,391 reads
(last updated: 2018-12-26 @ 16:20 EST / 2018-12-26 @ 21:20 UTC )
(NOTE: For recent update, please see “Update for CTP 2.2” section)
For some...
2018-09-28
10,333 reads
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
4,045 reads
Occassionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example:
Enabling...
2018-06-06
1,167 reads
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers