Posts tagged with "sql-server"

A walkthrough for building a two-node SQL Server 2025 Availability Group with automatic failover, from standing up the AD forest to proving failover works.

How to fix the 'Cannot connect to WMI provider' error in SQL Server Configuration Manager by recompiling the MOF file with mofcomp.

Learn three ways to split a large SQL Server backup file for migration: native backup striping, PowerShell, and 7-Zip.

Your queries are prisoners. They're both holding what the other needs, and neither will let go.

Step-by-step guide to bulk copying a date-filtered SQL Server table to another server using bcp format files and native mode.

A practical benchmark of month-as-columns vs month-as-rows using SQL Server IO, time, plans, and storage.

Taking a database with one MDF and several NDFs, and gradually moving all data back into a single data file using `EMPTYFILE`.

Install sp_WhoIsActive across your SQL Server instances with a single dbatools command instead of running the script by hand.

A quick reference for installing the dbatools PowerShell module, covering the PowerShell Gallery install and offline options.

What the Monty Hall problem taught me about questioning assumptions, conditional probability, and diagnosing SQL Server performance.

A practical SQL Server benchmark showing how returning more columns changes payload size and affects throughput.

Standardize autogrowth across every database with one script, and see why consistent filegrowth controls VLF fragmentation and performance.

Shrink a SQL Server transaction log with DBCC SHRINKFILE, understand the risks, and apply log management practices that prevent regrowth.

Migrate an SSRS ReportServer database by backup and restore, covering encryption keys, logins, service accounts, and portal validation.

SQL Server does not run natively on macOS, but Docker makes it straightforward. Here is how to get an instance running on a Mac.

Categorize SQL Server 2022 wait stats into actionable groups with sys.dm_os_wait_stats and GROUPING SETS to find bottlenecks fast.

A practical guide to selecting and configuring the Max Degree of Parallelism (MAXDOP) setting in SQL Server for optimal parallel query performance.

Six date-filtering patterns benchmarked, showing how non-sargable expressions force scans and inflate logical reads, plus what to use instead.

Query catalog views with a CTE over index key and included columns to find exact duplicates, then generate DROP statements to reclaim space.

Use SET STATISTICS IO and execution plans to spot key lookups, then build covering indexes with INCLUDE to cut the extra logical reads.

Locate the newest cumulative update for your SQL Server version, prepare backups and downtime, and apply the CU safely to your instances.

Download the official SQL Server 2022 installer, choose between Developer and Express editions, and run the Basic or Custom setup wizard.

Find the latest SSMS installer, run it as administrator, and know what to expect from the wizard so you can start managing instances.

Script out configs, logins, and jobs, rebuild system databases with setup.exe to fix a collation mismatch, then restore everything after.