Generally speaking, there are two types of scaling for SQL Server workloads; horizontally partitioning the workload across multiple servers or vertically scaling the workload with a bigger, single server.
Learn how SQL JOIN is used to specify how to return data from different tables and the different SQL JOIN types in this comprehensive guide with examples.
When monitoring SQL Server performance, you should know which PerfMon counters matter and why. This guide identifies and explains the best 15 counters.
In this tutorial, I’ll show you how to use backups to perform point-in-time recovery and a more advanced way to determine an exact point to restore to.
Learn the key differences between NoSQL and SQL databases, such as relational databases trading performance to guarantee data and transactional consistency.