Year archive

Posts from 2020

Blog posts

December 28, 2020 FAQs about the dissolution of PASS
December 8, 2020 Closing Time
October 6, 2020 Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2)
October 5, 2020 Multi-subnet availability group, without MultiSubnetFailover support (Part 1)
October 4, 2020 Microsoft Azure hack for social justice
June 26, 2020 What's important in a code of conduct?
June 24, 2020 Tech Community Equality Index
June 23, 2020 Hi, I'm Andy. My pronouns are he/him.
June 9, 2020 Racism is our problem to solve
June 8, 2020 Pride is a riot
May 12, 2020 Find the SQL Server service account with sys.dm_server_services
May 6, 2020 Making non-SARGable queries seek, without changing the query
May 4, 2020 Replication latency when an Availability Group replica is offline
April 30, 2020 Thirsty Thursday - A five-bottle bar for eleven cocktails (and non-alcoholic alternatives)
April 28, 2020 Stop trying to shrink tempdb files
April 21, 2020 Fixing tempdb: Growing, shrinking, and removing data files
April 16, 2020 Thirsty Thursday - Essential bar equipment
April 14, 2020 Should I install SSMS on a server running SQL Server?
April 9, 2020 Redgate Streamed
March 20, 2020 When STRING_SPLIT() falls short
March 4, 2020 Joining the Friends of Redgate program 🎉

Stack Exchange answers

November 27, 2020 Stack Exchange answer: Job management: How to get the next running date by querying MSDB
October 19, 2020 Stack Exchange answer: log send queue size and redo queue size in AG
October 18, 2020 Stack Exchange answer: Is my VM hyperthreaded?
October 18, 2020 Stack Exchange answer: Always On Synchronous Commit Mode With Large Delays
October 14, 2020 Stack Exchange answer: Replication of only updates and inserts
October 6, 2020 Stack Exchange answer: sp_update_schedule says @schedule_id does not exist
September 25, 2020 Stack Exchange answer: Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?
September 23, 2020 Stack Exchange answer: SQL Server 2019 Database stuck In Recovery state after restart
August 15, 2020 Stack Exchange answer: How to dig deeper into ASYNC_NETWORK_IO waits
June 15, 2020 Stack Exchange answer: Remove/suppress dashes from "Results to Text" output in SSMS?
May 21, 2020 Stack Exchange answer: Why the instance name of SQL Server Express is changing?
May 18, 2020 Stack Exchange answer: Recursive CTE in SQL Server to count blocking sessions
March 30, 2020 Stack Exchange answer: Can changing database owner affect permissions or role memberships?
March 1, 2020 Stack Exchange answer: MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online
February 23, 2020 Stack Exchange answer: How to store real-time data to database
February 12, 2020 Stack Exchange answer: Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?
January 16, 2020 Stack Exchange answer: Fastest way to shrink LOB data in SQL Server
January 9, 2020 Stack Exchange answer: Job waiting on CXCONSUMER