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.

Block columns of different heights with a ruler, representing measuring table sizes in SQL Server

Find Table Sizes in SQL Server: Rows, Data, Index and Unused Space

Queries to find table sizes in SQL Server split into data, index and unused space, the largest tables across all...

Three tables linked by key connections, representing SQL Server foreign key relationships

List Foreign Key Relationships in SQL Server: Columns, Rules and Untrusted Constraints

Queries to list every foreign key relationship in SQL Server with columns and cascade rules, find and fix untrusted constraints,...

Database table connected to several objects under a magnifying glass, representing finding stored procedures that use a table

Find Stored Procedures That Use a Table in SQL Server: Dependency Queries That Actually Work

How to find every stored procedure, view, function and trigger that uses a table or column in SQL Server, including...

Table block with one column pulled out, representing safely dropping unused columns in SQL Server

Safely Drop Unused Columns in SQL Server: A Script That Handles Dependencies

A two-stage method to retire unused SQL Server columns, and a query that generates the drop script with default, check...

Cubes passing one by one through a gate next to the same cubes grouped into one block, representing row-by-row cursors versus set-based SQL

SQL Server Cursors: Syntax, Options, Performance and Set-Based Alternatives

How SQL Server cursors work, which options to use, why they're slow, four cursor patterns rewritten as set-based queries, how...

Columns of blocks with the top blocks raised, representing top N rows per group in SQL Server

Top N Rows per Group in SQL Server: ROW_NUMBER, DENSE_RANK and CROSS APPLY

Three ways to get the top N rows per group in SQL Server, how ROW_NUMBER, RANK and DENSE_RANK handle ties,...

Calendar and a highlighted range on a timeline, representing SARGable date filters in SQL Server

Date Math in the WHERE Clause: Writing SARGable Date Filters in SQL Server

Why YEAR(date) = 2026 and similar date predicates can't use an index, how to rewrite them as SARGable ranges, the...

Primary database copying data to a smaller reporting database with a report sheet and a price tag

The Real Cost of Adding a SQL Server Reporting Server: Licensing, Architecture and Alternatives

What a separate SQL Server reporting server really costs and when it pays off: licensing for each method, network isolation,...

Asynchronous database mirroring vs availability groups: a primary and a DR database with a quorum witness between them

Async Database Mirroring vs. Async Availability Groups: The Quorum Trap in DR Designs

Compare asynchronous database mirroring with asynchronous availability groups for SQL Server DR, learn why quorum can take production offline, and...

Document tree with a few tagged branches next to a database, representing SQL Server selective XML indexes

Selective XML Indexes in SQL Server: Fast Queries on Large XML Columns

How selective XML indexes in SQL Server index only the XML paths you query, how they compare with primary XML...

One server hosting three stacked databases, representing multiple SQL Server instances on one machine

Should You Install Multiple SQL Server Instances on One Server? Pros, Cons and Alternatives

The real benefits and risks of stacking several SQL Server instances on one server, how to divide memory and CPU...

Four database cylinders around a hidden one, representing SQL Server system databases

SQL Server System Databases: master, model, msdb, tempdb and Resource

What each SQL Server system database holds, how to back up master, model and msdb, why model's FULL recovery bloats...

Prev 1 2 3 4 5 … 9 Next