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)
amtwo profile

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

#sql #powershell #sqlserver
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.

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

Multi-subnet availability group, without MultiSubnetFailover support

#sql #powershell #sqlserver
Comments
8 min read
Microsoft Azure hack for social justice
amtwo profile

Microsoft Azure hack for social justice

#azure #hackathon #beginners
1
Comments
1 min read
What’s important in a code of conduct?
amtwo profile

What’s important in a code of conduct?

#diversity #inclusion
1
Comments
5 min read
Find the SQL Server service account with sys.dm_server_services
amtwo profile

Find the SQL Server service account with sys.dm_server_services

#sql #sqlserver #database #tsql
4
Comments
2 min read
Making non-SARGable queries seek, without changing the query
amtwo profile

Making non-SARGable queries seek, without changing the query

#sql #database #sqlserver #performance
5
Comments
3 min read
Replication latency when an Availability Group replica is offline
amtwo profile

Replication latency when an Availability Group replica is offline

#sql #sqlserver #database #highavailability
1
Comments
3 min read
Stop trying to shrink tempdb files
amtwo profile

Stop trying to shrink tempdb files

#sql #sqlserver #database
5
Comments
4 min read
Fixing tempdb: Growing, shrinking, and removing data files
amtwo profile

Fixing tempdb: Growing, shrinking, and removing data files

#sql #sqlserver #tsql
2
Comments 1
7 min read
Should I install SSMS on a server running SQL Server?
amtwo profile

Should I install SSMS on a server running SQL Server?

#sql #performance #shortcuts
6
Comments 3
5 min read
Redgate Streamed
amtwo profile

Redgate Streamed

#sql #ssms #redgate
Comments
3 min read
When STRING_SPLIT() falls short
amtwo profile

When STRING_SPLIT() falls short

#sql #sqlserver #performance
5
Comments
3 min read
Joining the Friends of Redgate program 🎉
amtwo profile

Joining the Friends of Redgate program 🎉

#sql #redgate
4
Comments
1 min read
Blocking with OBJECT_NAME()
amtwo profile

Blocking with OBJECT_NAME()

#tsql #sql #sqlserver
5
Comments 1
4 min read
What the heck is the dbcreator role?
amtwo profile

What the heck is the dbcreator role?

#sql #sqlserver #security
6
Comments
3 min read
Testing as another user…without their password
amtwo profile

Testing as another user…without their password

#sql #sqlserver #security
7
Comments
5 min read
I hate sp_estimate_data_compression_savings
amtwo profile

I hate sp_estimate_data_compression_savings

#sql #sqlserver #datacompression
5
Comments
6 min read
Changing a column from int to bigint, without downtime
amtwo profile

Changing a column from int to bigint, without downtime

#datacompression #performance #tsql #sqlserver
5
Comments
9 min read
How to create date buckets in T-SQL
amtwo profile

How to create date buckets in T-SQL

#sql #sqlserver
7
Comments
5 min read
How does a database RESTORE affect plan cache?
amtwo profile

How does a database RESTORE affect plan cache?

#sql #sqlserver #backup
6
Comments
7 min read
What the heck is Accelerated Database Recovery?
amtwo profile

What the heck is Accelerated Database Recovery?

#sql #sqlserver #recovery
5
Comments
3 min read
What the heck is the SQL Server Version Store?
amtwo profile

What the heck is the SQL Server Version Store?

#sql #sqlserver
3
Comments
4 min read
Recovery of database is 0% complete (approximately 1000000 seconds remain)
amtwo profile

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

#sqlserver #sql #recovery
6
Comments
4 min read
When to put a non-clustered index on your clustering key
amtwo profile

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

#sql #sqlserver #indexes
6
Comments
2 min read
Why does ALTER let me DROP?
amtwo profile

Why does ALTER let me DROP?

#sql #sqlserver
6
Comments
4 min read
Data Blogger Resource Kit
amtwo profile

Data Blogger Resource Kit

#career #sql #sqlserver
7
Comments
3 min read
What the heck is downtime, anyway?
amtwo profile

What the heck is downtime, anyway?

#career #sql #sqlserver
5
Comments
3 min read
Configuring the distribution database in an Availability Group
amtwo profile

Configuring the distribution database in an Availability Group

#sql #sqlserver #availabilitygroups #replication
5
Comments
3 min read
Code to purge data based on creation date
amtwo profile

Code to purge data based on creation date

#automation #performance #sql #sqlserver
6
Comments
5 min read
Purging data with batched deletes
amtwo profile

Purging data with batched deletes

#automation #sql #sqlserver
6
Comments
5 min read
The thrill of purging old data
amtwo profile

The thrill of purging old data

#automation #performance #sql #sqlserver
5
Comments
4 min read
Failure is always an option
amtwo profile

Failure is always an option

#career #sql #sqlserver
9
Comments
5 min read
Using PowerShell to tidy up CSV files
amtwo profile

Using PowerShell to tidy up CSV files

#powershell #sql #sqlserver
7
Comments
3 min read
loading...