2014-11-13
2,105 reads
Encryption
Granular or Cell Level Encryption in SQL Server
Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).
2014-07-04
6,349 reads
Using Encrypted Backups in SQL Server 2014
This article details encrypted backups and how they are implemented in SQL Server 2014.
2014-05-15
5,084 reads
Administering Database Master Keys in SQL Server
A short piece that gives you the basics of how to administer the database master keys that form the basis for encryption inside of your databases.
2014-05-12
12,823 reads
2014-04-22
1,951 reads
2014-04-15
1,635 reads
How much overhead does encryption add to a SQL Server query
If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.
2014-04-09
4,230 reads
2014-04-08
1,599 reads
Understanding the importance of key length with the SQL Server asymmetric encryption algorithms
K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?
2013-08-12
3,228 reads
2013-07-26
1,706 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers