DBA 3/10

top of page

Jun 12, 202310 min read

Don't Be a Sitting Duck: The Top 15 SQL Server Security Myths

Jun 4, 20231 min read

How to Fix the "Login Failed for User NT AUTHORITY\ANONYMOUS LOGON" Error with Linked Servers

May 31, 20231 min read

SQL Server - An Intelligent Database

May 29, 20236 min read

High VLF Counts Got You Down? Here's How to Keep Them Low and Performance High

May 24, 20233 min read

From Chaos to Clarity: Transform Your Data with Power Query in Power BI

May 23, 20232 min read

Azure SQL Cost Optimization

May 20, 20233 min read

Delayed Durability During Shutdown

May 15, 20231 min read

The Asynchronous Ledger Trick for Lightning-Fast SQL Server OLTP

May 3, 20232 min read

CETAS in SQL Server 2022

Apr 23, 20232 min read

Should your DB and App projects be in the same Source Control Repository?

Apr 3, 20232 min read

Resolved: Database Stuck in Single-User Mode

Mar 17, 20231 min read

My Session in SQLBits 2023

Mar 14, 20236 min read

The Pitfalls of Using System-Named Constraints in SQL Server

Feb 23, 20238 min read

Drop All Redundant Indexes In Every Database All At Once

Dec 26, 20222 min read

Use your hints in the right way

Dec 25, 20224 min read

Bad habits: unnecessary counting

Dec 21, 20224 min read

SQL Server Query Store and how to enable it

Dec 19, 20223 min read

What is the internal database version, and how does it affect our work?

Dec 5, 20223 min read

How to downgrade SQL Server edition

Oct 16, 20223 min read

Link Power BI to Azure Synapse Analytics

bottom of page