Re: SQL Server & MySQL

Kyle,

The *#sqlhelp* hashtag on Twitter provides the equivalent of this list for SQL Server.

Hope this helps...

-Tim

On 2/14/2022 11:50 AM, kyle Hailey wrote:
>
> PS are there any good hangout spots for MySQL (or SQL Server while we
> are at it) like Oracle-L?
>
>
>
> 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-1217
> https://dbwhisperer.wordpress.com
>
> -- http://www.freelists.org/webpage/oracle-l
>

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