sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun
MVP Open Day South Asia at Microsoft IDC Hyderabad was fun and educational. I met fellow MVPs and product group experts, and my family came along too.
SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business
MVP Open Day South Asia 2010 at Microsoft IDC Hyderabad was fun and educational: meeting product team members, old friends and experts from across the region.
SQL SERVER – Question – How to Convert Hex to Decimal
An inline function converting Hex to Decimal was slowing a client query. I tuned it, and now I ask readers to share the scripts they use for this.
SQL SERVER – Location of Resource Database in SQL Server Editions
The Resource database contains SQL Server system objects. I use version-specific guidance to locate its files and plan recovery.
SQL SERVER – Several Readers Questions and Readers Answers
A collection of readers questions from this blog, with answers from other readers, like how to script table rows as INSERT statements and track changes.
SQLAuthority News – Leadership Quotes and Inspiration
Leadership is not the same as management. The quotes I shared in a recent leadership talk, from Nelson Mandela, Peter Drucker and others, which the team loved.