cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
3,035

Entra Authentication for Replication in Arc-enabled SQL Server 2022 CU 12 in General Availability

talawren on Nov 02 2023 12:45 PM
Announcing the General Availability of Microsoft Entra authentication for replication in SQL Server 2022 CU 12.
4,129

SQL Server 2022 Common Criteria EAL4 Certification

Wolfgang-Peter on Oct 13 2023 11:20 AM
In light of Microsoft's commitment to optimize the security and assurance of its products and services, we are excited t...
1,946

Delegating permission management using Roles vs WITH GRANT OPTION

AndreasWolter on Aug 22 2023 03:31 PM
Comparing 2 methods for delegating permission management with T-SQL
1,571

Troubleshooting external data and access policies in Azure SQL and SQL Server

AndreasWolter on Nov 23 2022 03:52 PM
How you can analyze external policies from SQL
1,721

Revamped SQL Permission system for Principle of Least Privilege and external policies – internals

AndreasWolter on Sep 27 2022 02:46 PM
A view under the hood of the revamped SQL Server permission system
13.9K

New granular permissions for SQL Server 2022 and Azure SQL to improve adherence with PoLP

AndreasWolter on Aug 23 2022 11:30 AM
The new granular permissions in SQL Server 2022 explained.
4,772

Common Criteria EAL4 Certification for SQL19

Wolfgang-Peter on Jun 09 2022 09:26 AM
Microsoft SQL Server 2019 has been awarded Common Criteria Evaluation Assurance Level 4 certification.
2,305

New server roles for SQL Server 2022 and Azure SQL Database in Public Preview

AndreasWolter on May 25 2022 08:32 AM
Preview Announcement of new server roles for SQL Server 2022 for Database Management at scale without admin-access
3,146

Guidance on Apache Log4j Remote Code Execution Vulnerability

AndreasWolter on Dec 17 2021 06:31 PM
Microsoft published guidance regarding Log4j 2 vulnerability for customers using Azure Data services
3,223

Intro into security principles in the context of database systems

AndreasWolter on Feb 04 2021 03:54 AM
The intro-article to the series “Separation of Duties and other Security Principles in the context of Database Systems”
1,567

Logging Schema-changes in a Database using DDL Trigger

AndreasWolter on Dec 02 2020 12:30 PM
How to use DDL Triggers to record Database-changes in a table.
5,365

Common Criteria Certification for SQL Server 2019

Wolfgang-Peter on Oct 26 2020 12:06 PM
In this blog post we'll provide information on the most recent Common Criteria certification for SQL Server.
7,448

Intro - SQL Server Transparent Data Encryption and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:14 PM
Part - Intro of a 4-part blog series: Setting up Transparent Data Encryption (TDE) and EKM (Extensible Key Management) t...
3,890

Part 1 - SQL Server TDE and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:14 PM
Install the SQL Server Connector for Microsoft Azure Key Vault This is Part:1 of a 4-part blog series: This blog in the ...
3,155

Part 2 (PowerShell) - SQL Server TDE and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:14 PM
Set up an Azure Active Directory Service Principal and Azure Key Vault using PowerShellThis is Part: PS2 (PowerShell) of...
3,230

Part 2 (Portal) - SQL Server TDE and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:13 PM
Set up an Azure Active Directory service principal using the Azure PortalThis is Part: AP2 (Azure Portal) of a 4-part bl...
3,436

Part 3 (Portal) - SQL Server TDE and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:13 PM
Create a Key Vault using the Azure PortalThis is Part: AP3 (Azure Portal) of a 4-part blog series: This blog in the seri...
7,951

Part 4 - SQL Server TDE and Extensible Key Management Using Azure Key Vault

Adrian_Rupp on May 29 2020 02:13 PM
Configure SQL ServerThis is Part: 4 (SQL) of a 4-part blog series: After setting up Azure Active Directory and registeri...
4,547

Using Query Store with least privileges instead of db_owner to achieve Separation of Duties

AndreasWolter on Aug 07 2019 06:59 AM
Here we are showing how access to the Query Store can be delegated without granting high privileges.
4,219

Best Practices for Moving Data Encrypted with Always Encrypted

SQL-Server-Team on Mar 23 2019 02:13 PM
First published on MSDN on Jan 07, 2016 With the introduction of Always Encrypted, Microsoft’s SQL platform (SQL Server ...
2,119

Best Practices for Moving Data Encrypted with Always Encrypted

SQL-Server-Team on Mar 23 2019 02:12 PM
First published on MSDN on Jan 07, 2016 With the introduction of Always Encrypted, Microsoft’s SQL platform (SQL Server ...
441

Using SQL Server Integration Services (SSIS) with Always Encrypted

Jakub Szymaszek on Mar 23 2019 02:09 PM
First published on MSDN on Dec 18, 2015 We would like share a couple of links to two articles, just published on SQL Ser...
2,890

Using Hardware Security Modules with Always Encrypted

Jakub Szymaszek on Mar 23 2019 02:06 PM
First published on MSDN on Nov 16, 2015 Using Hardware Security Modules with Always EncryptedIn the examples from the pr...
9,263

Tutorial: Row-Level Security and Entity Framework

SQL-Server-Team on Mar 23 2019 02:05 PM
First published on MSDN on Nov 04, 2015 In response to a common customer question, we've published a short tutorial show...
5,847

SSMS Encryption Wizard - Enabling Always Encrypted in a Few Easy Steps

Jakub Szymaszek on Mar 23 2019 02:02 PM
First published on MSDN on Oct 31, 2015 As we explained in the previous articles, Always Encrypted is a client-side encr...
575

Oil & Gas Security Demo with SQL Server 2016

SQL-Server-Team on Mar 23 2019 02:00 PM
First published on MSDN on Oct 29, 2015 At our security session today at PASS Summit 2015, we were extremely fortunate t...

Latest Comments

erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 3 on Apr 15 2024 09:28 AM
@Vyacheslav_Kovalyov so sorry for not getting back to you on that - I believe it's possible from a technical standpoint. My request would be that you create it on the feedback site so we can understand wider interest (and then determine priority). SQL · Community (azure.com)
1 Likes
Vyacheslav_Kovalyov
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 3 on Apr 15 2024 09:21 AM
Hi @erinstellato . What about command line? Would be possible to add options (Encryption and Trust Server Certificate) to command line arguments? Thank you
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 3 on Apr 15 2024 08:47 AM
Hi @phispher73 - completely understand this request, we have an Idea logged for it here: SSMS - Registered Servers and CMS do not persist auth settings for encryption · Community (azure.com) Please upvote! Appreciate the feedback on the improved performance.
0 Likes
phispher73
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 3 on Apr 12 2024 08:23 AM
@erinstellato Just a quick recommendation / hope-to-see: When updating your CMS entries for servers (i.e. enabling 'Trusted' on each one), it would be nice if that data would save back to the msdb database where the CMS data is stored so it would persist between SSMS reloads. It would make this a lo...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 12 2024 05:35 AM
@DavidYorkshire This is what was shared with me by another team, but I am happy to check with them again.
0 Likes