Tag: <span>SQL Server</span>

How to pass arrays to SQL? TVP – The Ultimate Guide

Vedran Dec 8, 2020 Tagged with arrays, batches, csharp, sql, SQL Server, table-valued parameters, TSQL, tvp

You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide …

Vedran Sep 6, 2020 Tagged with Azure, Performance, sql, SQL Server

There are ways to greatly improve performance and power of your SQL Server databases in Azure. …

Vedran Apr 29, 2020 Tagged with Azure, disk, Performance, SQL Server, storage, Storage Spaces

Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google …

Vedran May 10, 2019 Tagged with addin, addon, sp_xdetails, sql, SQL Server, sqlxdetails, TSQL, xdetails

While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because …

Data Engine

Vedran Sep 26, 2018 Tagged with docker, ds918, SQL Server, synology

Introduction Docker is perfect for launching DEV and TEST SQL Server environments, when you need many …

Vedran May 30, 2017 Tagged with Catch all query, Optimize, Performance, SQL Server, TSQL

In almost every database we have a process that filters the same data with different filters.…