Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.
Formatting T-SQL Consistently Across a Team
Formatting T-SQL consistently means choosing a few readable rules, using a formatter carefully, and keeping historical changes focused.
Sharding: When One Server Is Not Enough
Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
Rolling Out Database Changes Gradually
Roll out database changes gradually with expand-and-contract steps, feature flags, data checks, and a rollback path for each stage.
SQL SERVER – Enumerations in Relational Database – Best Practice
Marko Parkkola from Finland shares a best practice for enumerations in relational database design: the right way to store them and one clearly wrong way.
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
It’s my birthday, so I am taking a break from tech posts to spend time with family and to thank my top 7 commenters who help readers on this blog.