Pros and Cons of Database Sharding for Performance and Maintenance

Large databases usually have a negative impact on maintenance time, scalability and query performance. For maintenance, these large single databases have to be backed up daily while the amount of actual changing data might be small. For performance, tables without correct indexes result in full table or clustered index scans. As the data grows the total query time increase linearly. How can we decrease downtime for the maintenance window for large databases and optimize the performance of daily queries?

BIT_COUNT II

Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload

Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.

SQL Server Contained Availability Groups Configuration

In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

Learn how to get started with an MCP server that can query your SQL Server database.

Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outage

Learn how parameter sniffing appeared in a real system and how the issues were solved.

Concurrency and Baseline Control: Stairway to Reliable Database Deployments Level 5

As database development scales across multiple contributors, concurrency becomes an inherent aspect of the process. Changes that are individually correct may still conflict when developed against a shifting baseline. This level introduces a disciplined approach to managing parallel changesets by controlling their scope, identifying overlap, and resolving conflicts through realignment. By ensuring that only one changeset retains its original baseline while others are adapted accordingly, deployments remain predictable and consistent. Once released, changesets are treated as immutable, and further evolution proceeds through new, forward-only changes.

How to Deploy SQL Server on Kubernetes running on Windows

Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.

Index Fragmentation Explained: Page Splits, Logical Reads, and What to Do

Index fragmentation can silently degrade your query performance over time. Learn what happens at the page level, how to measure it, and how to fix it.

Midjourney, Healthcare?

Certain announcements in AI tell you more about where an industry is heading than any earnings call or research paper ever could, and Midjourney just made one. The company that spent the last few years as the most recognizable name in image generation, the one whose pictures flooded everyone's feeds and defined what people saw […]