Category Archive

SQL Server

Function block with inputs and one output and a gear, representing SQL Server user-defined functions and their performance

SQL Server User-Defined Functions: Scalar vs Table-Valued, Inlining and Performance

The three types of SQL Server user-defined functions, why scalar UDFs slow queries down, what scalar UDF inlining changes, how...

B-tree diagram with a magnifier over one leaf block next to a database, representing SQL Server index design

SQL Server Indexes: Types, Design Rules, Missing and Unused Indexes, and Maintenance

How SQL Server indexes work, which type to use when, how to choose clustered keys and design nonclustered indexes, why...

Standalone server not connected to a directory, with a certificate card, representing SQL Server without Active Directory

Installing SQL Server Without Active Directory: Authentication, Security and Workgroup Availability Groups

How to install and secure SQL Server on a workgroup server: virtual service accounts, Mixed Mode, encryption, no Kerberos, hardening...

SQL Server backup plan with scheduled backups copied to on-site, off-site and cloud storage

How to Build a SQL Server Backup Plan: RPO, RTO, Schedules and Testing

How to build a SQL Server backup plan that meets your RPO and RTO: backup types and schedules, Always On,...

Server with a checklist clipboard and stethoscope, representing a SQL Server health check

SQL Server Health Check: What It Should Cover (12-Area Checklist)

The 12 areas a SQL Server health check should cover, from backups and CHECKDB to configuration, security, storage and HA,...

Clock, job cards and an envelope, representing SQL Server Agent job scheduling and notifications

SQL Server Agent Best Practices: Job Owners, Notifications, History and Scheduling

Practices that make SQL Server Agent reliable: non-personal job owners, failure notifications and the fail-safe operator, job history retention, overlapping...

SQL Server simple recovery model log reuse compared with a full recovery model log chain and point-in-time restore

SQL Server Simple Recovery Model: When to Use It and When Not To

What the SQL Server simple recovery model really does, how it differs from full recovery, when it's the right choice,...

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

Prev 1 … 4 5 6 7 8 … 10 Next