We often get asked if we have experience with Microsoft SQL Server. The answer is a resounding YES. While we are also experts in PostgreSQL and MySQL systems, and build more systems in those technologies, Delta’s experience with Microsoft SQL Server goes back the furthest. Delta Systems Group has been building and maintaining systems powered by Microsoft SQL Server since at least 1997. Or to put that in SQL: SELECT * FROM Experience WHERE date_created >= ‘1997-01-01 00:00:00’; Ok, that was a little too geeky.
Delta’s Database Philosophy
- We nurture a culture wherein correctly designed databases are the foundation upon which all good apps are built. This goes for all database driven systems be it Microsoft SQL Server, PostgreSQL, or MySQL.
- Where possible, we don’t let clients delete data, we just mark it inactive. This has saved time, money, and jobs.
- All our tables contain at least four fields: id, date_created, date_updated, and updated_by_user_id. We can share many a war story on how these fields have saved the day time and again.
- We are intolerant of orphaned data and enforce referential integrity at every turn.
- Table relationships and strong data typing are the norm (We don’t let something like a birthdate be stored as a string).
- We loathe slow queries and are very good at optimizing tables, indexes, server settings, and query structuring to speed things along.
- We’re big proponents of noun-based table naming and properly named fields so future programmers don’t have to guess as to what is stored where.
- We’re well-versed in triggers, views, indexes, foreign-keys, calculated fields, stored procedures, user defined functions, maintenance plans, data cubing services, reporting services, as well as the differences between SQL, T-SQL, PL/SQL, and pgSQL.
Some Microsoft SQL Server-Based Client Examples
|