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.

ID card, key and locks, representing SQL Server authentication and authorization

SQL Server Authentication vs Authorization: Logins, Users, Roles and Least Privilege

The difference between authentication and authorization in SQL Server: Windows, SQL and Entra ID logins, logins vs users, orphaned users,...

Database with its label being replaced, representing renaming a SQL Server database

How to Rename a SQL Server Database Safely (and Why You Can’t Access It Afterwards)

How to rename a SQL Server database with ALTER DATABASE MODIFY NAME, fix Msg 5030 and login error 4064, rename...

Corrupted SQL Server storage being repaired with clean pages restored from backup

SQL Server Database Corruption: Causes, Warning Signs and How to Recover Without Losing Data

What causes SQL Server database corruption, the 823, 824 and 825 warning signs to watch for, and how to recover...

SQL Server error log with highlighted error lines under a magnifying glass next to a database

SQL Server Error Log: Where to Find It, How to Read It and What to Watch For

Where the SQL Server error log lives, how to read and search it with SSMS and T-SQL, which messages need...

Database with a stopwatch, a filtering funnel and a magnifying glass representing SQL Server Extended Events

SQL Server Extended Events: A Practical Guide to Sessions, Targets and Analysis

How Extended Events works, how session settings affect performance, which target to use when, and ready-to-use sessions for long-running queries,...

Function block with inputs and one output and a gear, representing SQL Server user-defined functions and their performance

SQL Server User-Defined Functions: Scalar vs Table-Valued, Inlining and Performance

The three types of SQL Server user-defined functions, why scalar UDFs slow queries down, what scalar UDF inlining changes, how...

B-tree diagram with a magnifier over one leaf block next to a database, representing SQL Server index design

SQL Server Indexes: Types, Design Rules, Missing and Unused Indexes, and Maintenance

How SQL Server indexes work, which type to use when, how to choose clustered keys and design nonclustered indexes, why...

Standalone server not connected to a directory, with a certificate card, representing SQL Server without Active Directory

Installing SQL Server Without Active Directory: Authentication, Security and Workgroup Availability Groups

How to install and secure SQL Server on a workgroup server: virtual service accounts, Mixed Mode, encryption, no Kerberos, hardening...

SQL Server backup plan with scheduled backups copied to on-site, off-site and cloud storage

How to Build a SQL Server Backup Plan: RPO, RTO, Schedules and Testing

How to build a SQL Server backup plan that meets your RPO and RTO: backup types and schedules, Always On,...

Server with a checklist clipboard and stethoscope, representing a SQL Server health check

SQL Server Health Check: What It Should Cover (12-Area Checklist)

The 12 areas a SQL Server health check should cover, from backups and CHECKDB to configuration, security, storage and HA,...

Clock, job cards and an envelope, representing SQL Server Agent job scheduling and notifications

SQL Server Agent Best Practices: Job Owners, Notifications, History and Scheduling

Practices that make SQL Server Agent reliable: non-personal job owners, failure notifications and the fail-safe operator, job history retention, overlapping...

SQL Server simple recovery model log reuse compared with a full recovery model log chain and point-in-time restore

SQL Server Simple Recovery Model: When to Use It and When Not To

What the SQL Server simple recovery model really does, how it differs from full recovery, when it's the right choice,...

Prev 1 … 3 4 5 6 7 … 9 Next