Why is using proper ANSI settings important
by Jiri Dolezalek on 20/05/2021You might have been wondering what all those ANSI settings are and how they can affect you work.
Read moreFew days ago I have noticed that there will be a change (again) in certification paths for next generation of SQL servers. So I would like to recommend some thoughts about this from Microsoft Certified Masters (MCM) of Brent Ozar PLF Company.
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
You might have been wondering what all those ANSI settings are and how they can affect you work.
Read moreIntermittent SQL Server errors are among the most difficult problems to troubleshoot. A job can run successfully hundreds of times and then suddenly start failing. The same error may return days or weeks later, with no obvious change in the code.
Read moreThis story follows the investigation from recurring symptoms through failed conventional fixes to the storage-level change that finally stabilized the affected table.
Read more