Tag: How to
This tag groups together all the SQL Server “How to” artciles.
-
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)
-
SQL Server Orphan Users and Logins – how to prevent and manage them, and the gotchas to be aware of
This article discusses what are SQL Server orphan user and logins, how to prevent users and logins getting orphanned, and how to manage them. It also talks about the security risks associated with orphan AD/Windows groups.
-
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 use sys.dm_io_virtual_file_stats to check the disk read and write performance of your SQL Server?
When it comes to checking how well the disks are performing on your SQL Server, sys.dm_io_virtual_file_stats is your best friend. This Dynamic Management View (DMV)
-
sp_WhoIsActive – What is it? How to deploy & configure it? How to maintain the collected data?
If you’ve been an SQL Server DBA for a while, chances are you are already familiar with sp_WhoIsActive, a comprehensive, free, lightweight stored procedure developed
-
How to check the correct Windows Defender antivirus (AV) exclusions are in place for SQL Server?
Most enterprises run some sort of Antivirus or endpoint protection software on their servers including on SQL Server estates. The software choice depends on things
-
How to send email for free, from SQL Server using Database Mail feature?
You can use the Database Mail feature of SQL Server to send emails. Thesse can be ad hoc emails, or could be sent from within
Latest Articles


