--- title: Throwback Review: Using the Original SQL Server Debugger description: A satirical, nostalgic look back at the long-removed T-SQL Debugger that once shipped with SQL Server, paired with Profiler and a physical jog/shuttle hardware... canonical: https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Throwback Review: Using the Original SQL Server Debugger | daily.dev og:description: A satirical, nostalgic look back at the long-removed T-SQL Debugger that once shipped with SQL Server, paired with Profiler and a physical jog/shuttle hardware... og:url: https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x og:image: https://api.daily.dev/og/posts/CJfG5vA2X.png og:image:alt: Throwback Review: Using the Original SQL Server Debugger og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Throwback Review: Using the Original SQL Server Debugger **[Brent Ozar](https://daily.dev/sources/brentozar)** · 6 min read · 0 upvotes · 0 comments ## Summary A satirical, nostalgic look back at the long-removed T-SQL Debugger that once shipped with SQL Server, paired with Profiler and a physical jog/shuttle hardware console attached via PS/2 ports. The piece humorously walks through how the debugger worked (Mark In/Mark Out, play/pause/rewind controls, variable inspection) and explains, tongue-in-cheek, why it disappeared: databases moved into locked data centers, the debugger caused server-wide freezes via the PREEMPTIVE_DEBUG wait type, and Azure SQL DB never got the system-level permissions needed to support it. It closes with a jab at Microsoft adding ads to SSMS and at pricey AI hardware gadgets. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What is the PREEMPTIVE_DEBUG wait type in SQL Server? PREEMPTIVE_DEBUG is a SQL Server wait type that occurs when the query debugger is active and code execution is paused or stepped through, causing other sessions on the server to be frozen while waiting. This made using the debugger in production risky, since debugging one query could make the entire server unresponsive to everyone else. _Anyone chasing odd wait types in production can compare notes on daily.dev alongside other SQL Server troubleshooting stories._ ### Why doesn't SQL Server Management Studio support a query debugger for Azure SQL Database? The debugger required system-level permissions that were never implemented in Azure SQL Database, so rather than build that capability into Azure SQL DB, Microsoft removed debugging support from SQL Server Management Studio entirely. The tradeoff let Management Studio work consistently across Azure SQL Database, Fabric, and CosmosDB instead of maintaining separate tooling paths. _Developers weighing SSMS feature gaps across Azure SQL products can track these tradeoffs on daily.dev._ ## Similar posts on daily.dev - [A better way to work with SQL Server](https://daily.dev/posts/a-better-way-to-work-with-sql-server-thprghiwd) · InfoWorld · 3 upvotes · 0 comments - [Stop Hunting Bugs: Meet the New Visual Studio Debugger Agent](https://daily.dev/posts/stop-hunting-bugs-meet-the-new-visual-studio-debugger-agent-mldmdbzqm) · Visual Studio Blog · 1 upvotes · 0 comments - [build locally, ship to Azure](https://daily.dev/posts/build-locally-ship-to-azure-qvnuc6kv7) · DevBlogs · 0 upvotes · 0 comments - [Updated: T-SQL Analyzer live analysis now in SSMS and Visual Studio](https://daily.dev/posts/updated-t-sql-analyzer-live-analysis-now-in-ssms-and-visual-studio-wmm37dku6) · We Are .NET · 4 upvotes · 1 comments --- Tags: [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server) [View this post on daily.dev](https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Throwback Review: Using the Original SQL Server Debugger","url":"https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x"},"datePublished":"2026-08-18T13:19:12.965Z","dateModified":"2026-09-14T09:09:27.365Z","description":"A satirical, nostalgic look back at the long-removed T-SQL Debugger that once shipped with SQL Server, paired with Profiler and a physical jog/shuttle hardware...","image":"https://i0.wp.com/www.brentozar.com/wp-content/uploads/2026/08/IMG_0519.gif?resize=640%2C481&ssl=1","thumbnailUrl":"https://i0.wp.com/www.brentozar.com/wp-content/uploads/2026/08/IMG_0519.gif?resize=640%2C481&ssl=1","isAccessibleForFree":true,"articleSection":"Brent Ozar","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Brent Ozar","logo":"https://media.daily.dev/image/upload/s--uHhajUhc--/c_limit,w_256/f_auto,q_auto/v1780213426/logos/brentozar?_a=BAMAMiWQ0","url":"https://daily.dev/sources/brentozar"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"microsoft-sql-server","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Brent Ozar","item":"https://daily.dev/sources/brentozar"},{"@type":"ListItem","position":3,"name":"Throwback Review: Using the Original SQL Server Debugger"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/throwback-review-using-the-original-sql-server-debugger-cjfg5va2x#faq","mainEntity":[{"@type":"Question","name":"What is the PREEMPTIVE_DEBUG wait type in SQL Server?","acceptedAnswer":{"@type":"Answer","text":"PREEMPTIVE_DEBUG is a SQL Server wait type that occurs when the query debugger is active and code execution is paused or stepped through, causing other sessions on the server to be frozen while waiting. This made using the debugger in production risky, since debugging one query could make the entire server unresponsive to everyone else. Anyone chasing odd wait types in production can compare notes on daily.dev alongside other SQL Server troubleshooting stories."}},{"@type":"Question","name":"Why doesn't SQL Server Management Studio support a query debugger for Azure SQL Database?","acceptedAnswer":{"@type":"Answer","text":"The debugger required system-level permissions that were never implemented in Azure SQL Database, so rather than build that capability into Azure SQL DB, Microsoft removed debugging support from SQL Server Management Studio entirely. The tradeoff let Management Studio work consistently across Azure SQL Database, Fabric, and CosmosDB instead of maintaining separate tooling paths. Developers weighing SSMS feature gaps across Azure SQL products can track these tradeoffs on daily.dev."}}]} ```