Reputation
459
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 7 18
Impact
~38k people reached

Sep
26
accepted Understanding MS SQL Server encryption and backups
Sep
26
comment Understanding MS SQL Server encryption and backups
HI , yes there is a password but in a previous stage. when I created by :CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'DB Master key password!' GO - I did created it with a password. but the strange thing is that when i open it - i dont need the password this is excatly the code youve pasted. This is the thing which I dont understand. If im a hacker - i dont care about the password used to create it. all I need to do is OPEN SYMMETRIC KEY MySymetricKey DECRYPTION BY CERTIFICATE MyCertificate` and there is NO password here. please correct me
Sep
26
asked Understanding MS SQL Server encryption and backups
Mar
31
accepted SYMMETRIC key & certificates role in sql server?
Mar
6
awarded  Supporter
Mar
6
comment Common Table Expression (CTE) benefits?
@jnk thanks.......
Mar
6
accepted Common Table Expression (CTE) benefits?
Mar
6
asked Common Table Expression (CTE) benefits?
Jan
10
comment Unable to locate database.mdf in production server
@user1079650 see my edit - change the value so you can see all files.
Jan
10
answered Unable to locate database.mdf in production server
Dec
29
comment Shrink my .mdf file in SQL Server?
I dont understand why this question was downrated . it is a valid question. if its bad practice - so the action is to responde why is it bad practice and not to downvote.... people dont know the meaning of downvote here...@marc_s ... was that you ? :)
Dec
29
comment Shrink my .mdf file in SQL Server?
,Im building a hash / scramble mechanism which takes a bak - hash it - and saves it. I really dont need to deal with the LDF here...
Dec
29
comment Shrink my .mdf file in SQL Server?
does 10240 is calculated or just a upper margin limit ? If I have 10 GB dB , What should i use ? is it in KB ? MB ?
Dec
29
comment Shrink my .mdf file in SQL Server?
@gbn ,Im building a hash / scramble mechanism which takes a bak - hash it - and saves it. I really dont need to deal with the LDF here...
Dec
29
comment Shrink my .mdf file in SQL Server?
DBCC SHRINKFILE(1, 10240) where is the db param goes here ?
Dec
29
asked Shrink my .mdf file in SQL Server?
Oct
27
awarded  Tumbleweed
Oct
25
awarded  Student
Oct
25
awarded  Scholar
Oct
25
awarded  Commentator