Migrate databases from SQL Server to SQL Managed Instance

Fixing "Login failed for user" error in SQL Server

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

SQL Server 2017 Build List

A list of builds for SQL Server 2017.

Logshipping to SQL Server on Linux

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

SQL Server 2017 for Linux First Impressions

Microsoft has released a version of SQL Server 2017 for Linux.

Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3

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.

Create Size-based Backups for SQL Server 2017

Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.

Cascading Update and Delete for SQL Server 2017 Temporal Tables

Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.

Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant

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.

How Much Data Has Changed Since Your Last Full Backup

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.