In the final installment of this three-Level series, we use another automation-related feature to do what SSDT doesn't handle natively.
2022-06-01 (first published: 2016-03-03)
5,704 reads
This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).
2021-03-10 (first published: 2016-03-01)
5,468 reads
SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.
Solution
Expose the C# Hashbytes function using CLR
2015-12-01 (first published: 2015-11-06)
883 reads
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,565 reads
Script lists all the clr objects in the database.
2016-08-23 (first published: 2015-05-01)
1,310 reads