MySQL Performance: MySQL vs. MariaDB

Pros of Maria

• More Storage Engines Options
• Speed improvements
• Faster Indexes/Cache
• Speedier and Larger Connection Pool
• Improved Replication
• New Extensions/Features

Cons of Maria

• Missing Features
• Delayed MySQL Compatibility

https://www.liquidweb.com/kb/mysql-performance-mysql-vs-mariadb/

Pentagon snubs Oracle

https://www.fudzilla.com/news/memory-and-storage/48501-pentagon-snubs-oracle

SQL Server 2019 as Docker Image

https://www.microsoft.com/en-us/sql-server/sql-server-2019

Performance Tuning Oracle

https://blog.tanelpoder.com/posts/oracle-sql-monitoring-advanced-ash-usage-hacking-session/

Push for Oracle Database Level Changes Notification

https://docs.oracle.com/cd/B19306_01/B14251_01/adfns_dcn.htm

Async Database Tasks .NET

https://www.codeproject.com/Articles/1121822/Using-Async-Await-Task-Methods-With-SQL-Queries-NE

No Async Oracle Driver for .NET

https://softwarerecs.stackexchange.com/questions/18007/async-oracle-driver-for-net

Entity Framework Core Succinctly

Entity Framework Core is a complete rewrite from the “classic” Entity Framework, building on the new multiplatform .NET Core framework and adding the ability to connect to nonrelational data sources while keeping the features that made Entity Framework Code First so popular.

Microsoft Database Exam 98-364

https://www.microsoft.com/en-us/learning/exam-98-364.aspx

Understanding core database concepts (20–25%)

Create database objects (20–25%)

Manipulate data (25–30%)

Understand data storage (15–20%)

Administer a database (10–15%)

      Core

• Understand how data is stored in tables
  • Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
• Understand relational database concepts
  • Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
• Understand data manipulation language (DML)
  • Understand what DML is and its role in databases
• Understand data definition language (DDL)
• Understand how T-SQL can be used to create database objects, such as tables and views

Database Objects

• Choose data types
  • Understand what data types are, why they are important, and how they affect storage requirements
• Understand tables and how to create them
  • Purpose of tables; create tables in a database by using proper ANSI SQL syntax
• Create views
  • Understand when to use views and how to create a view by using T-SQL or a graphical designer
• Create stored procedures and functions
• Select, insert, update, or delete data

Manipulating Data

• Select data
  • Utilize SELECT queries to extract data from one table, extract data by using joins, combine result sets by using UNION and INTERSECT
• Insert data
  • Understand how data is inserted into a database, how to use INSERT statements
• Update data
  • Understand how data is updated in a database and how to write the updated data to the database by using the appropriate UPDATE statements, update by using a table
• Delete data
• Delete data from single or multiple tables, ensure data and referential integrity by using transactions

Data Storage

• Understand normalization
  • Understand the reasons for normalization, the five most common levels of normalization, how to normalize a database to third normal form
• Understand primary, foreign, and composite keys
  • Understand the reason for keys in a database, choose appropriate primary keys, select appropriate data type for keys, select appropriate fields for composite keys, understand the relationship between foreign and primary keys
• Understand indexes
• Understand clustered and non-clustered indexes and their purpose in a database

Administration

• Understand database security concepts
  • Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles
• Understand database backups and restore
  • Understand various backup types, such as full and incremental, importance of backups, how to restore a database

Books about Microsoft SQL Server

•  Introducing Microsoft SQL Server 2014 (2014), by Ross Mistry, Stacia Misner
•  Microsoft SQL Server 2012 Internals (2013), by Kalen Delaney
•  Microsoft SQL Server 2012 T-SQL Fundamentals (2012 ), by Itzik Ben-Gan
•  SQL Server 2012 Query Performance Tuning, 3rd Edition (2012), by Grant Fritchey
•  Professional SQL Server 2012 Internals and Troubleshooting (2012), by Christian Bolton, Justin Langford, Glenn Berry, Gavin Payne, Amit Banerjee, Rob Farley
•  SQL Server 2012 T-SQL Recipes, 3rd Edition (2012), by Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, and Wayne Sheffield
•  Expert Performance Indexing for SQL Server 2012 (2012), by Jason Strate, Ted Krueger
•  SQL Server 2008 Administration in Action (2009), by Rod Colledge
•  Applied Microsoft SQL Server 2008 Reporting Services (2008), by Teo Lachev
•  Securing SQL Server 2nd Edition (2012), by Denny Cherry

SQL Server Express Compatible with Windows 7

https://msdn.microsoft.com/library/ms143506(v=sql.120).aspx

SQL Server 2014 Express is the latest to support Windows 7 Home

SQL Server 2016 and SQL Server 2017 minimum OS is Windows 8 and they are only 64 bit

IT - Oracle - Optimizing SQL Statements

Oracle - Optimizing SQL Statements
https://docs.oracle.com/cd/B28359_01/server.111/b28274/part4.htm

MySQL migration from 5.0 to 5.6

http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/


mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.15, for Win32 (ia32)
Connection id:          3
Current database:
Current user:           ODBC@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.15-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 4 days 6 hours 22 min 35 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 0  Queries per second avg: 0.000
--------------

C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>mysqldump.exe -uroot --add-drop-table --all-databases --force > c:\temp\all-mysql-dbs.dmp --password Enter password: ****

uninstall mysql 5.0

mysql --uroot --password --execute="source c:\temp\all-mysql-dbs.dmp"

Enter password: ****