162 reputation
17
bio website
location Yorkshire
age
visits member for 2 years
seen Jan 14 at 11:19

"Shop Smart; Shop S-Mart"


Jan
12
comment Can I use Backup/Restore to clone a database? Running out of ideas
Lovely, thank you. I still vote to keep this question open from the "duplicate" as it avoids people having to separate the relevant data (and a nice clean example of code) from the noise that surrounds it.
Jan
12
accepted Can I use Backup/Restore to clone a database? Running out of ideas
Jan
12
comment Can I use Backup/Restore to clone a database? Running out of ideas
Thanks Kenneth. I assume this also won't affect the restoring state of the original database?
Jan
12
comment Can I use Backup/Restore to clone a database? Running out of ideas
That question deals with multiple instances, or the requirement for. Also experts are clearly warning against production server usage with the solution, of which this is a production machine.
Jan
12
asked Can I use Backup/Restore to clone a database? Running out of ideas
Dec
2
awarded  Notable Question
Sep
24
awarded  Autobiographer
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/…