Member for 12 years, 10 months
Last seen more than a month ago
I was on the SQL team for almost 9 nine years - wrote a bunch of DBCC commands (e.g. INDEXDEFRAG, SHOWCONTIG, CHECKDB/repair), ran the Access Methods development team for SQL Server 2005, and ended up being responsible for the entire Core Storage Engine for SQL 2008. Occasionally I have to resort to "I'm sorry, you are incorrect, the code does not do that", which I hate, as in https://imgur.com/gallery/8t74s.
I'm an expert on Storage Engine internals, wait statistics, HA, maintenance, and disaster recovery. I teach this stuff internally for Microsoft and at conferences/clients around the world.
The answer usually starts with 'it depends'! :-)