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 1Mar 1
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
Luis LemaSo many data providers for SQL ServerSometimes our only concern is to connect to SQL Server instances and start throwing queries, but we forget that the methods we are using to…May 1, 2023May 1, 2023
Luis LemaMeet columnar storage of SQL ServerHistorically SQL Server saved data using a row based storage which is efficient for operations done over specific rows, but when the amount…Mar 1, 2023Mar 1, 2023
Luis LemaFast insert and slow insert into tables, both usefulWhen it comes to insert data in a SQL Server database you can choose between two velocities: slow and fast, and I am almost sure that you…Jan 1, 2023Jan 1, 2023