How to Get All SQL Server Error Codes and Messages Using T-SQL
When working with Microsoft SQL Server, understanding system errors is crucial for effective debugging and troubleshooting. SQL Server comes with…
Category: SQL Server
Fixing SQL Server SSL Error: The Certificate Chain Was Issued by an Untrusted Authority
When connecting to SQL Server, you might encounter this login error: “A connection was successfully established with the server, but…
How to connect to SQL Server in Power BI
SQL Server acts as a secure, high-performance backbone for business data, ensuring Power BI has accurate and up-to-date information to…
Oracle – How to Connect to Oracle Database Using SQL Developer
Oracle Database is a robust, enterprise-level relational database management system used worldwide for storing, managing, and retrieving structured data. It…
SSRS Performance Issue – Large SSRS report causing restart of server
Following things can be checked to resolve the issue: 1) Run the report query in SSMS and see whether it…
SSIS – Performance issue with SQL Sever Agent Job exeuting SSIS packages
Following are the suggestions: 1) If your SSIS server is shared instance then there could be possibility that your IO/memory…
SQL Server Issue – SQL Server Database struck in Recovery Mode
Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…
SSAS – Performance issue with Date Dimension
When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…
SQL Server – How to get a alert or notification if SQL Query is taking more than 5 mins
DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @duration INT –Capture timestamp for start of execution SET @StartTime = GETDATE() –…
SQL Server – How to reorganize indexes in SQL Server Database
Reorganizing the indexes consists of two processes 1) Detect the fragmentation: By using the system function sys.dm_db_index_physical_stats, you can detect…
SQL Server – Reason for stored procedure not returning any data
Following could be reason(s): 1) Multiple Exit Point in the stored procedure. We may have RETURN statement before stored procedure…
SQL Server High Availability – How to capture Server(s) status whether it is online or offline using T-SQL programming
Below is an example to capture Server(s) status whether it is online or offline. We are using XP_CMDSHELL extended stored…