rajendra gupta
- Aug 3
- 3 min
Install SQL Server 2022 on Ubuntu in 5 minutes
Having trouble installing SQL Server 2022 on Ubuntu? Follow our 5-minute guide and get SQL Server up and running on your Ubuntu machine.
259 views0 comments
rajendra gupta
- Jul 25
- 4 min
Explore SQL Coalesce function in SQL Server
This article explores the coalesce function in SQL Server that SQL uses to manipulate strings with NULLs in SQL Server.
90 views0 comments
rajendra gupta
- Jul 24
- 1 min
SQL Server 2022 STRING_SPLIT Function
SQL Server 2022 STRING_SPLIT Function
66 views0 comments
rajendra gupta
- Jul 12
- 4 min
SQL Server Queries to troubleshoot Memory pressure on SQL instance
SQL Server memory pressure can cause a lot of problems. This is a list of queries you can run to troubleshoot memory pressure problems. Read
1,915 views0 comments
rajendra gupta
- Jul 12
- 1 min
SQL SERVER script to get Database Backup History
Here is a SQL Server script that will get you the database backup history for a server. It is a significant troubleshooting step to determin
79 views0 comments
rajendra gupta
- Jul 12
- 1 min
Fix SQL Server error: SHOWPLAN permission denied in database ‘DBName’
Do you get the error "SHOWPLAN permission denied in database 'DBName'"? This error is due to SQL Server permissions. Find out how to fix SQL
217 views0 comments
rajendra gupta
- Jul 9
- 2 min
Fundamental SQL: SQL Query examples for CREATE DATABASE
CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.
41 views0 comments
rajendra gupta
- Jul 8
- 1 min
SQL Server Error 18456: failed to open the explicitly specified database
This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database.
114 views0 comments
rajendra gupta
- Jul 8
- 1 min
SQL Server Error VIEW SERVER STATE permission was denied on object 'server’,databasE'Master'
Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More
200 views0 comments
rajendra gupta
- Jul 5
- 2 min
Learn about Case Statement in SQL Server
Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,
16 views0 comments
rajendra gupta
- Jul 5
- 1 min
Convert Unix Timestamp in SQL Server (T-SQL)
Want to know how to convert a Unix timestamp to a SQL Server timestamp or vice-a-versa? This article shows you how to do it using T-SQL. Rea
70 views0 comments
rajendra gupta
- Jun 30
- 2 min
SQL Server Extended Events to track PAGE SPLITS in SQL Database
SQL Server Extended Events to track PAGE SPLITS in SQL Database
73 views0 comments
rajendra gupta
- May 30
- 3 min
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
895 views0 comments
rajendra gupta
- May 26
- 3 min
Install SQL Server 2022 on Windows
This article guides you in installing SQL Server 2022 preview.
807 views0 comments
rajendra gupta
- May 18
- 2 min
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.
618 views0 comments
rajendra gupta
- May 13
- 3 min
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.
119 views0 comments
rajendra gupta
- May 5
- 1 min
T-SQL script to configure SQL Database for optimal VLF distribution
T-SQL script to configure SQL Database for optimal VLF distribution
109 views0 comments
rajendra gupta
- May 4
- 2 min
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
468 views0 comments
rajendra gupta
- May 3
- 2 min
Read Session-Specific data from the memory-optimized temp tables
Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
96 views0 comments