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 small reserved side door and a key, representing the SQL Server Dedicated Admin Connection

SQL Server Dedicated Admin Connection (DAC): How to Connect When the Server Won’t Respond

How the SQL Server Dedicated Admin Connection lets you get into a hung server: enabling remote DAC in advance, connecting...

Database with a timeline of stored query cards, representing SQL Server Query Store

SQL Server Query Store: How to Enable It, Which Settings to Use and How to Fix Plan Regressions

How to enable SQL Server Query Store with production settings, catch it falling into READ_ONLY, find plan regressions, force a...

Server with a dial pushed to the limit and a warning sign, representing the SQL Server priority boost setting

SQL Server Priority Boost: Why You Shouldn’t Enable It and How to Turn It Off

What the deprecated SQL Server priority boost option does, why Microsoft says it isn't needed for performance, how to check...

Memory module cluttered with small cards next to a neat stack, representing plan cache bloat and optimize for ad hoc workloads

Optimize for Ad Hoc Workloads: How to Stop Plan Cache Bloat in SQL Server

How to measure single-use plan bloat in the SQL Server plan cache, what optimize for ad hoc workloads does, when...

February 9, 2022

Control panel with toggle switches, one set differently, representing SQL Server SET options on objects

SQL Server Objects Created with the Wrong SET Options: Msg 1934, Filtered Indexes and ARITHABORT

Why procedures created with QUOTED_IDENTIFIER or ANSI_NULLS off break filtered indexes and indexed views with Msg 1934, how to find...

February 2, 2022

Oversized SQL Server transaction log made of many virtual log files overflowing next to a small database, with a warning gauge

SQL Server Transaction Log Too Big? Causes, Diagnosis and Safe Fixes

Why a SQL Server transaction log grows out of control, how to diagnose the real reason with log_reuse_wait_desc, and how...

January 19, 2022

Clock, server and a task list, representing Windows Task Scheduler jobs affecting SQL Server

Review Windows Task Scheduler: Hidden Jobs Behind Periodic SQL Server Slowdowns

How scheduled tasks on a database server cause slowdowns at the same time every day, how to list them with...

January 12, 2022

Puzzle pieces with one outdated piece set apart, representing deprecated SQL Server features

How to Find Deprecated Features in Use on a SQL Server Instance

How to see which deprecated SQL Server features are in use with performance counters, find the code behind them with...

December 29, 2021

Database, hourglass and a broken arrow to a disk, representing SQL Server delayed durability and log flush

SQL Server Delayed Durability: Faster Commits, Real Data Loss Risk

How SQL Server delayed durability returns commits before the log is hardened, how to enable it, when the data loss...

December 22, 2021

Processor splitting work into parallel lanes, representing SQL Server MAXDOP and cost threshold for parallelism

SQL Server MAXDOP and Cost Threshold for Parallelism: Recommended Settings

How MAXDOP and cost threshold for parallelism work together, Microsoft's MAXDOP recommendations by NUMA layout, how to choose a cost...

December 15, 2021

SQL Server database file being shrunk with scattered fragmented data pages next to a planned, well-organized storage block

SQL Server Shrink Best Practices: When to Shrink and When Not To

When shrinking a SQL Server database or file is justified, why it shouldn't be routine maintenance, how to shrink data...

December 1, 2021

Database with loose detached files, a magnifying glass and an archive box representing orphaned SQL Server data files

Offline Databases and Orphaned Data Files in SQL Server: How to Find and Remove Them Safely

How offline databases and orphaned .mdf/.ldf files accumulate in SQL Server, why they are a disk and data security risk,...

November 24, 2021

Prev 1 … 4 5 6 7 8 9 Next