138 reputation
6
bio website codepal.co.uk
location Skipton, United Kingdom
age
visits member for 1 year, 3 months
seen Feb 19 at 10:17

Feb
19
awarded  Popular Question
Sep
21
comment Scheduling duplication of two tables across instances
Do you mean a SQL instance on a Virtual Machine? I looked at that but costs were pretty steep for an always-on solution...
Sep
20
comment Scheduling duplication of two tables across instances
Thanks. No replication support is a painful thing to hear...! Is there a release date on SQL Data Sync? The last update was December 2012! I'm going to have a look at SSIS over the next few days. I thought that with replication I could always have a perfect mirror on the second instance, but I might have to settle for scheduling SSIS packages instead which isn't as attractive sadly...
Sep
19
awarded  Commentator
Sep
19
comment Scheduling duplication of two tables across instances
Every so often I do a full backup, then log backup, then shrink the log file. I assume that anything outstanding for replication at this point would be forced to the subscribing server?
Sep
19
comment Scheduling duplication of two tables across instances
Great articles, I'm just working through them now. Thanks.
Sep
19
asked Scheduling duplication of two tables across instances
Sep
3
comment Imitate 'dynamic' columns in SQL Server
Thanks for that. I've just stumbled upon this useful post which talks about dynamic form creation, which is very helpful and seems fairly straightforward. Not sure if you have anything to warn about it's content? stackoverflow.com/questions/792278/…
Sep
3
comment Imitate 'dynamic' columns in SQL Server
Thanks Rex, that's very helpful. We're not actually using EntityFramework; just simple webapps plus SQL stored proc's. I've just read on MSDN actually that SqlVarient might not work for us, because we may need to store nvarchar(max). That's a pain... :-(
Sep
3
asked Imitate 'dynamic' columns in SQL Server
Jul
17
awarded  Supporter
May
14
awarded  Editor
May
14
revised SQL Server service shutdown due to 'bad?' SSL cert
added 6 characters in body
May
14
comment SQL Server service shutdown due to 'bad?' SSL cert
No. Rebooting actually caused the problem as at this point the SSL data could not be read and SQL Server refused to start. I actually stopped using this SSL cert so never properly resolved the problem, although I do see that permission needs to be given on the cert for the SSL engine to read it, however, without detailed instructions for Win2012 I'm not brave enough to try it. I can't afford to have SQL shut down in case it fails :-\
Mar
14
comment SQL Server service shutdown due to 'bad?' SSL cert
So is it possible to give an MSA access to a certificate?
Mar
14
comment SQL Server service shutdown due to 'bad?' SSL cert
This blog post thesqldude.com/2011/08/03/… mentions adding the SQL Server user group account to the cert's permission list, however, it doesn't like the instructions are quite valid for Win2012 as I don't see that user group in my options. My SQL Server runs under the NT Service\MSSQLSERVER account, so perhaps I should give that read-permissions on the certificate under the 'Private Keys' option?
Mar
14
comment SQL Server service shutdown due to 'bad?' SSL cert
Yes this is looking like what's happened. For info, the option to force encryption was set two months ago, with a fresh self-signed cert applied to the next dialog option. There was never a problem until this morning, so perhaps it never worked and we weren't aware until today...?
Mar
14
comment SQL Server service shutdown due to 'bad?' SSL cert
Certificate subject is "elea1.memset.net" and the FDQN of SQL Server is "elea1" (well that's what's at the top of the Object Explorer - please advise if I can get more info elsewhere). We've never connected to SSMS externally even though it was set up to use SSL.
Mar
14
asked SQL Server service shutdown due to 'bad?' SSL cert
Jan
17
awarded  Scholar