Your boss has asked you to make changes to an application that will affect an MS SQL Server database, and first needs to know the impact analysis of those changes before any work is performed.
Utilize this simple Find All query to help you find all impacted objects in your database with minimal effort.
Let’s say you need to find all occurrences of “status” in your database. Click to view query syntax that will find all objects (tables, stored procedures, views, functions, triggers, keys, and default values) that include the string “status” somewhere in the name or contents of the object, and provide a count of those occurrences.
Using Simple Powershell Processes Your DBA is receiving complaints about a slow server at random periods throughout the week. How do you assess the environment and troubleshoot performance issues at...