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,396 views0 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,082 views0 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,039 views0 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,949 views0 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
600 views0 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
307 views0 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,859 views0 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.
288 views0 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,829 views3 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,520 views0 comments
bottom of page