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.

Server with a settings panel and a wrench, representing SQL Server configuration best practices

SQL Server Configuration Best Practices: The Windows, Instance and Database Settings to Check

A checklist for reviewing an existing SQL Server: power plan and unused services, instance settings with recommended values, and risky...

SQL Server maintenance plan tasks scheduled around a database: backups, integrity checks, statistics and indexes

SQL Server Maintenance Plans: What to Include, What to Avoid and How to Schedule Them

Which tasks a SQL Server maintenance plan should include, which ones to avoid such as shrink, how to handle index...

SQL Server database with a shield, padlock and key representing security hardening

SQL Server Security Hardening: A Practical Checklist for Production Servers

A practical SQL Server hardening checklist: who should hold sysadmin, how to handle sa and service accounts, which features to...

DBCC CHECKDB integrity scan finding a corrupted page in a SQL Server database

DBCC CHECKDB in SQL Server: What It Checks, How Often to Run It and What to Do When It Finds Errors

What DBCC CHECKDB checks, how to run it without blocking production, how often to run it, and what to do,...

SQL Server backup chain of full, differential and transaction log backups

SQL Server Backup Types Explained: Full, Differential, Log, Tail-Log and Copy-Only

Full, differential, transaction log, tail-log, copy-only and filegroup backups explained: what each contains, how they depend on each other and...

SQL Server linked server: two servers joined by a locked chain, representing a secure linked server connection

SQL Server Linked Server: Setup, Security, Queries and the SQL Server 2025 Change

How to create and secure a SQL Server linked server: login mapping, Kerberos delegation, OPENQUERY versus four-part names, version notes...

Two files with crossed mappings to a database, representing SQL Server error 5161 file id mismatch

SQL Server Error 5161: An Unexpected File ID Was Encountered and How to Fix It

What SQL Server error 5161 means, why it appears after TempDB or file path changes, and how to fix it...

Server with an old and a new name tag, representing fixing @@SERVERNAME after a rename

Fix @@SERVERNAME After Renaming a SQL Server Host

Why @@SERVERNAME keeps the old name after a Windows rename or VM clone, how to fix it with sp_dropserver and...

Many cubes flowing through a funnel into one block with a bar chart, representing SQL Server aggregate functions

SQL Server Aggregate Functions: COUNT, SUM, AVG, STRING_AGG and the NULL Traps

SQL Server aggregate functions explained: COUNT(*) vs COUNT(1) vs COUNT(column), SUM and AVG traps, NULL handling, GROUP BY and HAVING,...

Keyboard and terminal window, representing the sqlcmd command-line tool for SQL Server

sqlcmd: Running Scripts, Automating Tasks and Practical Tips for SQL Server’s Command-Line Tool

How to use sqlcmd for SQL Server automation: the two versions, key parameters such as -b and -v, scripting variables,...

A structured table block next to loose document cards, representing relational databases versus NoSQL

Relational Database vs NoSQL: Differences and When to Use Each

The real differences between relational databases and NoSQL, the main NoSQL types, when each makes sense, and how SQL Server...

Database with an open audit logbook, a clock and a shield representing SQL Server Audit

SQL Server Audit: A Production Guide to Setup, Targets and Monitoring

How to run SQL Server Audit properly in production: choosing a target and failure behavior, what to audit, the Always...

Prev 1 2 3 4 5 6 … 9 Next