The Curious Engineer

All blogs / Databases

Jay's Blog

learn.microsoft.com/en-us/archive/blogs/askjay

[coding, debugging, and troubleshooting with Microsoft Technologies]

DatabasesWindows internalsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
36 from 3 Oct 2009 to 8 Oct 2012
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/askjay/feed.xml

2012 8

  1. Orphaned Locks - Idle Session - and XACT_ABORT
  2. Sequence Objects in SQL 2012 and SQL 2008
  3. If a worker thread doesn’t yield, is it guaranteed to run?
  4. Do waiting or suspended tasks tie up a worker thread?
  5. Finding Missing Dependencies
  6. Loading data with foreign keys
  7. Need to find the Database Version? Last Log Backup? Last DBCC execution? Ummm….
  8. Default Trace and System Health

2011 14

  1. How can I get a list of installed SQL Server instances?
  2. Searching through the SQL Server Errorlogs
  3. Have you checked out Denali? CTP 3 is here…
  4. Troubleshooting Slow Disk I/O in SQL Server
  5. Using Windows 2008 R2 as a workstation (and a lab)
  6. Proper I/O Capacity Planning and Configuration Resources for SQL Server
  7. Why is using “Instant File Initialization” on my SQL Server a potential security issue?
  8. Required rights for SQL Server service account
  9. Finding which queries were executing from a SQL Memory Dump – revisited
  10. Uninstalling a SQL Server Service Pack
  11. Using DBCC PAGE
  12. How does SQL Server perform deletes in my table?
  13. Why do we need trace flag 3604 for DBCC statements?
  14. What is a slot array?

2010 11

  1. How do I find what queries were executing in a SQL memory dump?
  2. Catching who dropped SQL Server logins
  3. The parameters of xp_readerrorlog
  4. How do I track this in my Stored Procedure? (Using a custom trace event)
  5. Cool Windows 7 Feature…
  6. Creating a custom performance monitor counter for SQL Server
  7. How do I set a breakpoint in a CLR Stored Procedure already deployed and running on a live SQL Server and debug is using Visual Studio?
  8. How can I create a dump of SQL Server?
  9. What do I need to know to be good at debugging?
  10. Basic Debugging Concepts and Setup - Part 2 (Basic & Common Commands)
  11. Windows 7 God Mode

2009 3

  1. Basic Debugging Concepts and Setup
  2. Hello World
  3. Test entry