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.
Dynatrace
JULY 7, 2022
Then, they can split these services into functional application programming interfaces (APIs), rather than shipping applications as one large, collective unit. There are many common use cases for building services as a single application, such as automating a shipping label or charging a credit card. API gateways. Serverless platforms.
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
JULY 24, 2022
SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.
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?
Expert insights. Personalized for you.
277 
Let's personalize your content