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,934 reads
2018-12-18
3,959 reads
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-06-25 (first published: 2018-06-05)
1,747 reads
Microsoft has released a version of SQL Server 2017 for Linux.
2018-03-26
2,304 reads
In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.
2018-02-02
3,045 reads
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
2018-01-02
3,457 reads
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
2017-12-25
3,228 reads
You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.
2017-12-19
3,471 reads
Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.
2017-12-08
3,696 reads
Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.
2017-10-23
5,498 reads
By Steve Jones
I delivered a talk at the ConFoo conference. I’ve never been to this live,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
Is there any way to do that? I need to list that kind of...
Hi everyone, can anyone tell me the process of how to create multiple pdf's...
Hello I have a package that logs using Configure SSIS Logs: Logging It logs...
Ask SSC