Activity overview
Latest activity by TimG2
I attended Andy Mallon's talk on SSMS shortcuts but came away with learning about David Klee's tip on causing SQL Server to blue screen. This is great for testing failure in the Availablity Group to see if failover works correctly. Thanks for this great tip. https://www.davidklee.net/2015/11/30/summon-blue-screens-of-death-for-testing-purposes-only-of-course/ / comments
I attended Andy Mallon's talk on SSMS shortcuts but came away with learning about David Klee's tip on causing SQL Server to blue screen. This is great for testing failure in the Availablity Group t...
I ran into the same issue after moving my RedGate database. I ran the following commands on my database named RedGateMonitor. ALTER database RedGateMonitor SET SINGLE_USER WITH ROLLBACK immediate; SELECT name,snapshot_isolation_state,snapshot_isolation_state_desc,is_read_committed_snapshot_on from sys.databases ; --- ALTER DATABASE RedGateMonitor SET READ_COMMITTED_SNAPSHOT ON ALTER DATABASE RedGateMonitor SET ALLOW_SNAPSHOT_ISOLATION ON -- SELECT
name,snapshot_isolation_state,snapshot_isolation_state_desc,is_read_committed_snapshot_on from sys.databases ; ALTER database RedGateMonitor SET multi_USER I then had to stop the SQL Monitor Base Monitor service (MonitorBaseDeploymentService) in Services.msc on my monitoring server and restart it to reestablish the connection. / comments
I ran into the same issue after moving my RedGate database. I ran the following commands on my database named RedGateMonitor.ALTER database RedGateMonitor SET SINGLE_USER WITH ROLLBACK immediate;S...