T-SQL Tuesday Retrospective #004: I/O

Mike Walsh invited us on March 1st 2010 to write about I/O. This abbreviation stands for Input / Output, and is often used as shorthand for persisted storage. Given the breadth of the topic I decided to write about RAID levels, but I must state outright that RAID is not a backup. A Redundant Array
-> Continue reading T-SQL Tuesday Retrospective #004: I/O

A half-closed MacBook

How SQL Server stores data types: XML

This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of other data types, here are the previous posts in the series: Bit columns Dates and times Integers and decimals Money Floating points GUIDs What is XML?
-> Continue reading How SQL Server stores data types: XML

Post image

Azure Storage Throughput

Hot on the heels of DTUs from earlier this week, today we’re going to switch focus a little, while staying with Azure, and have a quick look at storage speeds on SQL Server running on Azure Virtual Machines (Infrastructure-as-a-Service). Microsoft recently lowered their prices for more popular VMs, which is making this an attractive solution for
-> Continue reading Azure Storage Throughput

Post image

What is physical storage anyway?

My friend Jason asked me about his MySQL database export file last week, whether it was sufficient to create a new database. I replied saying that he would have to set up the database separately, because the physical files are allocated in a particular way depending on the web host. What is a physical file,
-> Continue reading What is physical storage anyway?