Prisma

Hey <!everyone> :v: :prisma-cool:

We just released Prisma *<https://github.com/prisma/prisma/releases/tag/2.10.0|v2.10.0>*! :prisma-rainbow:

In this release, we brought you a *new command to run change your database schema in prototyping and local development* stages as well as *support for Microsoft SQL Server*! 🥳

:studio_microphone: *Support for Microsoft SQL Server (Preview)*
With this release, we're introducing support for a new database: *Microsoft SQL Server* :tada: 

You can start using your MS SQL Server databases today with *introspection* and query them with *Prisma Client*. Note that Prisma Migrate does _not_ support MS SQL Server yet.

An MS SQL Server database is specified in your Prisma schema via the new `sqlserver` connector. Note that while it's in _Preview_, you also need to add the additional `previewFeature` flag `microsoftSqlServer` in the generator for Prisma Client:
```datasource db {
  provider = "sqlserver"
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["microsoftSqlServer"]
}```

Learn more in the <https://www.prisma.io/docs/reference/tools-and-interfaces/preview-features/sql-server|documentation> or read the <https://www.prisma.io/blog/prisma-sql-server-support-preview-a4anl2gd8d3a|announcement blog post>! :books:

:trackball: *Single-command schema changes for prototyping (Preview)*
With this release, we are introducing a new command that lets you _push_ the state of your Prisma schema file to the database without using migrations: `prisma db push --preview-feature`

The idea behind `prisma db push` is that you only care about the _end state_ of your database schema, but not about _how_ this end state is achieved.

Also note that the command runs `prisma generate` for you, so you're saving an extra step after having updated your Prisma schema! :tada:

Learn more in the <https://www.prisma.io/docs/reference/tools-and-interfaces/prisma-cli/command-reference#db-push|documentation>! :books:

:books: *Learn more in the release notes*
For more info and links to documentation, you can read the *<https://github.com/prisma/prisma/releases/tag/2.10.0|release notes>*.

:star2: *Help us spread the word about Prisma* :star2:
To help spread the word about Prisma, we’d very much appreciate if you would star the <https://github.com/prisma/prisma/|repo> :star2: And if you’re excited about the features in this week’s release, then help us and <https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20Prisma%20release%202.10.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/2.10.0|share your excitement on Twitter>.

:crystal_ball: *Interested in providing feedback for the upcoming version of Prisma Migrate?*
We are seeking users interested in trying out upcoming versions of Prisma Migrate. This will involve trying it out, validating functionality, and sharing feedback with us.
If you’re interested in participating, <https://prisma103696.typeform.com/to/yssOzU8F|fill out the following form>, it won’t take longer than a minute!

:earth_africa: *Join us _today_ for the first Prisma Online Meetup on October 28, 2020 6pm CET*
*Join with engineers from all around the globe for the* <https://youtu.be/SepT_whwFsA|Prisma Online Meetup> to learn about database best practices, the Prisma inside scoop, and examples of Prisma in production *in less than an hour* (October 28) *at 6pm CET | 10am PDT*.

• <https://twitter.com/tammyxbryant|Tammy Bryant>, Principal SRE of Gremlin: “Database horror stories”.
• <https://twitter.com/hervelabas|Herve Labas>, Prisma’s VP of Product, talking about the future of Prisma and its roadmap.
• Success story of an app built with Prisma told by its creator.
:newspaper:  *Join our _What's new in Prisma_ livestream tomorrow*
Catch <@UFRBVJV6J> and me tomorrow on <https://www.youtube.com/watch?v=1F53fTk4lYQ|Youtube> as we are are discussing the latest news from the Prisma ecosystem and community in the next _<https://www.youtube.com/watch?v=1F53fTk4lYQ&amp;ab_channel=Prisma|What's new in Prisma>_ livestream! :tada:

The event will be streamed on <https://youtu.be/SepT_whwFsA|YouTube> :tv: