Luis LemaHow does SQL Server protect data with the Always-Encrypted feature?SQL Server does not view your data; only you do.Nov 1Nov 1
Luis LemaConnect Rust and the Tokio runtime to SQL ServerDo not be discouraged; half of this post is pure code.Aug 19Aug 19
Luis LemaDo you want SQL Server 2000 to run on Windows 11? Here is howIt works on Windows 10, too.Jun 18Jun 18
Luis LemaWhy to use Accelerated Database Recovery in SQL ServerConstant Recovery Time (CTR) for friends.May 1May 1
Luis Lema“Secondary database is not joined.” warning in an Always On Availability GroupWhile you are setting up an Always On Availability Group in SQL Server from scratch using local accounts instead of domain accounts, you…Mar 13Mar 13
Luis LemaUse Rust to do bulk inserts in SQL ServerThe INSERT statement is pretty easy to use when you need to save little amounts of data, but it turns out to be very inefficient when…Jan 1Jan 1
Luis LemaTweak predicates in the WHERE clause to make your queries run slow!Suitable for people that dislike high performant queries.Nov 1, 2023Nov 1, 2023
Luis LemaConnect Rust to SQL ServerThe Rust is a multi-platform system programming language that aims to be the successor of ancient languages like C or C++, why use Rust?……Sep 1, 2023Sep 1, 2023
Luis LemaLocking is not the devil of databasesWhen you run statements like: select or update statement concurrently, you will face weird issues because of that, but relax, SQL Server…Jul 1, 2023Jul 1, 2023