Other References Manufacturer information inside SQL server Himanshu Patel SQL Server Consultant developer & Administrator – How to use extended events to catch all errors in SQL Server SQL Socket & Core information Get IO warning from log Get TempDB files count How to find SQL Server Cluster information
Here I am trying to explain how to find SQL server cluster information. Machine Name: – Windows computer name on which the server instance is running. For a clustered instance, an instance of SQL Server running on a virtual server on Microsoft Cluster Service, it returns the name of the virtual server.Instance Name: – Name …
Here I am going to provide sample query which help to identify database file are not using by SQL Server.
Adds a certificate to a database in SQL Server. Requires CREATE CERTIFICATE permission on the database. Only Windows logins, SQL Server logins, and application roles can own certificates. Groups and roles cannot own certificates. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15 https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/
Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network. Database Mail has two configuration objects: The database configuration objects provide a way for you to configure the settings that Database mail should use when sending …
Here i am trying to find missing indexes on foreign key relation tables. Other References:
Forced manual fail-over with data loss (2 step) To force failover with data loss, connect to the SQL Server instance that hosts the target secondary replica and then run the following command: When the previous primary replica recovers, it will also assume the primary role. To ensure that the previous primary replica transitions into a …
Be careful with this stored procedure! I usually use in the Test/Dev environments. TSQL Procedures
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 …
