While modifying Solid Quality’s DBA Bootcamp for SQL Server 2008, I begin researching object dependencies. In the past we all knew that verifying the dependencies of objects in SQL Server basically meant you had to search through syscomments (SQL Server 2000) or sys.sql_modules (SQL Server 2005) and look for the existence of your object in the code of existing objects. This was because the dependencies that are stored in either sysdepends (SQL Server 2000) or sys.sql_dependencies (SQL Server 2005) are not accurate, see the video (http://www.jumpstarttv.com/Media.aspx?vid=336) for the reason why.
Things have changed in SQL Server 2008. Dependency information is always accurate and now you can depend on what the sys.sql_dependencies tells you. This is due to how dependency information is obtained and stored, once again see the video (http://www.jumpstarttv.com/Media.aspx?vid=336).
I hope you like the video(http://www.jumpstarttv.com/Media.aspx?vid=336. Be sure to let me know your comments and I plan on producing more of these short videos and need some help on determining the final format of them.
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups - November 28, 2013
- Custom Master Pages not available from Performance Point Dashboard Designer - June 19, 2012
- An introduction to Power View (code name “Crescent”) in SQL Server 2012 (code name “Denali”) - May 2, 2012