Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
5 easy ways to protect SQL Server against Ransomware attacks
16 May,2017 by Tom Collins
Ransomware and how to recover files from ransomware have been a hot topic this week. High profile attacks on NHS computers have escalated the awareness of virus attacks. It’s not the first there have been ransomware attacks, who remembers Cerber ransomware which stopped database processes to access datastores to encrypt data?
Most SQL Server DBAs are generally paranoid about access to data. Increased awareness, applying sql server security best practises and regular reviews\audits help greatly in maintaining solid security and minimising attacks. Regular Security Risk Analysis and database security check can offer a good insight to fixes
These are 5 SQL Server security basics. Ransomware attacks are appearing regularly - with a wide range of attacks from brute force password checks to encrypting files
- Monitor for failed logins on your Servers;Powershell and Failed Logon attempts
- Avoid using TCP/IP port 1433 . Read more on SQL Server Security Policy
- Strong passwords for the Service Accounts and sa . For example: 3273aa!xxcR
- Regular Full Backups. Script to check if a SQL database has a backup
- Password protect the backups
Although we’ve been discussing SQL Server , ultimately SQL Server is under great risk if the server Administrator account is revealed. Server security is just as important , work with the security team to make sure all precautions are in place
Read more on How To Automate SQL Server Vulnerability Assessment & Why promoting failure can increase Resiliency
More reading on securing SQL Server
Database Security Countermeasures against hacker attacks (SQL ...
SQL Server Security Violations Report for t-sql tuesday (SQL
SQL Server - Security Risk Analysis and database security (SQL ...
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |