(Pieter Van Puymbroeck) Far Sync is a great technology. When implementing a Disaster Recovery (DR) scenario, the first remark is usually “We want zero Data Loss”. This is exactly what Data Guard is meant for in Synchronous mode.
Community
Deadlock Caused by Row Cache and Library Cache Locks
(Nenad Noveljic) I’ve been occasionally seeing deadlocks like the following one:
Ãíῶèé óåáõôüí
(Martin Berger) Sometimes it might be interesting to understand, what’s the SQL statement which is currently executed.
Excel Data Mapping to Update Existing Documents
(David McGahey) Excel began life as a simple spreadsheet tool. Over time, support for rich text styling options, built-in charts, and copy and paste formatting features has led many enterprises to create reports in Excel documents.
A Condensed 35-Year History of DB2 for z/OS (…and Db2 for z/OS)
(Craig S. Mullins) Let’s go back in time… over three decades ago… back to the wild and woolly 1980s! And watch our favorite DBMS, DB2, grow up over time.
Introduction to Azure SQL Database Instance Pools
(Marcin Policht) In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described.
Decoded Statistics Names and More
(Jason Brimhall) Every now and again I am asked about the meaning behind the automatically generated names for statistics in SQL Server. The quick answer is short, sweet and really easy.
Explore Blazor WebAssembly – use custom style, call external WebAPI, employ JavaScript interoperability
(Èçäèñëàâ Èçäèñëàâîâ) This article will demo the usage of Blazor WebAssembly and how to create simple web application with it. The article consists of three parts. In Part 1, we will work with styles. In Part 2, we will call external webAPIs. In Part 3, we will work with JavaScript interoperability.
SQL Server Backup Size vs Database Size Script
(Alejandro Cobar) As SQL Server DBAs, we can all agree that backups are essential and must be managed properly so that we can be able to recover from any disaster scenario. However, there are some cases where having the backup file is simply just not enough because you might not know how much disk s
Becoming Familiar With the Little Known SQL Keyword LATERAL
(Vadim Tkachenko) Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used.