loading...
Andy Mallon profile picture

Andy Mallon

I am a SQL Server DBA, a Microsoft Data Platform MVP, and a carbaholic. he/him

Work

Database Administrator

Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2)

Reactions 0
3 min read

Multi-subnet availability group, without MultiSubnetFailover support

Reactions 0
8 min read

Microsoft Azure hack for social justice

Reactions 1
1 min read

What’s important in a code of conduct?

Reactions 1
5 min read

Find the SQL Server service account with sys.dm_server_services

Reactions 4
2 min read

Making non-SARGable queries seek, without changing the query

Reactions 5
3 min read

Replication latency when an Availability Group replica is offline

Reactions 1
3 min read

Stop trying to shrink tempdb files

Reactions 5
4 min read

Fixing tempdb: Growing, shrinking, and removing data files

Reactions 2 Comments 1
7 min read

Should I install SSMS on a server running SQL Server?

Reactions 6 Comments 3
5 min read

Redgate Streamed

Reactions 0
3 min read

When STRING_SPLIT() falls short

Reactions 5
3 min read

Joining the Friends of Redgate program 🎉

Reactions 4
1 min read

Blocking with OBJECT_NAME()

Reactions 5 Comments 1
4 min read

What the heck is the dbcreator role?

Reactions 6
3 min read

Testing as another user…without their password

Reactions 7
5 min read

I hate sp_estimate_data_compression_savings

Reactions 5
6 min read

Changing a column from int to bigint, without downtime

Reactions 5
9 min read

How to create date buckets in T-SQL

Reactions 7
5 min read

How does a database RESTORE affect plan cache?

Reactions 6
7 min read

What the heck is Accelerated Database Recovery?

Reactions 5
3 min read

What the heck is the SQL Server Version Store?

Reactions 3
4 min read

Recovery of database is 0% complete (approximately 1000000 seconds remain)

Reactions 6
4 min read

When to put a non-clustered index on your clustering key

Reactions 6
2 min read

Why does ALTER let me DROP?

Reactions 6
4 min read

Data Blogger Resource Kit

Reactions 7
3 min read

What the heck is downtime, anyway?

Reactions 5
3 min read

Configuring the distribution database in an Availability Group

Reactions 5
3 min read

Code to purge data based on creation date

Reactions 6
5 min read

Purging data with batched deletes

Reactions 6
5 min read

The thrill of purging old data

Reactions 5
4 min read

Failure is always an option

Reactions 9
5 min read

Using PowerShell to tidy up CSV files

Reactions 7
3 min read
loading...