Category: Security

Starting with the release of SentryOne Version 19.1.1, the sysadmin role is no longer a requirement for the monitoring service account.
Glenn Berry talks about a few of the security features in SQL Server 2017 and reminds us to always test and validate the performance impact.
December 17, 2018 | SQLPerformance.com | Security, SQL Server 2017 0
Microsoft has pulled several patches for older versions of SQL Server. If you need TLS 1.2 support and can't move to a formally supported version, your recourse is to contact Microsoft support.
November 17, 2018 | Aaron Bertrand | Security 50
Recently I have been exploring Dynamic Data Masking, looking at ways that it can be used and I thought I would share my thoughts with you.
Paul White discusses the internals of SQL Server's WITH ENCRYPTION clause, and explains why it is not as safe as you might think.
May 20, 2016 | SQLPerformance.com | Security 0
Aaron Bertrand shares his slides and demos from his two SQL Intersection.
John Martin starts his security nuggets series, explaining why you should use encrypted connections for SQL Server if you take system security seriously.
March 16, 2016 | John Martin | Security, SQL Server 1
Stronger Security Via Always Encrypted in SQL Server 2016.
Aaron Bertrand posts a couple of follow-ups to his...
August 17, 2015 | SQLPerformance.com | Security 0
For this month's T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) talks about a few of the limitations of a new SQL Server 2016 feature, Always Encrypted.
August 11, 2015 | Aaron Bertrand | Security, T-SQL Tuesday 11
There is a fix to address a remote code execution vulnerability for all supported SQL Server versions. @AaronBertrand shows which build you should install.
July 20, 2015 | Aaron Bertrand | Security, SQL Server Builds 14
Aaron Bertrand tries to raise awareness of a significant security issue when creating or altering logins using a password hash. Please vote!
April 20, 2015 | Aaron Bertrand | Security 9
Rick Pittser shares the way security has been envisioned and implemented from the start in our cloud-based service, cloud.sentryone.com.
March 27, 2015 | Rick Pittser | SQL Sentry, Cloud, Security 2
Contributing to T-SQL Tuesday #58, Aaron Bertrand discusses a few of the reasons people give out the sa password, and what you should do in those cases instead.
September 9, 2014 | Aaron Bertrand | Security, SQL Server, T-SQL Tuesday 0

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More