DEV Community 👩‍💻👨‍💻

Andy Mallon profile picture

Andy Mallon

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

Location Boston, MA Joined Joined on  Personal website https://am2.co github website twitter website

Work

Database Administrator

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

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

Comments
3 min read

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.

Already have an account? Sign in
Multi-subnet availability group, without MultiSubnetFailover support

Multi-subnet availability group, without MultiSubnetFailover support

Comments
8 min read
Microsoft Azure hack for social justice

Microsoft Azure hack for social justice

Reactions 1 Comments
1 min read
What’s important in a code of conduct?

What’s important in a code of conduct?

Reactions 1 Comments
5 min read
Find the SQL Server service account with sys.dm_server_services

Find the SQL Server service account with sys.dm_server_services

Reactions 4 Comments
2 min read
Making non-SARGable queries seek, without changing the query

Making non-SARGable queries seek, without changing the query

Reactions 5 Comments
3 min read
Replication latency when an Availability Group replica is offline

Replication latency when an Availability Group replica is offline

Reactions 1 Comments
3 min read
Stop trying to shrink tempdb files

Stop trying to shrink tempdb files

Reactions 5 Comments
4 min read
Fixing tempdb: Growing, shrinking, and removing data files

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?

Should I install SSMS on a server running SQL Server?

Reactions 6 Comments 3
5 min read
Redgate Streamed

Redgate Streamed

Comments
3 min read
When STRING_SPLIT() falls short

When STRING_SPLIT() falls short

Reactions 5 Comments
3 min read
Joining the Friends of Redgate program 🎉

Joining the Friends of Redgate program 🎉

Reactions 4 Comments
1 min read
Blocking with OBJECT_NAME()

Blocking with OBJECT_NAME()

Reactions 5 Comments 1
4 min read
What the heck is the dbcreator role?

What the heck is the dbcreator role?

Reactions 6 Comments
3 min read
Testing as another user…without their password

Testing as another user…without their password

Reactions 7 Comments
5 min read
I hate sp_estimate_data_compression_savings

I hate sp_estimate_data_compression_savings

Reactions 5 Comments
6 min read
Changing a column from int to bigint, without downtime

Changing a column from int to bigint, without downtime

Reactions 5 Comments
9 min read
How to create date buckets in T-SQL

How to create date buckets in T-SQL

Reactions 7 Comments
5 min read
How does a database RESTORE affect plan cache?

How does a database RESTORE affect plan cache?

Reactions 6 Comments
7 min read
What the heck is Accelerated Database Recovery?

What the heck is Accelerated Database Recovery?

Reactions 5 Comments
3 min read
What the heck is the SQL Server Version Store?

What the heck is the SQL Server Version Store?

Reactions 3 Comments
4 min read
Recovery of database is 0% complete (approximately 1000000 seconds remain)

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

Reactions 6 Comments
4 min read
When to put a non-clustered index on your clustering key

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

Reactions 6 Comments
2 min read
Why does ALTER let me DROP?

Why does ALTER let me DROP?

Reactions 6 Comments
4 min read
Data Blogger Resource Kit

Data Blogger Resource Kit

Reactions 7 Comments
3 min read
What the heck is downtime, anyway?

What the heck is downtime, anyway?

Reactions 5 Comments
3 min read
Configuring the distribution database in an Availability Group

Configuring the distribution database in an Availability Group

Reactions 5 Comments
3 min read
Code to purge data based on creation date

Code to purge data based on creation date

Reactions 6 Comments
5 min read
Purging data with batched deletes

Purging data with batched deletes

Reactions 6 Comments
5 min read
The thrill of purging old data

The thrill of purging old data

Reactions 5 Comments
4 min read
Failure is always an option

Failure is always an option

Reactions 9 Comments
5 min read
Using PowerShell to tidy up CSV files

Using PowerShell to tidy up CSV files

Reactions 7 Comments
3 min read
loading...