Re: SQL Server & MySQL

And the reason I didn’t recommend Grant is not because he isn’t skilled in the area of fundamentals - just missed the reference to the redgate webinar.

Now if you wanted to know about the query store, Kyle, Grant’s one of only three I’d recommend!

Kellyn

On Sun, Feb 13, 2022 at 9:08 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 2/13/22 11:54, kyle Hailey wrote:
>
>
> Does anyone know of any good books, websites that explain how SQL Server
> and MySQL manage read consistency, i.e creating point in time views of
> data? An explanation like the beginning of Jonathan Lewis' Oracle 8i Book
> would be greatly appreciated. I understand Oracle and Postgres read
> consistency but don't know MySQL or SQL Server.
>
> Thanks
> Kyle
>
> Hi Kyle,
>
> I dunno about the SQL Server, but a decent explanation of MySQL
> concurrency control is here:
>
>
> https://medium.com/_at_ajones1_999/understanding-mysql-multiversion-concurrency-control-6b52f1bd5b7e
>
> Of course, there is always the fine manual:
>
> https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
>
> Jonathan probably knows a bit about SQL Server, he was engaged in the
> architecture debate with Grant Fritchey, a SQL Server guru, a few years
> ago. Here is what I am still able to find from that debate:
>
>
> https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-heap-tables-or-sql-server-clustered-indexes-jonathan-lewis-and-grant-fritchey-live-debate/
>
>
> https://www.red-gate.com/simple-talk/databases/sql-server/learn/oracle-to-sql-server-crossing-the-great-divide-part-1/
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
> -- http://www.freelists.org/webpage/oracle-l

-- 



*Kellyn Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar

--
http://www.freelists.org/webpage/oracle-l