140 reputation
6
bio website
location Yorkshire
age
visits member for 1 year, 7 months
seen 4 hours ago

I'd rather be playing Monkey Island 1


Aug
14
accepted Change code editor variable highlighting colour
Aug
14
comment Change code editor variable highlighting colour
You nailed it! Yes, its based on Selected Text, but shows a lighter shade of that respective colour. Frustrating that it can't be referenced directly! Anyhow, I set the option to Automatic and it produces a fairly subtle (but easy-to-see) blue. I consider that a success! Thanks very much and keep up the excellent work!
Aug
14
revised Change code editor variable highlighting colour
added 101 characters in body
Aug
14
comment Change code editor variable highlighting colour
Hi Aaron. I was more referring to the highlighting that occurs when you click on a variable, and SSMS highlights all other occurrences of that variable in scope. You're setting does work, but then SSMS loses the ability to highlight scope variables. Is that expected behaviour? BTW I read your blog yesterday on OUTPUT VS SELECT VS RETURN - excellent article!
Aug
13
asked Change code editor variable highlighting colour
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?