SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQLCLR Rss

   Items 1 to 20 of 95    Older >>
 

SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server

SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features of SQL Server. Amongst the legitimate reasons for avoiding SQLCLR, there is the fear of getting bogged down in code with special requirements that is difficult to debug. Darko takes a real example, extending the features of sp_send_dbmail, to demonstrate that there need be few terrors in SQLCLR.  Read more...
By Additional Articles 2017/09/25 | Source: SimpleTalk | Category: sqlclr
Rating:  Rate this |   Briefcase | 5,615 reads

Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.   Read more...
By Darko Martinovic 2017/06/05 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,890 reads

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report. The purpose of this script is to decode this information. The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.   Read more...
By Darko Martinovic 2017/04/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 784 reads

Getting resource name from blocked process report

The Resource name is most important information in the blocked process report. The purpose of this script is to decode this information. The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.   Read more...
By Darko Martinovic 2017/04/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 784 reads

Getting resource content from blocked process report

This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.   Read more...
By Darko Martinovic 2017/02/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 426 reads

Generate two-dimensional QR Code® bar codes in an SSRS report

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.  Read more...
By Stan Kulp 2016/09/05 (first published: 2014/01/14) | Source: SQLServerCentral.com | Category: qr code
Rating: |  Discuss |   Briefcase | 8,454 reads

List CLR Objects in Database

Script lists all the clr objects in the database.  Read more...
By Harsha Majety 2016/08/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,220 reads

Consuming JSON Formatted API Data in 2016

Natively consume JSON data from API sources with SQL 2016 and CLR  Read more...
By Ryan Loftin 2016/06/02 | Source: SQLServerCentral.com | Category: json
Rating: |  Discuss |   Briefcase | 1,910 reads

Stairway to SQLCLR Level 8: Using Visual Studio to work around SSDT

In the final installment of this three-Level series, we use another automation-related feature to do what SSDT doesn't handle natively.  Read more...
By Solomon Rutzky 2016/03/03 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,029 reads

Stairway to SQLCLR Level 7: Development and Security

Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.  Read more...
By Solomon Rutzky 2016/03/02 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,052 reads

Stairway to SQLCLR Level 6: Development Tools Intro

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).  Read more...
By Solomon Rutzky 2016/03/01 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,939 reads

HashBytes Nvarchar(MAX)

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  Read more...
By Simon Hundleby 2015/12/01 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 773 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

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.  Read more...
By Solomon Rutzky 2015/11/27 (first published: 2014/01/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 18,020 reads

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,737 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2015/08/21 (first published: 2013/05/08) | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 27,406 reads

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: SQLServerCentral.com | Category: soundex
Rating: |  Discuss |   Briefcase | 3,242 reads

Retrieving a Binary File from Your Database

In this second article I provide the means to restore a binary file to its original state.   Read more...
By Eric Notheisen 2015/05/28 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,533 reads

Storing a Binary File in a Database

In this article you will see how to convert a file to a binary stream and insert it into SQL Server with SQLCLR.  Read more...
By Eric Notheisen 2015/05/26 | Source: SQLServerCentral.com | Category: binary conversion
Rating: |  Discuss |   Briefcase | 7,398 reads

List CLR Objects in Database

Script lists all the clr objects in the database.  Read more...
By Harsha Majety 2016/08/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,220 reads

Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.  Read more...
By Solomon Rutzky 2015/03/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,442 reads
   Items 1 to 20 of 95    Older >>
 
Tags
stairway series (9)    
t-sql (9)    
c# (6)    
.net (3)    
administration (3)    
assembly (3)    
export (3)    
performance tuning (3)    
sql server 2005 (3)    
string manipulation (3)    
aggregates (2)    
backup and restore (2)    
bcp (2)    
blocked process report (2)    
common language runtime (clr) (2)    
excel (2)    
json (2)    
regular expressions (2)    
soundex (2)    
udf (2)    
.net framework 3.5 (1)    
ado.net (1)    
aes-256 (1)    
async (1)    
barcodes (1)    
binary conversion (1)    
bit masking (1)    
bit masking using c# (1)    
blob storage (1)    
blogs (1)    
bulkcopy (1)    
cryptography (1)    
daitch mokotoff (1)    
data validation (1)    
data warehouse (1)    
delimited (1)    
disaster recovery (dr) (1)    
editorial (1)    
file conversion (1)    
file copy (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
friday poll (1)    
function (1)    
functions (1)    
graph databases (1)    
hash (1)    
hashbytes() (1)    
hashes (1)    
hashing (1)    
hierarchical data (1)    
hostname (1)    
hsa_256 (1)    
hsa_512 (1)    
import (1)    
indexed views (1)    
integration services (ssis) (1)    
maintenance and management (1)    
md5 (1)    
mssql (1)    
multi threaded (1)    
multiple result sets (1)    
neo4j (1)    
nosql (1)    
nysiis (1)    
open source (1)    
parse (1)    
parser (1)    
parsing (1)    
pdf (1)    
phonetics (1)    
pivot (1)    
programming (1)    
qr code (1)    
regex (1)    
render (1)    
search (1)    
sha-2 (1)    
sha-256 (1)    
sha-384 (1)    
sha-512 (1)    
showplan (1)    
sql clr (1)    
sql server (1)    
sql server 2008 (1)    
sql server 2016 (1)    
sql server express (1)    
sql# (1)    
stored procedure (1)    
stored procedures (1)    
stream (1)    
streaming table-valued function (1)    
string (1)    
stvf (1)    
tables (1)    
table-valued function (1)    
test driven development (1)    
test driven development (tdd) (1)    
training (1)    
trustworthy (1)    
uri (1)    
url (1)    
user defined function (udf) (1)    
utility (1)    
visual studio 2010 (1)    
xml (1)    
xp_cmdshell (1)    
xp_fixeddrives (1)