Reputation
541
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 7 22
Impact
~57k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Dec
4
asked Separate stored procedures for inserts and updates?
Nov
26
awarded  Yearling
Nov
26
accepted Shrink my .mdf file in SQL Server?
Nov
26
accepted Understanding SQL Server encryption (by password)?
Nov
26
comment Understanding MS SQL Server encryption and backups
@Remus can you please have a look in my new question ( very related) dba.stackexchange.com/questions/29287/…
Nov
26
asked Understanding SQL Server encryption (by password)?
Oct
13
awarded  Nice Question
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 ?