Development & Integration
New
12/11/2026 LINQ to SQL Full Text Search: Use CONTAINS From C
LINQ to SQL does not expose full-text search; Contains() compiles to LIKE. Here is the ExecuteQuery + CONTAINS workaround with T-SQL and C#.
Practical SQL Server notes and troubleshooting
Execution plans, indexes, the transaction log, SQL Agent jobs and wait stats: tested T-SQL for DBAs and developers, with the version it was run on.
New
12/11/2026 Administration & Monitoring
Database Mirroring Network Compression: What SQL Server Documents and How to Verify It
Database mirroring sends log records to the mirror with no documented compression switch. See which DMVs verify traffic and session state.
New
11/11/2026 Administration & Monitoring
Event Notifications Blocked Process SQL Server: End-to-End Setup
Use Event Notifications to capture blocked process reports in SQL Server. T-SQL setup for the threshold, Service Broker queue, and reading the XML.
New
11/11/2026 Performance & Internals
What Is a Page Split in SQL Server?
A page split happens when an 8 KB data page has no room for a row. Learn how it fragments SQL Server indexes, how to detect it, and when to worry.