User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
Understanding SQL Server Lockdown to Secure Database Environment
Security is the main concern these days in every sector. Database Security is also a major worry for any customer. SQL Server is designed...
SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro
Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And...
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
SQL Server System Databases – Restore System Databases
In the previous articles of the SQL Server System Databases series, we have learnt the purpose of all SQL Server System databases that...
MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management
In the previous articles of the SQL Server System Databases series, we have gone through the System...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
How to Comment MySQL Code: Best Practices
Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when...
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...