Tag: sql server

SUBSTRING Command in SQL: A Primer

SQL Server

Similar to my article regarding the SQL Server STUFF command, today we will be examining the...
Read More

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Read More

Primary Keys in SQL Server

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely....
Read More

SQL Server Triggers – Part 2 DDL & LOGON Triggers

Database development, Triggers

In SQL Server, triggers are database objects which will get executed whenever a triggering event...
Read More

SQL Server Triggers: DML Triggers

Database development, Triggers

In SQL Server, triggers are database objects which get executed whenever a triggering event happens on the database or server. Triggers...
Read More

What is SQL Server? (Definition, Versions, Editions)

Database administation, Database development

Excited? That’s how it feels to learn a new skill on your first day. It can also feel a bit overwhelming. You have lots of questions. You...
Read More

How to Read and Interpret SQL Errors

Troubleshooting Issues

Error codes in SQL are generated by the server to provide information about what has gone wrong....
Read More

SQL Server User-defined Functions

Database administation, Database Optimization & Structure

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
Read More

WhoIsActive Runner

Database development, Stored Procedures

Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very least have heard of, the famous stored...
Read More

How to Setup SQL Server on the Amazon RDS

AWS, Cloud, SSMS, Tools & technologies

SQL Server is one of the most popular databases used in modern applications. Over the past few...
Read More
Close