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)”?
Here's a quick PowerShell script (more of a personal reminder) to set everything for the current user to English-GB, UK locale and GMT timezone. Unfortunately, this doesn't override the settings for the welcome screen or new users but that's just one dialog after the restart. Change Current User #Set home location to United Kingdom Set-WinHomeLocation … Continue reading PowerShell script for en-GB, UK locale and GMT timezone
Like any issue, the cause of replication problems could be one of many, but checking what commands are being passed through the distributor is always worthwhile.
Indexes to improve the performance of SQL Server replication
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
I tend to use Redgate SQL Monitor when diagnosing hard to find issues or when helping teams to better understand their estates. Sometimes, we run into issues with the network during the installation which is usually down the Windows Management Instrumentation (WMI) ports. SQL Monitor uses WMI calls to get all the non SQL Server … Continue reading Testing WMI for Redgate SQL Monitor
Many companies use transactional replication to scale out their database reads; which can get quite large and very expensive. Costs can be reduced by moving to SQL Server Web Edition, which is extremely cheap for what you get, but after that you only really save money by reducing the server count. As SQL Server 2017 … Continue reading SQL Server on Linux and transactional replication
I've worked on a few system that use replication and the same issues tend to crop up. There's a discussion on SQL Server Central about what needs to be improved, so I thought I'd share my experiences Better default indexes (See blog) Vote | Improve replication latency monitoring (built-in canary tables). Vote | QueryStore for … Continue reading Replication wish list
Scripts to create pull subscriptions, the pull jobs, start them and the code required to add them to the publication on the publisher.