Databases · Tool
SQL Server
Microsoft's enterprise relational database.
Used at
- Marvin
01Overview
SQL Server is Microsoft's relational database, common in enterprise and .NET environments. I worked with it on legacy systems where data integrity and careful change were essential.
02Key concepts
What anyone working with it needs to understand
- 01
T-SQL
Microsoft's SQL dialect, CTEs and window functions.
- 02
Stored procedures
Encapsulating logic close to the data — and its trade-offs.
- 03
Indexing
Clustered vs non-clustered indexes and execution plans.
- 04
Transactions & locking
Isolation levels and avoiding deadlocks.
- 05
Integration with .NET
Entity Framework and ADO.NET access.
- 06
Azure SQL
Managed SQL Server in the cloud.
03In practice
Maintained legacy systems backed by SQL Server for the energy and pharmaceutical sectors at Marvin.
