SQL Server Triggers – Part 2 DDL & LOGON Triggers
In SQL Server, triggers are database objects which will get executed whenever a triggering event...
SQL Server Triggers: DML Triggers
In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Drop Temp Table in SQL Server and PostgreSQL
This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
What is SQL Server? (Definition, Versions, Editions)
Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit...
How to Read and Interpret SQL Errors
Error codes in SQL are generated by the server to provide information about what has gone wrong. They have different meanings depending on...
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
How to Use the sp_whoisactive PowerShell Script for Real-Time SQL Server Monitoring
Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very...
How to Setup SQL Server on the Amazon RDS
SQL Server is one of the most popular databases used in modern applications. Over the past few decades, it has established itself as a...
Introduction to Synonyms in SQL Server
A synonyms in SQL Server are database objects that give an alternative name to the database objects existing locally or on the remote...
Top-10 SQL Server Management Studio (SSMS) Add-ins You Should Use in 2021
If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL...
