SQL server other database dependency find using sql_expression_dependencies Nested level dependency To find link server dependency. Reference https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-expression-dependencies-transact-sql?view=sql-server-ver15
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type. Different options you see in the collation name. CS – case-sensitiveAI – accent-insensitiveKS – kana …
database_scoped_configurations
SQL Server The Extended Events architecture enables users to collect as much or as little data as is necessary to troubleshoot or identify a performance problem. Extended Events is configurable, and it scales very well. Benefits Extended Events Extended Events is a lightweight performance monitoring system that uses minimal performance resources. Extended Events provides two …
How to use extended events to catch all error in SQL Server Read More »
A service principal name (SPN) is a unique identifier of a service instance. SPNs are used by Kerberos authentication to associate a service instance with a service logon account. This allows a client application to request that the service authenticate an account even if the client does not have the account name. If you install multiple instances …
After installation of SQL Server If you need to change collation, you can do using the below commands. This code may harmful for your environment Please test on separate environment.
A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step. …
SQL Server performance problem this script is important to check what query is running on the servers.
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-services-transact-sql?view=sql-server-ver15 Other related Commands
Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc… Logfile type: 1 or NULL = error log, 2 = SQL Agent log Search string 1: String one you want to search for Search string 2: String two you want to search for to …
