Prevent database file from copying
I am working in a product based company and will
provide SQL Server express 2014 edition with our software.
I want your expert comment on database security.
As we are installing a database on client PC then they
might be able to clone our system by attaching MDF files to another
(In my view, through database objects name and data, other companies can easily
identify our workflow and can develop software easily)
So I want some type of encryption or file system
solution to prevent user to take database files. And yes as we are using
express edition, we can't use available SQL server options.
I am using simple
.net transaction (C# code using ado.net data reader and stored procedure) to
delete some records I provided 30 seconds’ transaction timeout period.
But my stored
procedure takes more than 30 seconds in large records case, I am using try – catch
block to handle transaction.
data case when transaction rollbacks, rollback process again facing timeout because
rollback process taking more than 30 seconds due to complex data table relations
(multiple foreign keys constraints)
1. How to handle this new rollback timeout issue without increasing transaction main timeout
(30 seconds), we need to wait till full rollback completes.
2. In rollback timeout situation database is in complete
blocked situation I am not able to execute SP_Who2 also.
two main issues, other minor issues are,
1. In above situation, what happens to executed
SP after timeout is it still in running state or paused.
2. How we can minimize transaction rollback time?
Please provide your valuable solution
with .net and SQL server
Some simple and quick steps for sql server database performance tuning