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...
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 that’s what SQL ORDER BY is for. Use...
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...
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 Databases that are installed by default...
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...
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 least have heard of, the famous stored...
ML{.NET} Introduction
Machine Learning (ML) has come from a buzzword that is nice to have in your application to a must-have feature that works and adds value....
Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...