Learn about disaster recovery and high availability options in SQL Server with details on the tradeoffs you make when choosing from Availability Groups, Log Shipping, Database Mirroring, and Replication.
2024-04-15
1,024 reads
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database.
2024-04-15
Learn how it works and how to use the DENSE_RANK() function in your code.
2024-04-12
2,139 reads
2024-04-12 (first published: 2018-12-20)
9,926 reads
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies.
2024-04-12
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
2024-04-10
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-04-09 (first published: 2022-09-01)
2,579 reads
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
719 reads
Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
2024-04-08
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
2024-04-05
1,513 reads
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Hello, I have a script that was running really long, and I have found...
I am building a report to show customer journeys and their arrears levels. I...
hi, I have seen people use exists when exists is required and no cols...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers