## 2022 - [[SQL Server Management Studio]] - Install SSMS (T-SQL) - [[mssql]] - Management > Database Mail > Configure and setup `(See [[s.q.tsql.system-resources.stored-procedure.msdb.sp_send_dbmail]])` - Setup alternate login ```sql CREATE LOGIN [Bryan] WITH PASSWORD = <++>, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON; GO ALTER SERVER ROLE [sysadmin] ADD MEMBER [Bryan]; GO ``` ## 2021 - [[TSQL]] / [[sqlite3]] - In vscode using the SQLite extention you can't use the command `PRAGMA foreign_keys = ON;` to enable foreign key constrains on your SQLite tables. - You'd think that would be kind of a high priority change especially since the change appears to be an easy 1 liner change? - Either way [I requested that the change be made asap](https://github.com/AlexCovizzi/vscode-sqlite/issues/60)