Category: SQL Server Programming
This categoty contains all SQL Server programming related articles and posts
-
What is SQL Injection? How to prevent it? Examples, best practices, tips and tricks to safeguard your SQL Server databases
This article explains what SQL Injection is, how it works, with easy to understand examples. It also discusses the preventive measures you can take to defend against SQL Injection, along with security best practices, tips and tricks
-
How to check the last backup date of every database on your SQL Server?
This article provides a script to display the last backup date of all the database on your SQL Server. This covers the three main types of backups (full backup, transaction log backup and differential backup)
-
How to search all character columns of all tables in your database for a specific search string or keyword?
Have you ever had a need to search for a specific string across all the tables in your database? Surprisingly this does seem like a
-
How to monitor all the currently running SQL Server Backup and Restore operations in real time?
Imagine a scenario: You have a very busy non-production environment hosting dozens of databases. Lots of developers are actively using the server. They are backing
-
How to find the last restore date (when, from where, and to what point) of every SQL Server Database on your server?
Some non-production environments require copies of latest production databases for live testing, bug fixing and new code deployments. These environments have a current production database
-
How to generate simple or complex passowrds and numeric OTP codes using T-SQL?
Generating random passwords and One Time Passcodes (OTPs) is a pretty common requirement. I am sure you can find several different versions of T-SQL code
-
How to programmatically check if a port is open from within SQL Server?
As a DBA, you often provision a new database to a user or a team, and provide them with SQL Server connectivity details like the
Latest Articles


