SQLServer

SQLServerCentral Article

How to Add a New Shared Disk to a WSFC as a SQL Resource

  • Article

Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.

5 (1)

You rated this post out of 5. Change rating

2024-09-16

1,184 reads

SQLServerCentral Article

A Step by Step Guide to the Availability Group (AG) Listener

  • Article

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

5 (1)

You rated this post out of 5. Change rating

2021-05-17

8,694 reads

SQLServerCentral Article

Fixing "Login failed for user" error in SQL Server

  • Article

In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]

You rated this post out of 5. Change rating

2020-11-24

50,577 reads

Blogs

Prepping for Certification, Part 1 of ?

By

I thought it would be good to put my thoughts down on how to...

How to Avoid Knowledge Stagnation

By

You want the short answer? Well, the only antidote to knowledge stagnation is probably...

Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe

By

It always starts the same way. You open your laptop on a Monday morning,...

Read the latest Blogs

Forums

just finished a deep dive into snowflake

By stan

Sorry, but you do not have permission to view this content.

Database File Growth Report Script

By Deepam Ghosh

Comments posted to this topic are about the item Database File Growth Report Script

SQL Server authentication vs. Trusted connection

By Rod at work

I maintain an application written years ago, where the database is on a Windows...

Visit the forum

Question of the Day

The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable

See possible answers