Tags » SQL Security

SQL SERVER - How to Connect Using NT AUTHORITY\SYSTEM Account?

Sometimes it is needed to connect to SQL Server using System account. Don’t literally ask me if this is a valid scenario in first place. Someone just pinged to say – they want to do it. 298 more words

SQL Authority

SQL SERVER - Someone was trying to hack my SQL Server Logins in Azure!

When I started to work with SQL Server on Azure VMs, I was completely excited because now the need to build local VMs has become super easy. 485 more words

SQL Authority

SQL SERVER 2016 - New T-SQL Functions - COMPRESS and DECOMPRESS

With every release of SQL Server, Microsoft has been adding enhancements to the product. Earlier I have written below blogs talking about new features/enhancements.

SQL Server – 2016 – New Feature: Dynamic Data Masking… 457 more words

SQL Authority

SQL SERVER - Creating a Database Administrator Group Using User-Defined Server Roles

When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question. 1,079 more words

SQL Authority

SQL SERVER - Three Simple Guidelines for System Maintenance - Notes from the Field #098

: This is a 98th episode of Notes from the Field series. Maintenance of the database is a very critical activity and I have always seen DBA taking it very seriously. 780 more words

SQL Authority

Is 'sysadmin' role required for the SQL Server and SQL Server Agent Service Accounts?

Need to know if ‘sysadmin’ role is required for the startup account for SQL Server Service and the SQL Server Agent Service; And if so, what is the reason behind the requirement etc. 281 more words

SQL Server

SQL SERVER - Security Considerations for Contained Databases

I have written a number of blogs around contained databases in the past which you can search. In today’s blog we will talk about security considerations when working with contained databases. 494 more words

SQL Authority