150 reputation
8
bio website wp7agile.wordpress.com
location United Kingdom
age 35
visits member for 5 years
seen Jan 14 at 11:11

Senior .NET developer. ASP.NET MVC. Windows Phone 8. Window 8. Windows Azure. SQL Server.

Blogs
http://wp7agile.wordpress.com/
http://karpcom.blogspot.com/
http://twitter.com/360AgileWeb
http://wp7agile.azurewebsites.net


May
21
awarded  Caucus
Oct
15
awarded  Teacher
Jul
19
comment add certificate to all files in EFS-folder with script
I have a similar problem, I am looking at ways of automating/scripting the creation of Data Recovery Agent (DRA) via powershell or cmd?
Jun
25
awarded  Quorum
Jun
6
comment What is a good SSH server to use on Windows?
Tried this one and it works!!! Was testing some c# SSH local file upload code
Apr
13
asked SQL Server instance seems hung, restarting state shows 'change pending…'
Sep
23
awarded  Autobiographer
Jun
30
answered DAC connection port SQL Server 2005 SP3
Jun
30
asked What really is DAC - Dedicated Administrator Connection in SqlServer 2005
Jun
28
awarded  Editor
Jun
28
revised Sql Server 2005 Memory Management - Server Properties (Memory Page)
Added details
Jun
28
asked Sql Server 2005 Memory Management - Server Properties (Memory Page)
Nov
6
asked Creating CLR Assembly in SQLServer 2005
Oct
21
comment Mapping printers using Group Policy Preferences; works on Windows XP, not on Windows 7 x64
what exactly do you mean in '.. and my UAC settings are untouched' Have you disabled UAC?
Oct
10
awarded  Supporter
Aug
29
accepted Sql Server - Error attaching mdf file encrypted via Encrypted File System (EFS)
Aug
29
comment Sql Server - Error attaching mdf file encrypted via Encrypted File System (EFS)
For the benefit of the community, I found out the cause of this issue as follows: 1. Detaching/Attaching the database uses the currently logged on user. 2. Encrypting/Decrypting db files uses the sql server service account 3. So if the currently logged on user is a different account to that of the sql server service, clearly there will be an error trying to attach the database because the files were encrypted via account (EFS works like that) 4. To resolve, use the same account to encrypt and attach
Aug
29
answered Sql Server - Error attaching mdf file encrypted via Encrypted File System (EFS)
Aug
26
awarded  Scholar
Aug
26
accepted Migrating from Sql Server Express 2005 to express 2008