SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment benjf.com.blog@benjf.com, 2016-12-02 When a High Availability (HA) environment failed over, on the node that became Secondary, the… Continue Reading
TSQL – Make Excel Link In Output benjf.com.blog@benjf.com, 2016-08-04 Here is a situation I just came across (boiled down and simplified). An end user… Continue Reading
TSQL – Get All Queries Currently Running benjf.com.blog@benjf.com, 2016-08-04 This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in… Continue Reading
Powershell PowerShell – Update All SQL Services To Restart On Failure benjf.com.blog@benjf.com, 2016-08-04 PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528 Continue Reading
PowerShell – Create And Write Out To Log File benjf.com.blog@benjf.com, 2016-08-04 Creating and writing to output file in PowerShell. https://gist.github.com/benf101/379e8040393a24771af81360ee0111ab Continue Reading
Generate Red Gate MultiScript .dat File benjf.com.blog@benjf.com, 2016-07-14 This is a PowerShell script that puts out the XML required to update your Red… Continue Reading
T-SQL – Get Listener Name on AlwaysOn Cluster benjf.com.blog@benjf.com, 2016-05-25 When using AlwaysOn, you must connect using your listener name, not your node name. If you connect with the node name, it will only work until there is a failover, which would defeat the purpose of your High Availability setup, right? Continue Reading
SQL Server – Timestamp Column benjf.com.blog@benjf.com, 2016-05-02 While this seems like a simple thing to do, I recently discovered so many ways not to do it (also known as failing) that I just had to document this one. Continue Reading
PowerShell – Get All SQL Instances On Server benjf.com.blog@benjf.com, 2016-04-27 This script will return all SQL instances running on a server or list of servers…. Continue Reading
PowerShell – Get “Logon As” Information From Remote (or local) Server benjf.com.blog@benjf.com, 2016-04-20 This was made possible by the Scripting Guy. I have boiled it down to the… Continue Reading