↓ Skip to Main Content
Vedran Kesegic Blog

Vedran Kesegic Blog

Main Navigation

  • Home
  • sp_xdetails
  • Performance Logging

Category: Storage

4 tips to Boost Performance of Azure SQL Server

By Vedran Posted on 2020-09-06 Posted in Data Engine, Performance, Storage No Comments Tagged with Azure, Performance, sql, SQL Server
4 tips to Boost Performance of Azure SQL Server

There are ways to greatly improve performance and power of your SQL Server databases in Azure. Even better, monthly costs are reduced at the same time! How is that even possible? I routinely do that for my customers and will …

4 tips to Boost Performance of Azure SQL Server Read more »

Capacity Calculator for Storage Spaces

By Vedran Posted on 2020-08-10 Posted in Storage 10 Comments Tagged with Calculator, Capacity, Storage Spaces

There is no official information (that I am aware of) on how to calculate maximum capacity one can get from physical disks of different sizes in Storage Spaces. Based on partial documentation and logic, I got the formula that all …

Capacity Calculator for Storage Spaces Read more »

High Speed Storage in Azure?

By Vedran Posted on 2020-04-29 Posted in Performance, Storage 4 Comments Tagged with Azure, disk, Performance, SQL Server, storage, Storage Spaces
High Speed Storage in Azure?

Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google Cloud)? Machine throughput (total MB/s) for storage is severely limited. Even on very expensive server VMs they give you not much more than about …

High Speed Storage in Azure? Read more »

8 Myths about Storage Spaces

By Vedran Posted on 2019-07-28 Posted in Performance, Storage 57 Comments Tagged with Storage Spaces, Windows
8 Myths about Storage Spaces

Introduction EVERYBODY should read this! Whether you have a big database that needs speed, or other valuable data like documents or just personal pictures you do not want to lose when disk fails (disks DO fail without notice, just a …

8 Myths about Storage Spaces Read more »

Databases on file share

By Vedran Posted on 2018-12-09 Posted in Data Engine, Storage No Comments

Introduction You might have lot of virtual machines (VM) for Dev and Test environments. And a storage with huge amount of space to fit all databases. What are the options? Probably the best for performance would be to connect to …

Databases on file share Read more »

Our Mission

Our Mission

Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.

Vedran Kesegić, M.Sc.
SQL Server Database Consultant
Email: [email protected]

A Random Thought

You don't have a backup until you tried to restore it! Validate your backups. At least, use RESTORE VERIFYONLY immediately after a backup, and use CHECKSUM option when doing a backup.

Categories

  • Backup and Recovery
    • Transaction Log
  • BI
  • Conferences
  • Data Engine
  • Performance
  • Security and encryption
  • Storage
  • TSQL and SQL Client Code
  • Uncategorized

Recent posts

  • Database recovery IMPORTANT rule
  • SUSPECT database
  • How to partition a really big table?
  • How to pass arrays to SQL? TVP – The Ultimate Guide
  • SQL for beginners
Copyright © 2025 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube