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.
2016-03-02
5,871 reads
Solomon Rutzky
- Interests: Computers (duh ;-), religion, sarcasm, chocolate covered raisins
- Website: https://SqlQuantumLeap.com/
- LinkedIn: https://www.linkedin.com/in/srutzky/
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.
2015-11-27 (first published: 2014-01-09)
31,779 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.
2015-03-11
16,321 reads
Stairway to SQLCLR Level 4: Security (EXTERNAL and UNSAFE Assemblies)
In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.
2014-09-10
14,043 reads
Stairway to SQLCLR Level 3: Security (General and SAFE Assemblies)
In the third level of our Stairway to SQLCLR, we look at the various mechanisms in place to help us control Security. In this Level we will focus on SAFE mode and see how secure SQLCLR is by default.
2014-05-28
8,245 reads
Disk Is Cheap! ORLY?
People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.
2013-10-25 (first published: 2010-12-31)
18,089 reads
Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
22,289 reads
Improving Performance of Cross-Partition Queries
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
2010-05-04
7,506 reads
CLR Table-Valued Function Example with Full Streaming (STVF / TVF)
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,673 reads
Streaming Data Into SQL Server 2008 From an Application
Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.
2009-05-28
14,537 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Batu Ceper Telp:08218200203
Telp/Wa 628218200203 Jl. Batu Ceper No.18 A-B, RT.1/RW.2, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Kartini Telp:08218200233
Telp/Wa 628218200233 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, RT.3/RW.2, Kartini,...
Alamat Bank BCA Wisma 46 Telp:08217555651
Telp/Wa 628217555651 Wisma 46 Lantai Dasar, Jln. Jend. Sudirman Kav. 1, RT.5/RW.3, Senayan, Kec....
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers