Click here to Skip to main content
14,884,084 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
mvaSandeep 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
mvaSandeep Mewara14-Aug-20 3:39 
QuestionMS SQL Database Breach Pin
Otekpo Emmanuel13-Aug-20 4:03
MemberOtekpo 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
MemberOtekpo 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
MemberOtekpo Emmanuel13-Aug-20 5:01 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:19
MemberOtekpo 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
MemberOtekpo Emmanuel14-Aug-20 5:56 
QuestionAws lamda Pin
Member 1490095628-Jul-20 2:16
MemberMember 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
MemberMichaelFern15-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
Membersimpledeveloper21-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
Membersimpledeveloper21-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
mveW 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
Memberkali 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
Memberkali 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.