Upgrade your SQL Server to scale before adding new hardware

In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and interactions with customers, we found that most customers running older releases of SQL Server and experiencing performance and… Continue reading Upgrade your SQL Server to scale before adding new hardware

Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017

Smart Transaction Log Backups Most DBAs today operating their SQL Server database in full recovery model, schedule their transaction log backups to recur on a specific time interval (every 15 mins) for a highly transactional database to avoid autogrowth of the transaction log files. This works well assuming transactional activity is consistent or predictable throughout… Continue reading Smart Transaction log backup, monitoring and diagnostics with SQL Server 2017