SQL Server Security – SQLpathy

What is Code Signing?

sqlpathy — Mon, 08 Apr 2019 03:20:13 +0000

“Code Signing” is a method which helps validate both authenticity and Integrity! A signed code is authentic as it validates authors identity and ensures that the code has not been altered with a malicious code that can cause damage to the applications.

Static Data Masking

sqlpathy — Fri, 09 Nov 2018 23:56:52 +0000

Static data masking can be used for development, testing, analytics and business reporting, compliance, troubleshooting, and any other scenario where specific data cannot be copied to different environments.

SQL Server Security Basics | The Principle of Least Privilege

sqlpathy — Fri, 09 Feb 2018 05:14:01 +0000

Principle of Least Privilege says that a user be granted only those privileges, which are required to perform their task – nothing more, nothing less.

SQL Server Security Basics | What is Authorization?

sqlpathy — Tue, 16 Jan 2018 06:43:57 +0000

Think of this: Whether a stranger is authorized to enter your house without your permission? Whether you authorize your friend to take your car whenever he wants to go on a drive? Whether a co-employee is authorized to access your confidential information stored with Human Resource department? You might be getting a hang of it… …

Continue reading SQL Server Security Basics | What is Authorization?

SQL Server Security Basics | What is Authentication?

sqlpathy — Fri, 05 Jan 2018 05:27:34 +0000

By definition Authentication means the process of verifying the identity of a user or process. If a user wants to talk to the database, SQL Server asks “Who you are?”, and authenticates you. There are three types of authentication modes available: Windows Authentication SQL Server Authentication Azure Active Directory Windows Authentication This is the default …

Continue reading SQL Server Security Basics | What is Authentication?