Question How do I go about pausing transactional replication on the subscriber end. We have a publisher on Server A, a distributor on Server B and a subscriber on Server C. All are in the same network. Some background, we have quite a busy BizTalk … [Read More]
I’m a college drop-out. When I was trying to figure out my life, a friend (my brother’s ex) referred me to a software company where she was working–I got the job because I was (a) breathing, (b) eager to do the job, and (c) cheap. … [Read More]
Bloggers spend a lot of time writing about our successes, but we’re human and we make mistakes, too. This post is a chance to share one of my memorable failures.
Question Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are all grayed out, so that’s really. It an option. Any thoughts? Thanks… asked 2019-01-05 by Kevin Wilkie Answer You don’t restart Managed Instance. The beauty of … [Read More]
Question What is the most efficient way to determine whether row or page or columnstore compression (or none) would be most effective for each index in an Azure SQL Database (standard or premium tier) used for OLTP, where sp_estimate_data_compression_savings is not supported? I realize that … [Read More]
I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes … [Read More]
About two years ago, I moved my home office down into the basement at our house. Earlier this year, I started a new job at SentryOne, and work from home full time. This means I spend more (awake) time in my office than any other room in the house. I thought I’d take everyone through a guided tour of my home office.
It’s been almost two weeks since the LGBTQ Meetup that I organized at PASS Summit, and I wanted to offer a bit of follow-up and commentary on the event. Why did I wait two weeks before writing this follow-up? Well, tomorrow is American Thanksgiving, so … [Read More]
Question I want to install Microsoft SQL Server LocalDB 2017 on my system. I downloaded SQL Server Express Setup (about 5.1 MB). Then I opened it and chose ‘Download Media’ option and then chose LocalDB. Then it downloaded SqlLocalDB.msi setup (about 45.9 MB). I ran … [Read More]
Question My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup transactional replication between on-premise server (publisher) and azure sql db. Then we … [Read More]
Copyright © 2025 | Andy Mallon | am2.co