sql-server-log-shipping 
DZone
FEBRUARY 9, 2024
SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. The transaction log backups are applied to each secondary database individually to obtain a synchronized database as primary.
Percona
JULY 31, 2023
SQL > INSERT INTO enum_example (id, is_good) values (3,NULL); Query OK, 1 row affected (0.0040 sec) SQL > SELECT * FROM enum_example; + -+ + | id | is_good | + -+ + | 1 | yes | | 2 | no | | 3 | NULL | + -+ + 3 rows in set (0.0027 sec) Dang! This NULL problem can be avoided by setting the SQL Mode to STRICT.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
JANUARY 20, 2022
All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. Performance issues from repeated shrinking of the transaction log. Performance issues from repeated shrinking of the transaction log.
SQL Performance
FEBRUARY 12, 2020
This month I describe powerful standard NULL handling features that have yet to make it to T-SQL, and the workarounds that people currently use. In Part 1 in the series I explained how NULLs behave in comparisons and the complexities around the three-valued predicate logic that SQL and T-SQL employ. DISTINCT predicate.
Percona
JUNE 4, 2023
In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?
SQL Server According to Bob
NOVEMBER 8, 2016
Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Create / Alter Database … LOG ON.
The Morning Paper
FEBRUARY 23, 2020
Our approach differs substantially by (1) providing economic incentives for data to be contributed and integrated into existing schemas, (2) offering a SQL interface instead of graph based approaches, (3) including the computational and storage infrastructure in the architectural vision. SQL processing for publishers. web pages).
Expert insights. Personalized for you.
277 
Let's personalize your content