Security Archives - {coding}Sight https://codingsight.com/category/database-administration/security/ Blog for SQL Server DBAs and Developers Mon, 10 Jul 2023 07:52:54 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png Security Archives - {coding}Sight https://codingsight.com/category/database-administration/security/ 32 32 Reset the Root Password of MySQL on Windows https://codingsight.com/reset-root-password-of-mysql-on-windows/ Tue, 31 Aug 2021 10:20:21 +0000 http://codingsight.com/?p=16332 When we install MySQL on Windows, we usually specify the password of the root user. This helps keep the MySQL Server secured. Suppose you joined a new organization, and the management of that organization plan to migrate some MySQL databases to SQL Server. To perform this, you need the credential of the root user, but …

The post Reset the Root Password of MySQL on Windows appeared first on {coding}Sight.

]]> Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases https://codingsight.com/understanding-sql-server-security-function-has_permis_by_name-and-its-use-cases/ Mon, 30 Aug 2021 07:45:44 +0000 http://codingsight.com/?p=16429 There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what principal, securables, and permissions are. According to Microsoft Documentation, Securables in SQL Server context are specific resources to which the SQL Server Database Engine authorization system controls access. They are divided into …

The post Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases appeared first on {coding}Sight.

]]> Locking in SQL Server: Detailed Overview https://codingsight.com/manage-transaction-concurrency-using-locks-in-sql-server/ Tue, 17 Aug 2021 09:07:54 +0000 http://codingsight.com/?p=16207 In a multi-user environment, it is essential to maintain truncation concurrency. These locks are in-memory structures of 96 bytes in size. Their role is to maintain data integrity, consistency, concurrency control for each transaction. SQL Server follows the ACID test for each transaction. To ensure ACID properties, SQL Server imposes different kinds of locks on …

The post Locking in SQL Server: Detailed Overview appeared first on {coding}Sight.

]]> Understanding SQL Server Lockdown to Secure Database Environment https://codingsight.com/understanding-sql-server-lockdown-to-secure-database-environment/ Fri, 13 Aug 2021 08:27:58 +0000 http://codingsight.com/?p=16088 Security is the main concern these days in every sector. Database Security is also a major worry for any customer. SQL Server is designed to secure all your data stored in the databases but sometimes we fail to apply the right set of configurations and leave a hole in our system. Hackers and unauthorized aliens …

The post Understanding SQL Server Lockdown to Secure Database Environment appeared first on {coding}Sight.

]]> Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel https://codingsight.com/connecting-a-bastion-server-to-a-postgresql-server-via-secure-shell-tunnel/ Wed, 09 Jun 2021 07:38:46 +0000 http://codingsight.com/?p=14505 PostgreSQL is a well-known relational database management system that boasts a secure environment for developers and users. But as remote work continues to be a part of every business’s new normal, IT professionals face a new set of challenges when it comes to managing the security and accessibility of their servers. Using a bastion server …

The post Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel appeared first on {coding}Sight.

]]> Deploying a Certificate for Encrypted Connection SQL Server https://codingsight.com/deploying-a-certificate-for-encrypted-connection-sql-server/ Wed, 16 Sep 2020 13:02:11 +0000 https://codingsight.com/?p=9958 Introduction Last year we got a requirement to ensure encrypted connections to our SQL Server instances. Before, we did not think it was necessary – all our instances were accessed by application services internally. Still, secure connections protect the instance and clients from attacks as man-in-the middles, so we did it. Connection encryption differs from …

The post Deploying a Certificate for Encrypted Connection SQL Server appeared first on {coding}Sight.

]]> Using Alerts and Operators in SQL Server https://codingsight.com/using-alerts-and-operators-in-sql-server/ Sat, 04 Jan 2020 00:06:31 +0000 https://codingsight.com/?p=8324 Introduction With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still available. They are the key SQL Server Agent features that are related to anything in SQL Server automation.  Their roles are clear: Alerts, when configured, let database administrators know when a …

The post Using Alerts and Operators in SQL Server appeared first on {coding}Sight.

]]> Understanding SQL Server Always Encrypted https://codingsight.com/understanding-sql-server-always-encrypted/ Wed, 10 Jul 2019 22:26:04 +0000 https://codingsight.com/?p=7399 Security is one of the most important requirements for a data-driven system. Encryption is one of the ways to secure the data. Wikipedia defines encryption as: “Encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot.” In …

The post Understanding SQL Server Always Encrypted appeared first on {coding}Sight.

]]> In-depth Exploration of Row Level Security https://codingsight.com/in-depth-exploration-of-row-level-security/ Tue, 12 Feb 2019 15:59:31 +0000 https://codingsight.com/?p=6243 Introduction Organizations are becoming more and more concerned about how to reduce the cost of licensing database solutions using consolidation. Some consolidation can be achieved in SQL Server simply by taking advantage of the existing one-to-many relationship between instances and databases. However, there are cases where the solution demands that data is consolidated into one …

The post In-depth Exploration of Row Level Security appeared first on {coding}Sight.

]]> Introduction to Row-Level Security in SQL Server https://codingsight.com/introduction-to-row-level-security-in-sql-server/ Fri, 01 Feb 2019 09:56:02 +0000 https://codingsight.com/?p=6177 Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default lowest level of security for a database. In other words, a user could be restricted to access a table as a whole. However, in some cases we need users to have access to a table, but not to specific rows …

The post Introduction to Row-Level Security in SQL Server appeared first on {coding}Sight.

]]>