Bookmarks tagged “sql”
8 bookmarks tagged “sql”
Abusing SQLite to Handle Concurrency | SkyPilot Blog
SkyPilot uses the venerable SQLite for state management. SQLite can handle millions of QPS, and terabytes of data. However, our efforts to scale our Managed Jobs feature ran up against the one downfall of SQLite: many concurrent writers. Since SkyPilot typically runs as a CLI on
What are SQL Joins? Types of SQL joins explained - DEV Community
This article was written by Christina Kopecky and was originally published at Educative, Inc. Str...
IO Block Size for SQL Server, Disk Block Size - Pure Storage
Check out this Pure Storage post to understand a bit more about SQL Server IO block sizes, as well as backups and restores.
Availability Group issues fixed with Alerts - Wayne Sheffield
Learn how to use the SQL Server Agent Alerting system to detect Availability Group issues and to respond to them by running jobs.
NULL complexities – Part 1 - SQLPerformance.com
Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.
Availability Groups and Redo Latency, Data Committed on a Primary isn’t Vis
If you’re running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that you could do that, you could …
How Stack Overflow upgraded from Windows Server 2012
Warning: This post is long. While working through this massive server upgrade/migration process, tears were shed, many cuss words were said, along with a general feeling of frustration, which ultimately culminated into extreme happiness once the migration was completed. The scale