Instant SQL Masterpieces
Some common operations if done in a classic way will take ages on big tables. That …
Immutable backup against crypto attacks
Have you heard about Retention lock, Immutable Shared Folder, WORM (Write Once Read Many)? Many NAS …
Database recovery IMPORTANT rule
Recently, I had a case with a customer in a really difficult situation. They accidentally deleted …
SUSPECT database
Recently I had a customer case with a “suspect” database. In that state database is not …
How to partition a really big table?
Introduction For one customer I just transferred a troubled 2TB table (2 billion rows) into a …
How to pass arrays to SQL? TVP – The Ultimate Guide
You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide …
How to pass arrays to SQL? TVP – The Ultimate Guide Read more →
SQL for beginners
Want to learn SQL and need some guidance? SQL is the language you communicate with most …
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. …
How NOT to use CROSS APPLY
OUTER APPLY(SELECT TOP 1) pattern is widespread, even baked into some frameworks like Entity Framework. But …
Capacity Calculator for Storage Spaces
There is no official information (that I am aware of) on how to calculate maximum capacity …
