Retrieving a Binary File from Your Database
In this second article I provide the means to restore a binary file to its original state.
2015-05-28
10,718 reads
In this second article I provide the means to restore a binary file to its original state.
2015-05-28
10,718 reads
2016-08-23 (first published: 2015-05-01)
1,351 reads
2014-02-20
1,918 reads
You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.
2014-01-06
2,453 reads
SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.
2013-10-07
6,013 reads
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
2013-05-07
9,898 reads
Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables
2012-09-06
16,770 reads
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
2012-02-20
5,787 reads
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
2011-08-01
2,863 reads
How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available
2011-07-25
6,833 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers