INSERT EXEC statement cannot be nested, the Simple Solution
Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.
2022-08-19
21,637 reads
SQL CLR
How to Enable SQL Server CLR Integration using T-SQL
In this tip we look at how to enable SQL Server Common Runtime Language aka CLR using T-SQL commands.
2019-07-24
Getting The Most Out of SQL Server 2005 UDTs and UDAs
The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
2007-09-18
5,466 reads
SQLCLR Security and Designing for Reuse
SQL Server's CREATE ASSEMBLY statement lets you catalog code with one of three predefined security buckets. But under the covers, there are actually two distinct security models at play: Code Access Security and Host Protection, and you need to understand both.
2007-08-02
1,670 reads
Using CLR Integration in SQL 05 for Writing Stored Procedures
With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.
2007-07-11
3,137 reads
Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
Working with large objects, BLOBs in SQL Server, has always been a little tedious. The forums are filled with questions on this topic. New authro Yoel Martinez brings us a more advanced looked at BLOBs in SQL Server 2005 with code and a technique for compressing large amounts of data to save space.
2008-01-11 (first published: 2007-01-30)
8,599 reads
CLR Inside Out
This article is meant to explore these architectural issues from the bottom up, and aims to guide you through this new world. In the long run, new programming models are likely to appear that will abstract away a lot of the challenges you will encounter.
2006-12-15
2,929 reads
Creating a generic audit trigger with SQL 2005 CLR
Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger.
2006-08-02
18,918 reads
Security in the CLR World Inside SQL Server
s running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use.
2006-06-15
2,774 reads
Geocoding with SQL Server 2005
Mapping services have become quite popular on the Internet and with many applications, but in order to use these, you need to map an address to a latitude and longtitude. Corey Bunch brings us a CLR example of how you can do this.
2006-05-01
18,909 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
Convert common Separated number to # table
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Things to be considered before implementing database auditing
Hi All, As part of security compliance, we are told to audit DML &...
The Need for DevSecOps
Comments posted to this topic are about the item The Need for DevSecOps
Ask SSC