top of page


rajendra gupta
May 30, 20223 min read
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
2,455 views
0 comments


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


rajendra gupta
May 18, 20222 min read
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.
1,062 views
0 comments

rajendra gupta
May 13, 20223 min read
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.
1,991 views
0 comments


rajendra gupta
May 11, 20222 min read
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
612 views
0 comments


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


rajendra gupta
May 4, 20222 min read
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
1,884 views
0 comments


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


rajendra gupta
Apr 22, 20224 min read
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.
3,878 views
3 comments


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