![Creating Aliases In MySQL Shell Creating Aliases In MySQL Shell](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/customize-mysql-shell/header.jpg)
MySQL Shell is a powerful way to connect to and manage MySQL instances. Connections can even be made to servers that are behind an SSH connection. In this post, we will discuss how to extend and customize MySQL Shell so that it is easier to initiate those connections.
![Indexing Data in MySQL Document Store Indexing Data in MySQL Document Store](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/doc-store-indexes/header.jpg)
MySQL Document Store is a JSON document storage solution built on top of MySQL. One feature of MySQL Document Store that can help speed up searches is the ability to create indexes of data contained within our JSON documents. In this post, we will demonstrate creating an index and look at the changes made to our collection after we create the index.
![Importing a MongoDB Into MySQL Document Store with MySQL Shell Importing a MongoDB Into MySQL Document Store with MySQL Shell](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/mongo-to-doc-store.jpg)
MySQL Document Store is a “NoSQL” database built on top of MySQL.
![Connecting MySQL Shell Over SSH Connecting MySQL Shell Over SSH](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/ssh.jpg)
As I mentioned in my last post, I am a big fan of MySQL Shell. Until recently, I have only used MySQL Shell to connect to a local instance of MySQL running on my development machine.
![MySQL Shell Alias For PowerShell MySQL Shell Alias For PowerShell](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/mysql-alias.jpg)
Yesterday, my colleague, Fred (AKA LeFred), shared a blog post that discusses setting up aliases that allow us to run MySQL Shell when we enter mysql
at a command prompt.
![MySQL Window Functions Part 2 MySQL Window Functions Part 2](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/window-function-2.jpg)
First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can also be a little intimidating when you first start using them. This post is the second in a series where we will discuss window functions – including breaking down the syntax and using examples of different window functions. All the code examples in this post use the database table and data we created in Part 1.
![Heading to Raleigh in November Heading to Raleigh in November](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/raleigh.jpg)
I am excited to announce that I am speaking at All Things Open this year.
![Speaking in NYC This Month Speaking in NYC This Month](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/brooklyn.jpg)
I am speaking at the International JavaScript Conference at the end of this month in Brooklyn, NY.
![MySQL Window Functions Part 1 MySQL Window Functions Part 1](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/window-function.jpg)
First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can also be a little intimidating when you first start using them. This post is the first in a series where we will discuss window functions – including breaking down the syntax and using examples of different window functions.
![Where Have I Been? Where Have I Been?](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://idmqjyw9i2ib.objectstorage.us-ashburn-1.oci.customer-oci.com/n/idmqjyw9i2ib/b/blog/o/2022/been.jpg)
If it seems like this space was neglected for a while, well…that is because it was.