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 …
If you still leave your databases at default settings, namely default isolation (READ COMMITTED – does it suck?), you are risking three things: increased blockage and deadlocks NOLOCK hints or READ UNCOMMITTED transaction isolation in the code, exposing users to …
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 …
Introduction Docker is perfect for launching DEV and TEST SQL Server environments, when you need many independent SQL instances, or ability to run and stop instances in seconds, only when you need them. Launched from one common image (1GB in …
SQL Server 2017 and 2019 on Docker inside Synology DS918+ Read more »
Do you use ROWVERSION/TIMESTAMP to pull changed data? If you do, you might experience a problem – not all changed rows are pulled, some are skipped. How can that be, if we pulled entire range of rowverion changes with no …
Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions (no BEGIN TRANSACTION). Even RCSI (Read Committed Snapshot Isolation) is turned ON to eliminate shared locks. Everything is “by the book” as Books Online …
We are always thinking about you, sometimes even on vacation! Here is a quick hello video from the island of Brac:
What is the memory limit for Standard edition of SQL 2016? The answer you will most often get is 128 GB. But that answer is not correct, or very partially correct at best case. When you plan a new SQL …
Compression feature was reserved for Enterprise Edition of SQL Server. With SQL 2016 SP1 we get it in all editions, e.g. Standard Edition. But, it is not always easy to say will we benefit from compressing certain table/index/partition or not. …
Checkpoint and Lazy Writer are somewhat similar: they both write pages from buffer pool memory to the disk. So, what is the difference?
