409 reputation
613
bio website
location
age 35
visits member for 2 years, 7 months
seen Apr 9 at 9:35
  • NG-print : Use it to create pdf for the angularjs documentation.
  • Code Liner : Use it to paste code with line numbers to reference by you or by others.
  • CanIUse 3 : Use it to quickly check browser compatibility in the most 2 popular ways.

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
Oct
21
comment SQL Server symmetric key & certificates games by Hacker?
what is the sql permission name required for 'open symetric key ' && use the certificate ?
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
'using an account that has permission to query the data' you mean the SELECT * FROM sys.symmetric_keys query ?
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
Thank you very very very much. Eof.
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Rick If I used certificate , The hacker can see wheich certificates are installed , and by the code : OPEN SYMMETRIC KEY MySymetricKey DECRYPTION BY CERTIFICATE MyCertificate he can see the real data...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
@Rick all day long ive been practicing on this page and therefor i had some conceptual questions...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
but If I used certificate , The hacker can see wheich certificates are installed , and by the code : OPEN SYMMETRIC KEY MySymetricKey DECRYPTION BY CERTIFICATE MyCertificate he can see the real data...
Oct
20
comment SQL Server symmetric key & certificates games by Hacker?
I wish to thank you a lot. ( if i'll have more advanced sql question i'll ask you directly :) ) . thanks.