MS SQL Server 2022 Express with SSMS

SQL Server Express LocalDB – SQL Server | Microsoft Learn Basic and install When done install SSMS from the same tab. Download and install Done start ssms hostname\sqlexpress, domain\user and trust server certificate

Normalization Normal Forms: A Recap The key, the whole key, and nothing but the key, so help me Codd. The key stands for 1NF: all tables must have a (primary) key because all records in the table must be unique.The whole key stands for 2NF: no functional dependencies on part of the key are allowed.Nothing […]

OD20761C – Querying Data with Transact-SQL

Database diagram used for some learning (Bikestore) The rest is here: In MSSM, on every object there it a property options, if you do some changes, you can press the script before the change is applied to get the SQL used. Run just portions of the query, mark the section and execute: docs […]

MS SQL Server 2016 Express with SSMS

Update, get the one with localdb SQL Server Express LocalDB – SQL Server | Microsoft Learn Then get SSMS Then you can connect: Choose master on options Download MS SQL Server 2016 Express: Install also the SSMS tool from the install, or download it from MS. SQL Server Management Studio (SSMS) is an […]