create-sql-server-log-shipping 
Percona
JULY 31, 2023
In the following example, an ENUM is created that will take only three values and reject other values, supposedly. This NULL problem can be avoided by setting the SQL Mode to STRICT. This table is created so that only selected accounts can see that secret column. This is different from what we want either logically or as data.
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.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
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. You can find the script that creates and populates this database here , and its ER diagram here. I'll continue using the sample database TSQLV5 like last month in some of my examples.
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.
SQL Performance
APRIL 22, 2020
In this post, I want to show the views I created to make consumption of the event data easier for people, and some caveats. First, I created a view that would expose the important bits from the Extended Events session data, and put it in the utility database that exists on every instance: CREATE VIEW dbo. Digestible views.
The Morning Paper
FEBRUARY 23, 2020
There have been several efforts to create a version of the WWW for "structured" data, such as the Semantic Web and Freebase. In AnyLog queries are expressed in SQL, but you could also think of e.g. a standard HTTP GET request as a distributed key-value store lookup query. SQL processing for publishers. web pages).
Expert insights. Personalized for you.
73 
Let's personalize your content