Data Protection

SQLServerCentral Editorial

Critical Data and Insomnia

  • Editorial

Most evenings I spend some time soaking in the tub and reading articles/watching videos on InfoSec, Data Protection and AI.  It may sound like a terrible way to spend some time, but I always find it educational and I’m in shock by the lack of concern around data security, and yet….I’m not.  For decades, the […]

(2)

You rated this post out of 5. Change rating

2025-08-07

130 reads

External Article

Introduction to SQL Server Security — Part 3

  • Article

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.

2019-03-14

2,987 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes

By Site Owners

Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

By Site Owners

Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...

Storytelling with Data: Let's Practice!

By Site Owners

Comments posted to this topic are about the item Storytelling with Data: Let's Practice!

Visit the forum

Question of the Day

The Decoded Value

In SQL Server 2025, what is returned from this code:

DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000)));
SELECT BASE64_DECODE(@encoded) 

See possible answers