Kerberos, named after the mythical three-headed dog guarding the gates of the underworld, is a security protocol that enables secure authentication in network environments. It offers a significant improvement over older protocols like NTLM by allowing the delegation of credentials across multiple machines, making it ideal for distributed computing environments.
Category: Connectivity
Ensuring Smooth SSRS Subscriptions in an Always On Availability Group
SQL Server Reporting Services (SSRS) is a powerful tool for managing and delivering reports in an enterprise environment. When configuring SSRS within a SQL Server Always On Availability Group, it’s essential to take specific steps to ensure that SSRS subscriptions continue to function properly during failovers. This blog outlines the key actions required to maintain seamless SSRS operations in such a setup.
The Application Role: Implementing Application Roles with SQL Server
A straightforward guide to implementing application roles in SQL Server, focusing on enhancing security and managing database permissions for applications. This guide covers the creation, activation, and management of application roles, ensuring applications have the necessary access while minimizing the risk of unauthorized actions. Learn about key concepts such as role activation, permission assignment, and reverting security contexts. Follow best practices to effectively use application roles and improve the overall security and manageability of your SQL Server databases.
Exploring READ_WRITE_ROUTING_URL in SQL Server AlwaysOn Availability Groups
This blog post explores the READ_WRITE_ROUTING_URL parameter in SQL Server AlwaysOn Availability Groups. It explains how this feature helps optimize read/write traffic and improve performance by routing connections based on their intent (read-write vs. read-only). The post also includes a practical example demonstrating connection routing behavior and concludes with additional considerations for security and monitoring.
The DNN Listener: Guide to Distributed Network Names (DNNs) for SQL Server VMs
This guide explores Distributed Network Names (DNNs) for managing AlwaysOn Availability Groups on Azure SQL Server VMs. It explains how DNNs differ from Virtual Network Names (VNNs), highlights the benefits of DNNs (simplified configuration, enhanced flexibility, improved availability), and provides a step-by-step walkthrough for setting up a DNN listener using PowerShell.
Navigating the Changes in SQL Server 2022: A Guide to Server Alias Configuration
If you’re embarking on a fresh installation of SQL Server 2022, you might be in for a surprise. Gone are the familiar days of the SQL Server Native Client being a core component of SQL Server installations. This blog post will discuss the recent changes in SQL Server 2022 and how to navigate server alias configuration in this new landscape.