Remove 2008 Remove Azure Remove Database Remove Hardware
article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49
article thumbnail

Strongly Type Those Table-Valued Parameters

SQL Performance

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. Where this really can make a difference is in cloud implementations where you are paying for more than just compute and storage resources.

Servers 55