Category Archive

Databases

Database with a license document, a stack of coins and a price tag representing SQL Server licensing

SQL Server 2025 Licensing Guide: Editions, Core vs. CAL, Pricing and Cost Optimization

How SQL Server 2025 is licensed: editions and limits, Per Core vs. Server + CAL, worked core-count examples, and the...

September 17, 2026

SQL Server Automatic Index Compaction: Is This the End of Index Maintenance?

SQL Server Automatic Index Compaction: Is This the End of Index Maintenance?

SQL Server index maintenance has followed the same pattern for two decades: scheduled rebuild and reorganize jobs, shrinking maintenance windows,...

September 17, 2026

SQL Server Modernization: A Practical Guide to Upgrading, Migrating and Optimizing SQL Server

SQL Server Modernization: A Practical Guide to Upgrading, Migrating and Optimizing SQL Server

SQL Server modernization can involve upgrading, consolidating, migrating, replatforming or improving your existing architecture. Learn how to choose the right...

August 12, 2026

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,...

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...

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,...

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 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...

Prev 1 2 3 4 5 Next