DEV Community

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)

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

Comments
3 min read
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...