top of page


Contained Availability Group SQL Server 2022
SQL Server 2022 can be used to sync up agent jobs, logins, and permissions automatically between primary and secondary replicas. Read More
rajendra gupta
May 30, 20223 min read
2,486 views
0 comments


Install SQL Server 2022 on Windows
This article guides you in installing SQL Server 2022 preview.
rajendra gupta
May 26, 20223 min read
4,282 views
0 comments


A handy guide for Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full
Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full - Do you get error 9002? Read more for a handy guide.
rajendra gupta
May 18, 20222 min read
1,071 views
0 comments


Generate and Decode QR Codes with Python
This post discusses how to use Python to generate and decode QR Codes. Learn how to use Python to develop your custom QR Code.
rajendra gupta
May 13, 20223 min read
2,021 views
0 comments


Why developers should avoid creating SQL Server Stored Procedure prefix SP_
I will show you why developers should avoid creating SQL Server stored procedures that start with SP_. Read More here
rajendra gupta
May 11, 20222 min read
615 views
0 comments


T-SQL script to configure SQL Database for optimal VLF distribution
T-SQL script to configure SQL Database for optimal VLF distribution
rajendra gupta
May 5, 20221 min read
314 views
0 comments


SQL Server MeMORY Optimized Table Variables for faster performance
SQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here
rajendra gupta
May 4, 20222 min read
1,911 views
0 comments


Read Session-Specific data from the memory-optimized temp tables
Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
rajendra gupta
May 3, 20222 min read
305 views
0 comments


Use Memory Optimization for Faster temp table performance
Read this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.
rajendra gupta
Apr 22, 20224 min read
3,932 views
3 comments


Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
This article discusses how SQL Server locking works with the SQL Server Update Statistic command.
rajendra gupta
Apr 21, 20222 min read
5,695 views
0 comments
bottom of page