Click here to Skip to main content
15,904,817 members
Home / Discussions / Database
   

Database

 
AnswerRe: Any good tool (free) for DB Schema? Pin
Richard MacCutchan14-Aug-20 1:44
mveRichard MacCutchan14-Aug-20 1:44 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 1:45
mveSandeep Mewara14-Aug-20 1:45 
GeneralRe: Any good tool (free) for DB Schema? Pin
Jörgen Andersson14-Aug-20 3:24
professionalJörgen Andersson14-Aug-20 3:24 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 3:39
mveSandeep Mewara14-Aug-20 3:39 
QuestionMS SQL Database Breach Pin
Otekpo Emmanuel13-Aug-20 4:03
Otekpo Emmanuel13-Aug-20 4:03 
AnswerRe: MS SQL Database Bridge Pin
Richard MacCutchan13-Aug-20 4:14
mveRichard MacCutchan13-Aug-20 4:14 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:02
Otekpo Emmanuel13-Aug-20 5:02 
AnswerRe: MS SQL Database Bridge Pin
Richard Deeming13-Aug-20 4:18
mveRichard Deeming13-Aug-20 4:18 
Make sure your database server is behind a firewall, and is not exposed to the internet.

Review all of your code for SQL Injection vulnerabilities, which is the most likely culprit.
Everything you wanted to know about SQL injection (but were afraid to ask) | Troy Hunt[^]
How can I explain SQL injection without technical jargon? | Information Security Stack Exchange[^]
Query Parameterization Cheat Sheet | OWASP[^]

Stop storing passwords insecurely.
Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

In terms of recovery, you'll need to restore your databases from the last known-good backup before the databases were defaced. You'll also need to notify all of your users of the data breach, and notify your local data protection controller. You may also need to prepare to pay a large fine if any of your users are covered by GDPR or similar legislation.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:01
Otekpo Emmanuel13-Aug-20 5:01 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:19
Otekpo Emmanuel14-Aug-20 5:19 
GeneralRe: MS SQL Database Bridge Pin
Richard Deeming14-Aug-20 5:38
mveRichard Deeming14-Aug-20 5:38 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:56
Otekpo Emmanuel14-Aug-20 5:56 
QuestionAws lamda Pin
Member 1490095628-Jul-20 2:16
Member 1490095628-Jul-20 2:16 
AnswerRe: Aws lamda Pin
CHill604-Aug-20 3:02
mveCHill604-Aug-20 3:02 
AnswerRe: Aws lamda Pin
MichaelFern15-Sep-20 2:19
MichaelFern15-Sep-20 2:19 
QuestionNeed a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 9:45
simpledeveloper21-Jul-20 9:45 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 10:28
mveRichard MacCutchan21-Jul-20 10:28 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
simpledeveloper21-Jul-20 11:57
simpledeveloper21-Jul-20 11:57 
GeneralRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard MacCutchan21-Jul-20 21:30
mveRichard MacCutchan21-Jul-20 21:30 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Eddy Vluggen21-Jul-20 10:35
professionalEddy Vluggen21-Jul-20 10:35 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
W Balboos, GHB21-Jul-20 11:01
W Balboos, GHB21-Jul-20 11:01 
AnswerRe: Need a script, SDF or UDF for checking the following conditions and make IF Else in a stored procedure SQL Server Pin
Richard Deeming21-Jul-20 23:25
mveRichard Deeming21-Jul-20 23:25 
QuestionHow to optimize Hash Match aggregation in SQL Server execution plan Pin
kali siddhu17-Jul-20 0:38
kali siddhu17-Jul-20 0:38 
AnswerRe: How to optimize Hash Match aggregation in SQL Server execution plan Pin
Eddy Vluggen21-Jul-20 10:44
professionalEddy Vluggen21-Jul-20 10:44 
QuestionDead lock issue with Update and delete statement on the same table Pin
kali siddhu14-Jul-20 23:37
kali siddhu14-Jul-20 23:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.