2021-09-08
706 reads
2021-09-08
706 reads
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
13,088 reads
2022-03-31 (first published: 2018-12-18)
5,785 reads
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-07-09 (first published: 2018-06-05)
1,906 reads
Microsoft has released a version of SQL Server 2017 for Linux.
2018-03-26
2,399 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
Resumes have been on my mind a lot recently. I’ve been thinking that I...
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
Most of the time when I talk about or demo Extended Events, I spend...
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
hi Friends, Requirement: Create a query or Power BI report/dashboard that displays users, their...
hi Friends, Here is the example Scenario: An SSRS Paginated Report has 2 data...