[!INCLUDE ssEnterpriseEd10] and later versions support backup compression. When creating a log shipping configuration, you can control the backup compression behavior of log backups. For more ...

SQL Server Agent, Linked Servers, defaults to encryption mandatory, using the latest security standards—TDS 8.0 and TLS 1.3. Configure TLS 1.3 encryption for Always On availability groups, failover ...

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. One of the most exciting new ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

Failing over to a log shipping secondary is useful if the primary server instance fails or requires maintenance. ## Preparing for a Controlled Failover Typically, the primary and secondary databases ...