I am a SQL Server DBA, a Microsoft Data Platform MVP, and a carbaholic. he/him
Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2)
Multi-subnet availability group, without MultiSubnetFailover support
Microsoft Azure hack for social justice
What’s important in a code of conduct?
Find the SQL Server service account with sys.dm_server_services
Making non-SARGable queries seek, without changing the query
Replication latency when an Availability Group replica is offline
Stop trying to shrink tempdb files
Fixing tempdb: Growing, shrinking, and removing data files
Should I install SSMS on a server running SQL Server?
3 min read
Joining the Friends of Redgate program 🎉
What the heck is the dbcreator role?
Testing as another user…without their password
I hate sp_estimate_data_compression_savings
Changing a column from int to bigint, without downtime
How to create date buckets in T-SQL
How does a database RESTORE affect plan cache?
What the heck is Accelerated Database Recovery?
What the heck is the SQL Server Version Store?
Recovery of database is 0% complete (approximately 1000000 seconds remain)
When to put a non-clustered index on your clustering key
What the heck is downtime, anyway?
Configuring the distribution database in an Availability Group
Code to purge data based on creation date
Purging data with batched deletes
Want to connect with Andy Mallon?
Create an account to connect with Andy Mallon. You can also sign in below to proceed if you already have an account.