In a followup, this article includes discussion of more advanced features of using stored procedures.

Introduction to SQL Server Security — Part 3

by Additional Articles

SimpleTalk

Data Protection

SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.

Badly Encrypted Databases

by Steve Jones

SQLServerCentral.com

Editorial

Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.

Using Client Tools - Level 4 of the Stairway to SQL Server on Linux

by Danilo Dominici

SQLServerCentral.com

In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.

SQL Server Referential Integrity Across Databases Using Triggers

by Additional Articles

MSSQLTips.com

SQL Server

In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.

Dealing with Technical Debt

by Steve Jones

SQLServerCentral.com

Editorial

Technical debt can cripple software development, much like financial debt hurts individuals and organizations. Steve wants to know if you measure your debt today.

Isolation Levels in SQL Server

by Sucharita Das

SQLServerCentral.com

SQL Server

Details discussion on the different isolation levels available in SQL Server

A Re-Introduction to HIPAA and SOX

by Additional Articles

Redgate

SQL Provision

SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.

Using Azure Resource Manager Templates To Provision Azure SQL Databases

by Additional Articles

Database Journal

Azure

Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.