Knowing when your SQL Server instance was last started can be helpful for various reasons. In this tip, we will explore a few methods you ca

Learn how to measure transactions per second in SQL Server with this quick and easy guide. We'll show you step-by-step how to get started so

The SQL EXCEPT statement is used to compare two tables and find the differences between them. In this article, we'll show you how to use the

Updating data in a SQL Server database can be done in many ways. One way is to use the UPDATE statement along with a SELECT statement. This

SQL Server 2022 version list

Having trouble installing SQL Server 2022 on Ubuntu? Follow our 5-minute guide and get SQL Server up and running on your Ubuntu machine.

This article explores the coalesce function in SQL Server that SQL uses to manipulate strings with NULLs in SQL Server.

SQL Server 2022 STRING_SPLIT Function

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

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

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

CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.

This article helps you to fix SQL Server Error: 18456, Severity: 14, State: 38, Reason: Failed to Open the Explicitly Specified Database.

Did you face the error - "VIEW SERVER STATE permission was denied on object 'server', database 'master' while executing the DMV. Read More

Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,

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

SQL Server Extended Events to track PAGE SPLITS in SQL Database

SQL Server 2022 can be used to sync up agent jobs, logins, and permissions automatically between primary and secondary replicas. Read More

This article guides you in installing SQL Server 2022 preview.

Troubleshooting SQL Server Error 9002 - The Transaction Log for Database is Full - Do you get error 9002? Read more for a handy guide.