Data Series: Platform: SQL Server - Microsoft Virtual Academy
series of videos about the history and features of MS SQL Server, by Marko Hotti, one of Microsoft's top SQL Server folks
videos  MSSqlServer 
1 hour ago
Ticketmaster recruits pros for secret scalper program
> "I have brokers that have literally a couple of hundred accounts," one sales representative said. "It's not something that we look at or report."
scalping  musicIndustry 
yesterday
Simple C# Web Server
~50 line ultra-simple web-server in C#, good for network testing when Python isn't available
C#  webDev  blogEntries 
yesterday
launching mssql-cli for local work on an EC2 instance
mssql-cli -U "EC2AMAZ-QQQQQQQ\Administrator" -E

Doesn't format well in PowerShell - use good old cmd
MsSqlServer  EC2  from notes
2 days ago
How To Set Up an SSL Tunnel Using Stunnel on Ubuntu | DigitalOcean
Deprecated, and pre-TLS, but looks like a good whirlwind tour.

Remember to 'accept = 0.0.0.0' not 127.0.0.1 on the server side, where we want to accept external connections

Another tutorial: https://redislabs.com/blog/stunnel-secure-redis-ssl/
security  networking  networkTunnelling  sysAdmin  Linux  stunnel 
2 days ago
How to get the system uptime in Windows? - Stack Overflow
Task Manager under Performance tab, or:
`systeminfo` and scan for "System Boot Time"
or, less helpful:
`net statistics server`/`net statistics workstation`
Windows  sysAdmin  StackOverflow 
2 days ago
where to find RabbitMQ server action shortcuts in Windows
C:\Users\myuser\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\RabbitMQ Server
RabbitMQ  from notes
3 days ago
How to change your keyboard layout on Windows 10
ignore the settings panels completely and press Windows + space
Windows10 
3 days ago
Tutorial 17.3 - Markdown and Pandoc
One of the few Pandoc example pages that shows the *actual* HTML result
Markdown  Pandoc 
4 days ago
stackalloc (C# Reference) | Microsoft Docs
Essentially alloca, right down to the unusual lifetime rule (method lifetime). Can only be used in 'unsafe' context.
C# 
5 days ago
SQL Graph Database - the new feature in SQL Server 2017 - SQLTerritory.com
Looks promising, but unfinished. No transitive closure yet, for instance.
SQLServer 
6 days ago
Configure custom SSL certificate for RDP on Windows Server 2012 in Remote Administration mode? - Server Fault
Worryingly difficult to find out how this is done. Remember not to waste time deleting the auto-generated cert, which will be regenerated.

Dig out the 'thumbprint' (SHA-1 hash) of the desired cert, place it in Computer > Remote Desktop *and* Personal (though I found that just Personal was enough), and run in PowerShell:

$path = (Get-WmiObject -class "Win32_TSGeneralSetting" -Namespace root\cimv2\terminalservices -Filter "TerminalName='RDP-tcp'").__path

Set-WmiInstance -Path $path -argument @{SSLCertificateSHA1Hash="cafebabecafebabe......."}
Windows  RemoteDesktop  certificateManagement  sysAdmin  WindowsServer 
6 days ago
GBAK Firebird Backup and Restore
To backup:

gbak.exe -B -T "c:\myFdb.fdb" "c:\myOutputFbk.fbk" -USER SYSDBA -PAS masterkey

To restore:

gbak.exe -C -T "c:\myFbk.fbk" "c:\myOutputFdb.fdb" -USER SYSDBA -PAS masterkey
FirebirdSQL 
10 days ago
Efficiency of Java "Double Brace Initialization"? - Stack Overflow
Java's "double brace initialization" syntax generates a 'secret' anonymous inner class. The horror!
Java  StackOverflow  discussion 
10 days ago
Why is my command prompt freezing on windows 10? - Stack Overflow
> The issue ended up being a new feature of the windows 10 console. Under the default config, whenever you click on a command window in windows 10, it immediately halts the application process when it attempts to write to the console.
badIdeas  badDefaults  Windows10  sysAdmin  commandLine  StackOverflow 
10 days ago
Technitium MAC Address Changer
Does not work with my Intel wi-fi chipset, Win10.

Version 6.0 does not seem to provide any way to uninstall
Windows  networking  sysAdmin 
14 days ago
Locks and exceptions do not mix – Lippert
>Recall that lock(obj){body} was a syntactic sugar for
>
>var temp = obj;
>Monitor.Enter(temp);
>try { body }
>finally { Monitor.Exit(temp); }
concurrentProgramming  blogEntries 
16 days ago
sql - Should I commit or rollback a read transaction? - Stack Overflow
SO seems to lean toward committing over rolling-back (but rolling-back guarantees no modification of the DB), but agrees that you should do exactly one of the two and 'not leave it hanging'
SQL  databaseProgramming  StackOverflow 
17 days ago
git-difftool Documentation [inc. "--extcmd" flag]
To use vimdiff just this once, do something like:

git difftool HEAD^ HEAD --extcmd="vim -d"
git 
18 days ago
how to stop rabbitmq servers - Stack Overflow
None of these worked for me. Had to reboot my entire Linux VM to get RabbitMQ to die.
RabbitMQ  StackOverflow 
22 days ago
where 'generic UNIX' build of RabbitMQ looks for rabbitmq.conf
Something like: /home/ec2-user/Downloads/rabbitmq_server-3.7.7/etc/rabbitmq/rabbitmq.conf

No, the file does not exist unless you create it, neither is there an example file in that directory.
RabbitMQ  from notes
23 days ago
compiling Erlang on Amazon EC2 Linux
To fetch dependencies not already shipped with the distro, run:

sudo yum install ncurses-devel openssl-devel flex-devel

then ./configure should be happy
Erlang  from notes
23 days ago
Useful openssl cert management commands
Generate private-key pem from PKCS12 PFX (without public key): openssl pkcs12 -in yourP12File.pfx -nocerts -out privateKey.pem

Cert, no private key: openssl pkcs12 -in yourP12File.pfx -clcerts -nokeys -out publicCert.pem

(from https://stackoverflow.com/a/9516936/ )

print detail of unencrypted pem: openssl x509 -in ./mine.pem -text -noout

(in Windows: certutil mycert.cer)
OpenSSL  certificateManagement  from notes
24 days ago
notes on exporting key-pairs from Windows' cert store (certmgr)
To export private key as well, you must export your newly-generated key-pair from 'Personal' folder, rather than from 'Intermediate Certificate Authorities' folder

It makes no odds whether you use `-CertStoreLocation Cert:\CurrentUser\My` or `-CertStoreLocation Cert:\LocalMachine\My` when invoking New-SelfSignedCertificate
Windows  certificateManagement  from notes
25 days ago
disregard rabbitmq.config.example
Remember that the rabbitmq.config.example file is garbage: it uses the obsolete syntax, and is not a valid config file
RabbitMQ  from notes
25 days ago
Windows: path of rabbitmq.conf
Remember that on Windows, the config file's path is %APPDATA\RabbitMQ\rabbitmq.conf
RabbitMQ  from notes
25 days ago
rabbitmq.conf **not** rabbitmq.config
Remember that the rabbitmq.config.example file is wrongly-named: RabbitMQ uses .conf and never .config
RabbitMQ  from notes
25 days ago
How to run RabbitMQ broker
To run RabbitMQ broker 'synchronously' in the command-line prompt, and to be shown config errors in case of errors, use: `./sbin/rabbitmq-server` (in Windows, it's a .bat)

To run RabbitMQ normally (in background) (silently fails in case of config errors) use `./sbin/rabbitmq-service start`
RabbitMQ  from notes
25 days ago
GVIM on windows: way to disable the tmp file creation - Stack Overflow
:e $MYVIMRC

then add the following lines:

set nobackup
set nowritebackup
set noswapfile
vim  StackOverflow  gvim  security  badDefaults 
25 days ago
Is it true that having lots of small methods helps the JIT compiler optimize? - Stack Overflow
As HotSpot is not trace-based, it seems it conceivably could. Profiling and compilation is at the method level, and no finer.
StackOverflow  Java  HotSpot  JIT  discussion 
26 days ago
jsoncompress
claims to out-compress the 'smile' compression scheme
JSON  compression 
4 weeks ago
about RabbitMQ's message metadata fields
also https://stackoverflow.com/a/18447385/ , https://stackoverflow.com/a/18457890/

> :reply-to
> Commonly used to name a reply queue (or any other identifier that helps a consumer application to direct its response). Applications are encouraged to use this attribute instead of putting this information into the message payload.

'Reply queueus' seems to be a significant pattern in message-brokering architectures.

Also note the special status of 'arguments'. Are they used for proper transaction arguments, or just for custom metadata? Seems safest just to use something like JSON with the body byte-array. https://stackoverflow.com/a/22867027/
RabbitMQ  messageBrokering 
4 weeks ago
MediaDrop
FOSS for HTML5 streaming video among other things
web  HTML5 
4 weeks ago
Threading in C# - Part 2 - Basic Synchronization
Block a thread until some number of Signal() calls made
concurrentProgramming 
4 weeks ago
Huawei was caught using a pro camera to fake smartphone photos (again) | Ars Technica
> The behind-the-scenes photos have been removed from the actor's Instagram page.

Problem solved!
Huawei  falseAdvertising  corporateMisbehaviour 
4 weeks ago
« earlier      
6502 advertising agileprogramming algorithms amazon amqp android antivirus apache apple asp.net assembly asynchronousprogramming authentication autoboxing aviation azure baddefaults badideas badregulation bash bittwiddling blockchain blogentries blogs bluetooth books boost bruceschneier bugs buildsystems c c# c++ c++11 c++17 cdns certificatemanagement characterencoding charity charts clang cloudcomputing codecs codingstandards combinatorics commandline commonlanguageinfrastructure compilers compression computerarchitecture computerscience concurrentprogramming concurrentprogrammingnightmares cookies copyright copyrightinfringement corruption cpus crime criticalsystems cron cryptography css cygwin d databaseconcurrency databaseprogramming databases databinding dataprotection datastructures datetimelibraries debugging democracy demoscene design designpatterns diet discussion dns dogs drm dynamicanalysis ebooks ec2 eff elmlang email endianness english englishlanguage environmentalism equifax erlang ethernet etymology eu exceptionhandling extremeprogramming facebook feminism filesending filesystems filetables films finalizers firebirdsql firefox firewalls fitness floatingpoint foreignfunctioninterface forth foss france freedomofexpression freesoftware functionalprogramming funny fuzzymatching garbagecollection gcc gdpr git github gmail go google googleamp grafana grammar graphicsprogramming graphite gui guidevelopment gvim hackernews hacks hardware health history hotspot html html5 http https iis imagecompression images intel inteltsx intermediaterepresentations interpreters io ip iphone ipv6 islam islamism java javafx javamemorymodel javascript jit json jvm keepaneyeon keyboardshortcuts language latex law lectures lexers libraries linux linuxkernel llvm lockfreeprogramming log4net logging machinelearning mathematics matrices memetics memorymanagement messagebrokering microsoft microsoftgraph microsoftoffice365 military minimalism mobileappdev mobileapps mongodb mozilla mssqlserver music mvvm mysql ncat netbeans netcat netflix networking networkscanning news nmap nosql ntfs oauth2 objectorientedprogramming odata office365 onhumour onprogramminglanguages opencl opengl openjdk opensource opensourcesoftware operatingsystems oracledatabase packagemanagement pakistan pandoc papers parallelprogramming parsing passwordmanagement pentesting philosophy philosophyofmind photography photos podcasts politics postgres powerarchitecture powerlifting powerpc privacy programming programminglanguages promises psexec psychology python qt rabbitmq raii readinglist reddit referencecounting regex relationaldatabases remoteaccesstools remotedesktop rest scalping science scripting scrum security serverfault serviceorientedarchitectures sexcrime sgx slashdot softwareengineering softwarelicensing softwareupdates soylentnews spam sql sqlserver ssh stackexchange stackoverflow staticanalysis streamorientedprogramming subscriptionvideoondemand svg syntacticsugar sysadmin syslog systemmonitoring talks taskparallelism tcp techhumour techpolitics telemetry telephony terrorism testing texteditors todo tpl tracking treedatastructures trustedcomputing tutorials typesystems uber udp uk undefinedbehaviour unicode unittesting unix urlshorteners usa usermodescheduling uwp vb.net versioncontrol video videoondemand videos vim violence virtualisation visualc visualstudio votingsystems vulkan wallpapers watchlist wcf web webapi2 webapis webbloat webbrowsers webdesign webdev webgl webm webservers webservices webstandards webutilities whitepapers windows windows10 windowsdevelopment windowsserver winforms words wtb x86 x86-64 xml youtube youtubevideos

Copy this bookmark:



description:


tags: