SQL 2/7

Different ways to check the last Restart time of SQL Server

Nov 16, 20221 min read

Different ways to check the last Restart time of SQL Server

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

7,088 views0 comments

T-SQL script to Measure Transactions Per Seconds in SQL Server

rajendra gupta

Nov 14, 20221 min read

T-SQL script to Measure Transactions Per Seconds in SQL Server

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

2,878 views2 comments

rajendra gupta

Nov 8, 20222 min read

Explore SQL EXCEPT statement

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

204 views3 comments

SQL Server UPDATE from a SELECT statement

rajendra gupta

Nov 7, 20222 min read

SQL Server UPDATE from a SELECT statement

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

193 views0 comments

Aug 3, 20221 min read

SQL Server 2022 version list

145 views0 comments

Aug 3, 20223 min read

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.

8,786 views7 comments

Jul 25, 20224 min read

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.

308 views1 comment

Jul 24, 20221 min read

SQL Server 2022 STRING_SPLIT Function

3,518 views0 comments

Jul 12, 20224 min read

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

12,381 views0 comments

Jul 12, 20221 min read

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

5,190 views0 comments

Jul 12, 20221 min read

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

19,125 views0 comments

Jul 9, 20222 min read

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.

263 views0 comments

Jul 8, 20221 min read

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.

24,182 views0 comments

Jul 8, 20221 min read

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

10,669 views0 comments

Jul 5, 20222 min read

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,

82 views1 comment

Jul 5, 20221 min read

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

10,167 views0 comments

Jun 30, 20222 min read

SQL Server Extended Events to track PAGE SPLITS in SQL Database

668 views0 comments

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,397 views0 comments

May 26, 20223 min read

Install SQL Server 2022 on Windows

This article guides you in installing SQL Server 2022 preview.

4,085 views0 comments

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