Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Blogs

Async stats update causing blocking

By

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...

Level Up Your SQL Skills: The Best Intermediate to Advanced Courses

By

In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

Read the latest Blogs

Forums

Working with SQL Server in Visual Studio Code

By Daniel Calbimonte

Comments posted to this topic are about the item Working with SQL Server in...

Five Years and Counting

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Five Years and Counting

A Lack of Memory Grant Feedback Persistence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Lack of Memory Grant...

Visit the forum

Question of the Day

A Lack of Memory Grant Feedback Persistence

SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)

See possible answers