An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
Simplified latitude / longitude in 10 fixed bytes.
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]
Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]