Identify Tables With Dropped Columns
How easily can we find tables with dropped columns that need cleanup?
2024-06-07
2,077 reads
Data Storage
Long Term Storage
Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.
2022-06-24
328 reads
Do We Care About Disks?
I ran across a tip on MSSQLTips from Joe Gavin recently, and it got me thinking about hardware and disks. For a lot of us, we deal with servers and storage, and not disks. While we might have a disk on a laptop or desktop, most of the production systems just attach to remote storage. […]
2021-11-03
274 reads
Storage 101: Welcome to the Wonderful World of Storage
Understanding all the storage options available to...
2019-12-30
SQL Server Storage Internals 101
This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data.
2013-10-21
3,767 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Forums
Influencing a Local AI
Comments posted to this topic are about the item Influencing a Local AI
Data API Builder Operations
Comments posted to this topic are about the item Data API Builder Operations
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
Question of the Day
Data API Builder Operations
What types of database operations does the Data API Builder support?
See possible answers