Lots of videos below the fold. Most from VicFirth, but not all.
–jeroen
Archive for August 24th, 2020
Assorted unpitched concert percussion videos
Posted by jpluimers on 2020/08/24
Posted in LifeHacker, Music, Power User | Leave a Comment »
Small query for some SQL Server client and server information
Posted by jpluimers on 2020/08/24
Sometimes in a less paved SQL Server environment you need a quick way to gather information on both the client and server. I assembled this query from various sources to help with that. It runs with few privileges (hence the use of the various *property functions):
-- https://dev-doc.blogspot.com/2012/08/ms-sql-2008-client-ip-address-on-shared.html
-- https://blog.sqlauthority.com/2009/05/26/sql-server-find-hostname-and-current-logged-in-user-name/
-- https://blog.sqlauthority.com/2015/07/13/sql-server-how-to-change-server-name/
-- https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6720817d-120f-4099-bf0e-e97fd2e26848/how-to-get-host-name-and-sql-instance-name-by-tsql?forum=transactsql#fc9e6b84-0264-424a-8aef-d03b0de6fade
select
-- https://docs.microsoft.com/en-us/sql/t-sql/functions/connectionproperty-transact-sql?view=sql-server-2017
CONNECTIONPROPERTY('net_transport') AS net_transport,
CONNECTIONPROPERTY('protocol_type') AS protocol_type,
CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,
CONNECTIONPROPERTY('local_net_address') AS local_net_address,
CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,
CONNECTIONPROPERTY('client_net_address') AS client_net_address,
HOST_NAME() AS client_hostname,
SUSER_NAME() LoggedInUser,
@@servername AS 'ServerName\InstanceName',
-- https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-2017
SERVERPROPERTY('ServerName') AS 'ServerName',
SERVERPROPERTY('MachineName') AS 'Windows_MachineName',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered',
SERVERPROPERTY('Edition') AS 'Edition',
-- https://docs.microsoft.com/en-us/sql/t-sql/functions/version-transact-sql-configuration-functions?view=sql-server-2017
@@Version as 'Full_Server_Version'
;
Based on parts from:
- [WayBack] Заметки разработчика: MS SQL 2008: Client IP address on shared hosting
- [WayBack] SQL SERVER – Find Hostname and Current Logged In User Name – SQL Authority with Pinal Dave
- [WayBack] SQL SERVER – How to Change Server Name? – SQL Authority with Pinal Dave
- [WayBack] How to get Host name and SQL Instance Name by T-SQL
Features used:
- [WayBack] CONNECTIONPROPERTY (Transact-SQL) | Microsoft Docs
- [WayBack] HOST_NAME (Transact-SQL) | Microsoft Docs
- [WayBack] SUSER_NAME (Transact-SQL) | Microsoft Docs
- [WayBack] SERVERPROPERTY (Transact-SQL) | Microsoft Docs
- [WayBack] @@VERSION (Transact-SQL) | Microsoft Docs
–jeroen
Share this:
Posted in Database Development, Development, SQL Server | Leave a Comment »
Some awesome Sugru moldable glue links
Posted by jpluimers on 2020/08/24
Suguru is a moldable glue that cures (settles/hardens) because of moisture and temperature (see the [WayBack] tech PDF.
Keeping it longer than the standard 13 month shelf life (at room temperature in original packaging) works best in a moist free, cold environment.
It is excellent for doing some cable repair (especially for those pesky expensive USB-C, lightning, magsafe 2 or magsafe connectors of which the middle 2 are most prone to damage).
It glues best to hard surfaces, though the materials it glues to varies (see also the tech PDF).
Some more links:
- [WayBack] Sugru – How to Make Your Own DIY Sugru Sachet / Save Left Over Sugru: iron (parts of) the original package on a steel surface.
- [WayBack] Sugru – How to seal your packets for re-use – ToolGirl Mag Ruffman’s Official Web Log
- [WayBack] FAQ | Sugru
- Keep best in the fridge (or even better: freezer)
- [WayBack] FET Tricks: Sugru Good After 3 Years in the Freezer!
Via: [WayBack] Welk vakantiegadget raad jij je medetweaker aan? – IT Pro – .Plans – Tweakers
–jeroen
Share this:
Posted in LifeHacker, Power User | Leave a Comment »
Some more interesting OpenWrt capable routers/ATAs
Posted by jpluimers on 2020/08/24
Interesting devices running OpenWrt:
- [Archive.is] MTK MT7621 Enterprise Wireless Router Sata LTE 4G WIFI OpenWrt MT7603 MT7612 Gigabit MT7621A chipset Sim Card PCBA ODM OEM Board-in Wireless Routers from Computer & Office on Aliexpress.com | Alibaba Group
- [WayBack] +Ubiquiti Networks EdgeRouter X is an affordable 5-port Gigabit Ethernet router officially supported by +OpenWrt. https://www.cnx-software.com/2018/05/… – Jean-Luc Aufranc – Google+
- [WayBack] Cisco SPA122 ATA with Router – Cisco via [WayBack] New #Insentricity post: Unlocking a SPA122 so that it can be used with your own Asterisk server. – Chris Osborn – Google+
–jeroen
Share this:
Posted in Internet, Power User, routers | Leave a Comment »
The Wiert Corner - irregular stream of stuff 