Aryasoft Blog

Insights, guides and updates on database management, data platforms, cloud architecture, analytics and technology.

Mikro Modernization Oracle SQL Server Upgrades

All Posts

Explore all insights from the Aryasoft blog.

Two identical cards with one set aside, representing finding and deleting duplicate records in SQL Server

Find and Delete Duplicate Records in SQL Server Safely

How to find duplicate rows in SQL Server, keep the right one with ROW_NUMBER, move child records, delete in batches...

Server with a wrench and a warning sign, representing common SQL Server performance tuning mistakes

12 Common SQL Server Performance Tuning Mistakes and What to Do Instead

The SQL Server performance tuning mistakes we see most often, from restarting first and clearing caches to MAXDOP 1, blind...

SQL Server restore sequence of full, differential and log backups on a timeline rebuilding a database

How to Restore a SQL Server Database: SSMS, T-SQL and Point-in-Time Guide

A complete guide to restoring SQL Server databases: SSMS and T-SQL steps, full, differential and log restore sequences, point-in-time recovery,...

Laptop and server connected by a broken cable, representing SQL Server connection troubleshooting

Can’t Connect to SQL Server? Fix Error 26, 40, 53 and 18456 Step by Step

Why SQL Server connections fail and how to fix them layer by layer: services, instance names, TCP/IP, firewall ports, login...

SQL Server deadlock: two locked databases waiting on each other in a closed loop

SQL Server Deadlocks: How to Find, Analyze and Prevent Them

Learn what a SQL Server deadlock (error 1205) is, how it differs from blocking, how to capture and read deadlock...

February 17, 2021

Blocks of different shapes and sizes arranged in a row, representing SQL Server data types

SQL Server Data Types: How to Choose the Right Type and Avoid Implicit Conversions

How to choose SQL Server data types for integers, money, text, dates and more, why float is wrong for money,...

Prev 1 … 7 8 9