theme | _class | paginate | backgroundColor | backgroundImage | footer | marp | style |
---|---|---|---|---|---|---|---|
gaia |
lead |
true |
true |
section {
font-size: 25px;
}
container {
height: 300px;
width: 100%;
display: block;
justify-content: right;
text-align: right;
}
header {
float: right;
}
a {
color: blue;
text-decoration: underline;
background-color: lightgrey;
font-size: 80%;
}
table {
font-size: 22px;
}
|
Session 9 Rasmus Lystrøm, Senior Cloud Solution Architect
- Databases
- Migrations in CI/CD
- Create Cheep (to Chirp!)
- Input Validation
- JavaScript and
libman
- Partials - reusable code
- UI Testing
Microsoft SQL Server Oracle Database IBM Db2 MySQL MariaDB PostgreSQL SQLite
Google BigQuery Amazon Relational Database Service (Amazon RDS) Azure SQL
Google Firestore Azure Cosmos DB Amazon DynamoDB MongoDB Couchbase Redis Elasticsearch Neo4j
Source: https://survey.stackoverflow.co/2023/#most-popular-technologies-database
MSSQL_SA_PASSWORD="33eca922-74a0-11ee-9e21-00155d9a126b"
docker run \
-e "ACCEPT_EULA=Y" \
-e "MSSQL_SA_PASSWORD=$MSSQL_SA_PASSWORD" \
-p 1433:1433 \
--name sql-server \
-d mcr.microsoft.com/mssql/server:2022-latest
https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker
CONNECTION_STRING="Data Source=localhost,1433;Initial Catalog=Chirp;User=sa;Password=33eca922-74a0-11ee-9e21-00155d9a126b;TrustServerCertificate=True"
dotnet user-secrets init
dotnet user-secrets set "ConnectionStrings:Chirp" "$CONNECTION_STRING"
<style scoped> section { font-size: 21px; } </style>
-
Local (Docker)
- Run a container with SQL Server 2022.
- Connection your app to SQL Server.
- Delete and recreate migrations.
- Test everything runs as before.
-
Cloud (Azure)
- Create Entra ID Group
Chirp SQL Admins
. - Create SQL Server with database (
Basic
tier) - Group is admin. - Ensure SQL Server firewall is open for Azure services.
- Create managed identity on web app.
- Make identity member of group.
- Grab connection string.
- Create Entra ID Group
Server=tcp:<server-fqdn>,1433; Initial Catalog=<database-name>; Encrypt=True;TrustServerCertificate=False; Connection Timeout=30; Authentication="Active Directory Default"