SQL Posts
Backing Up SQL Server the Right Way
Backups are one of the most important aspects of managing a SQL Server database, yet they are often overlooked until something goes wrong. Whether you are protecting a business-critical system or a personal project, having a reliable backup strategy can mean the difference between a minor inconvenience and a complete disaster. In this article, I will cover the key principles of backing up SQL Server correctly and avoiding some common mistakes.
Writing Raw SQL When Entity Framework Isn’t Enough
Entity Framework makes database access straightforward, handling most queries with minimal code. However, there are situations where LINQ queries become difficult to optimise, database-specific features are required, or performance is critical. In these cases, writing raw SQL can provide greater control, improved efficiency, and access to capabilities that Entity Framework does not directly support.
Popular in SQL
Backing Up SQL Server the Right Way
Admin in SQL
Indexes Explained Like It’s 1988
Admin in SQL
Become a member
Get the latest news right in your inbox. It's free and you can unsubscribe at any time. We hate spam as much as we do, so we never spam!