434 reputation
717
bio website
location
age 35
visits member for 2 years, 11 months
seen Aug 19 at 17:49
  • My Online C#5 spec — My colored clarified version.
  • NG-print — Use it to print the angularjs documentation.
  • Code Liner — Use it to paste code with line numbers to reference by you or by others.
  • signalR-print — Use it to print the signalR documentation. ------don't use , need to fix it.

Dec
10
asked Get the windows account which runs the query?
Dec
7
awarded  Popular Question
Dec
4
comment Separate stored procedures for inserts and updates?
Sorry ! of yours ! (InsertOrUpdateYourTable )
Dec
4
comment Separate stored procedures for inserts and updates?
isnt the first query of mine is quicker ?
Dec
4
comment Separate stored procedures for inserts and updates?
Thank you very much Martin.
Dec
4
accepted Separate stored procedures for inserts and updates?
Dec
4
comment Separate stored procedures for inserts and updates?
Can you please elaborate how upsert will look like ?
Dec
4
comment Separate stored procedures for inserts and updates?
@MartinSmith it could be IDENTITY - but then , it will be used for : scope_ident ( for insert) , or by id (for update).
Dec
4
comment Separate stored procedures for inserts and updates?
@ypercube Thanks for helping :-)
Dec
4
asked Separate stored procedures for inserts and updates?
Nov
26
awarded  Yearling
Nov
26
comment Understanding SQL Server encryption (by password)?
can anyone please help me finding an example of Automatic Key Decryption ? I've searched. didnt find .
Nov
26
accepted Shrink my .mdf file in SQL Server?
Nov
26
comment Understanding SQL Server encryption (by password)?
Thanks for replying. Where can I find a decent example for "Automatic key decryption" ?
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