Narayana Raghavendra

Code Stored in Files Instead of Stored Procedures

This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)

2003-10-24

8,082 reads

Blogs

How Many Bytes Per Character in SQL Server: a Completely Complete Guide

By

A Completely Complete Guide to how many bytes are used to represent characters in...

Power BI Monthly Digest – November 2019

By

In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson...

Data Masker Reads Column Classificiations

By

One of the newer features in Data Masker for SQL Server is the ability...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Logins while migration.

By sizal0234

Hi This is when you are migrating from old server to new server. Is...

VM and SQL core license

By sqlfriend

I am using SQL server 2017 standand edition. We installed on a virtual machine....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers