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.
Category: SQL Server
In some cases, sharding can be a total re-architecture of how data is being accessed and stored.
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.
Learn about the ORDER BY clause used to order query results set by one or more columns, including common use cases and performance considerations.
SQL Server expert explains the T-SQL DISTINCT clause, including use cases, common performance considerations, tips, and tricks.
Learn about T-SQL UNION operator best practices from a respected SQL Server expert with examples and answers to questions like UNION vs. UNION ALL.
Introductory and how-to guide explaining what transactions are, why they're necessary, and how they work in SQL Server.
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.
This article gives a primer on restoring database backups, transaction log backups, and the correct restore sequence needed for a series of backups.
What’s the secret to making SQL Server go faster on Azure VMs? Why is doing this so important? Find answers in this article.
When interviewing for a SQL Server DBA position, there's almost always a technical and non-technical portion. Here's how to prepare.
Use this daily SQL Server best practice checklist for DBAs to keep an eye on and stay ahead of common SQL Server performance issues.
Learn some general recommendations for how to approach SQL Server performance tuning to maximize effort and minimize distractions.
