Author: Vyas Kondreddi
-
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 get discounts on Microsoft Surface devices like laptops, accessories and extended warranties?
Microsoft’s own Surface range of devices have always been expensive, but they do offer a premium Windows experience. Surface devices offer the best in terms
-
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
-
Are you a system administrator? Worried about high memory usage on your SQL Server host? Read on!
Quite often, I get approached by Windows SAs or system administrators in my organisation, saying that my SQL Server host is using too much memory
-
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
