Is it “index create memory” or “index create memory (KB)”?

I was updating an Aireforge Advise fix script and as it's important that we're using the correct syntax, I double check everything. Including commands that I've been using for 18 years as they can change between versions. I checked a few articles including TechNet, Microsoft Docs and some popular forums. All of them referenced index create … Continue reading Is it “index create memory” or “index create memory (KB)”?

Comparing SQL Server configurations with Aireforge Studio

For ease of maintenance and performance reasons, we always aim to standardised our SQL Server estates (some of which contain over 100 instances). Everything is synchronised for their specific workload pools, so all search servers and all reporting servers are identical etc. Not only do we standardise the hardware or the VMs, but we ensure … Continue reading Comparing SQL Server configurations with Aireforge Studio

Why we went straight to OmniCompare 0.9 and what’s new?

So we talked a lot about 0.8.3 and how great it would be but then skipped it and went straight to 0.9.0. First of all, apologies for promising an upgrade and then delaying it but we had good reasons for this. Version 0.8.3 was supposed to include a couple of new features (mainly CLI) and … Continue reading Why we went straight to OmniCompare 0.9 and what’s new?