If you are BI based and want to meetup with other in London, whether technical or business based here as some contacts.
https://sqlserverfaq.com/ – General sql server (covers lots of usergroups)
http://sqllondon.pass.org/ – London SQL Pass Chapter for SQL Server but BI people do attend as well.
https://www.meetup.com/London-PUG/ London Power BI Users Group – they meet at Skills Matter, 10 South Place near Moorgate tube, big group, lots of people attend – 50+,
https://www.meetup.com/London-Business-Analytics-Group/ – London Business Analytics Group – Very power user/Business based, less technical
To run SSMS remotely:
runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”
runas /netonly /user:WIN-P9OQ9GF24HV\justdave “C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe”
db2look -m -r
The “-r” option is used to generate db2look output without runstats command output. However, current db2look code cannot reset SYSSTAT.COLUMNS and SYSSTAT.INDEXES when -r is applied. As a result, SQL1227N sometimes occur when applying the mimic when COLCARD etc, and CARD for the table is inconsistent. In db2look up to version in V10.5 please use db2look -m without -r option or insert resetting SYSSTAT.COLUMNS and SYSSTAT.INDEXES manually in db2look output with “-m” and “-r”. This limitation will be changed in releases later than V10.5. In most cases it should not cause SQL1227N error, but still the error can occur when the statistics on the source system is inconsistent. Here are examples:
Why COLCARD is sometimes bigger than CARD after RUNSTATS?
Runstats may update unexpected HIGH2KEY and LOW2KEY statistic values which may cause SQL1227N
As documented in above technotes, you can bypass the error by setting following undocumented registry variable even if the statistics are inconsistent:
recycle the instance
This registry variable can be used from 9.7FP9/10.1FP4/10.5.
To run .NET Runtime Optimization Service:
schTasks /run /Tn “\Microsoft\Windows\.NET Framework\.NET Framework NGEN v4.0.30319 64”
export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu’ -c ‘nnoremap i <nop>’ -”
export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -”
For gnu man:
export MANPAGER=”/bin/sh -c \”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -\””
Monitoring and Tuning the Linux Networking Stack: Receiving Data
Some notes on the Oracle APPROX_COUNT_DISTINCT Function
Scaling up Cardinality Estimates in 126.96.36.199
HyperLogLog in Oracle
HyperLogLog — Cornerstone of a Big Data Infrastructure