SQL Server HowTos

Help with administrative operations, development and optimization in Microsoft SQL Server

Common SQL Server administration tasks: BCP, compression, the transaction log, CU and GDR updates, table size and monitoring.

BI and analytics features: connect a reporting tool such as SSRS or Power BI to MongoDB through the MongoDB Connector for BI and ODBC.

SQL Server development: fixing collation conflicts after restoring a database onto a server with a different default collation.

SQL Server high availability: Always On availability groups, Basic Availability Groups in Standard edition, timeouts, dbatools and troubleshooting.

SQL Server on Linux: run SQL Server 2022 in a container with Podman, and install KVM on Debian or Ubuntu to virtualize it.

SQL Server maintenance procedures: log backups, backups on an availability group, a full transaction log, and shrinking database files.

Data modeling in SQL Server: choosing the clustered index key, and numbering a column per value of another column in the same table.

SQL Server performance guides: troubleshooting, execution plans, parallelism, blocking, implicit conversions, cardinality, Query Store, RCSI.

SQL Server replication: procedures for managing transactional replication, including adding columns to a replicated table.

Managing the SQL Server system databases: move the tempdb files to another drive and reduce the number of tempdb files.

SQL Server troubleshooting procedures: analyze queries, extract deadlocks, trace execution plans, retrieve error logs, use sp_whoisactive.