SQL Server – Disabled User Account Overrides AD Group Authorization! Writer #1, 2016-12-28 Just a quick note on a scenario I ran into, and what I did to… Continue Reading
SQL Server Maintenance Plan Backups Failing On Secondary Replica in High Availability Environment Writer #1, 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 Writer #1, 2016-08-042024-08-31 Here is a situation I just came across (boiled down and simplified). An end user… Continue Reading
TSQL – Get All Queries Currently Running Writer #1, 2016-08-042024-08-31 This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in… Continue Reading
T-SQL – Get Listener Name on AlwaysOn Cluster Writer #1, 2016-05-252024-08-31 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 Writer #1, 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
T-SQL – Get Currently Running Jobs With Duration Writer #1, 2016-04-14 Query to get all currently running jobs with their run duration in seconds. Source: http://www.sanssql.com/2013/08/t-sql-query-to-find-currently-running.html… Continue Reading
Restore All Databases With Most Recent Backup Writer #1, 2016-04-14 This is a bit of a scary task. Someone tells you about 87 databases that… Continue Reading
SQL Server – Database Stuck In Single User Mode Writer #1, 2016-03-29 If you've painted yourself into the single_user corner, here is how you can get out. Continue Reading
SQL Server – Cluster Queries Writer #1, 2016-03-24 Get some clustered facts about your server. Continue Reading