SQLServer

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 […]

2020-11-24

3,274 reads

Block user objects from being created in a master database

  • Article

Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]

5 (7)

2020-11-10

3,123 reads

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)

2020-06-30

4,147 reads

Blogs

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)

By

Welcome to a new year, and a new look at what I’ve learned in...

Azure SQL vCore vs DTU

By

If you are building database solutions in Azure , using Azure SQL Database then...

Synapse Analytics Spark Example 2 - ROW_NUMBER()

By

The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...

Read the latest Blogs

Forums

XML Vs Non-XML

By IT researcher

I am using SQL Server 2008 R2. While using XML data type and  XQuery...

Staging or UAT Environment

By VastSQL

Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...

Transaction was deadlocked on lock resources with another process

By L_Goyal

I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers