PostgreSQL Static Data Masking with DataVeil
Learn how to secure sensitive information with PostgreSQL data masking in development environments while still utilizing realistic data.
Security
Valuable SQL Server Security tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
Preparing SQL Servers and Data for Quantum Computing
Quantum computing, when fully realized, will have a significant impact on encryption and the data stored in SQL Server databases.
Meeting HIPAA Regulations with Agility and Automation
Learn about HIPAA regulations faced by a US based healthcare organization and how they protected the data with SQL Server data masking.
Restrict User Query Access in SQL Server
Learn how to restrict access in SQL Server yet still give users access to what they need to ensure ad hoc queries don't impact performance.
Capital on Tap Meeting Regulatory Compliance and Explosive Growth with DataVeil Data Masking
Learn how a rapidly growing FinTech meets regulatory compliance with DataVeil data masking for their SQL Server systems.
Easily Create Non-Sensitive Copies of Production Databases
Learn how to obfuscate sensitive data and personally identifiable information (PII), all while ensuring the data remains useful for testing and analysis. Explore how DataVeil can help you mitigate risks, ensure compliance, and maximize the quality of your data.
Audit SQL Server Extended Stored Procedures Usage
In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.
SQL Server Database and Server Roles for Security and Permissions
Learn about the differences between server roles and database roles in SQL Server and how these could be used to control security and permissions.
How to Secure SQL Server – End to End Security
Learn a valuable framework to secure your SQL Servers. Starting with the install and walking through surface area, permissions, backups, encryption, and concluding with decommissioning, we''ll cover every area you''ll need to consider for your SQL Server environment. The session goal is to ensure you can properly harden and secure the SQL Servers in your organization.
Dynamic Data Masking in SQL Server for Sensitive Data Protection
Learn how to use dynamic data masking in SQL Server and how to give different users different data access in these easy-to-follow examples.
Grant SQL Server Permissions to a Folder for Backups or Database Files
In this article, we look at the steps to grant SQL Server access to new folders for backups or database files.
SQL Server Static Data Masking with DataVeil
Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.
SQL Server Database Security – Logins and Users
In this article, we look at how to create a SQL Server login along with an associated database user using the GUI and T-SQL code.
Find All Securable Objects in SQL Server and Permissions
Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.
Data Masking in SQL Server vs Oracle
In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle.
SQL Login Details with SQL LOGINPROPERTY Function
In this article we look at the SQL Server function LOGINPROPERTY to retrieve various settings for any SQL Server login.
SQL ALTER Authorization Examples
Learn how to transfer ownership of databases and database objects in SQL Server using alter authorization with several examples.
SQL Server Login and User Permissions with fn_my_permissions
In this article we look at how to list SQL Server permissions for a login or a user using the system function fn_my_permissions.
Kerberos Configuration Manager for SQL Server SPN Validation
Learn how to manage and troubleshoot Kerberos authentication for SQL Server using the Kerberos Configuration Manager.
Encryption and Decryption of Passwords in SQL Server with PowerShell
In this article we look at how to securely store passwords in text files that could be used for SQL Server authentication.
SQL Server Windows Authentication with Users and Groups
In this article we cover how to use Windows Authentication for SQL Server access and how to setup permissions using groups, users and roles.
Implementing SQL Server Security with Stored Procedures and Views
Learn about how ownership chaining allows you to limit permissions on specific database objects yet give users access through other objects such as views and stored procedures.
Resource Based Kerberos Constrained Delegation
In this article we look at how use Kerberos for authentication to a SQL instance for cross-domain authentication.
Understanding SQL Server Ownership Chaining
In this article we look at an example of SQL Server ownership chaining to better understand how permissions are passed through objects.