Contents Marriage Banns Marriage Bond Marriage License Marriage Application Consent Affidavit Marriage Contract or Settlement Marriage Certificate Marriage or Minister’s Return Marriage Register Newspaper Announcement The different types of marriage records that might be available for your ancestors, and the amount and kind of information they contain, will vary depending on location and time period, as ..

Read more

  On May 16, 1918 Congress passed an amendment to the Espionage Act of 1917,  This Amendment is known to history as The Espionage Act of 1918.  Here is the text:   Whoever, when the United States is at war, shall willfully make or convey false reports or false statements with intent to interfere with ..

Read more

MEN Adam – Adamh Aeneas/Angus – Aonghas Albert – Ailbeart Alexander/Alick/Sandy – Alasdair Allan/Alwyn/Aulay – Ailean or Amhlaidh Alpin(e) – Ailpean Alick/Alexander/Sandy – Alasdair Andrew – [Gille]Aindreas/Anndra Angus/Aeneas – Aonghas Archibald/Celistinus – Gille-Easbuig/Gillespic Archie – Eairdsidh Arthur – Art/Artair Ay/Hugh/Hugo/Odo/Otto/Eugene/Eugenius – Aodh or Uisdean or Eoghan Bartholomew – Parlan Benjamin – Bean Bernard – Bearnard ..

Read more

aka Setting up DBeaver for use with Redshift. Step by step  Setting up DBeaver for use with Redshift is not the most intuitive thing you’ll ever do. A common misconception is that since Redshift is (sorta) built on Postgres, then a Postgres driver is the correct choice. Alas, nope. Here is a quick how-to for setting up DBeaver correctly as possible for Redshift. Here’s the standard DBeaver opening screen Right-click on your Redshift connection and choose “Edit Connection (F4)” That will present you with ..

Read more

Windows doesn’t display your PC’s serial number anywhere in its interface, and neither do popular system information tools. But you can often find a PC’s serial number with a simple command, a peek in your BIOS, or on the hardware itself. Run the WMIC Command Open a Command Prompt window to get started. On Windows 10 or 8, ..

Read more

The authors argue that the basic length of both generations and turnings—about twenty years—derives from longstanding socially and biologically determined phases of life.[who?] This is the reason it has remained relatively constant over centuries.[80] Some have argued that rapid increases in technology in recent decades are shortening the length of a generation.[81] According to Strauss ..

Read more

Here’s the measurements that has been calculated for plastic tubing brass instruments. (Editor’s note: we can’t call ’em “hosaphones,” as that word has been, believe it or not, trademarked.) The formula for calculating the length of a tube, given that you want it to resonate at a specific frequency is as follows: The speed of ..

Read more

Here are various bits and pieces dating as far back as 1980.  Many have not aged well, but have been grouped here for historical purposes. The Renaissance Diaries, volume 1 (2002) Renaissance Redux, volume 2 (20..

Read more

This requires that metadata lock instrumentation be enabled. UPDATE performance_schema.setup_instruments SET ENABLED = ‘YES’ WHERE NAME = ‘wait/lock/metadata/sql/mdl’; Once that’s in place, you can do this: SELECT   ml.object_schema,   ml.object_name,   p.id,   p.user,   p.state,   ml.lock_type,   ml.lock_duration,   ml.lock_status,   p.time,   LEFT(p.info, 100) FROM   performance_schema.metadata_locks ml   JOIN performance_schema.threads ..

Read more

This is a step-by-step tutorial to install Python and Jupyter Notebook to Windows 10 (64 bit). Python 3.3 or greater, or Python 2.7 is required to install the Jupyter Notebook. Download Python 3.7.4 from “https://www.python.org/downloads/release/python-374/” url 2. Choose and select “x86–64 executable installer” for Windows 10–64 bit computer 3. Select location to save the executable ..

Read more

ContentsStep 1: Configure Kubernetes RepositoryStep 2: Install kubelet, kubeadm, and kubectlStep 3: Set Hostname on NodesStep 4: Configure FirewallStep 5: Update Iptables SettingsStep 6: Disable SELinuxStep 7: Disable SWAPStep 1: Create Cluster with kubeadmStep 2: Manage Cluster as Regular UserStep 3: Set Up Pod NetworkStep 4: Check Status of ClusterStep 5: Join Worker Node to ..

Read more

The Best Fancy Salsa Kendra Vaculin In case you were wondering, yes, we at Epicurious have already conducted a thorough taste test of mild, shelf-stable, store-bought salsas. In 2018, armed with 11 easy-to-find supermarket brands (and a ton of tortilla chips for dipping and scooping), the team thoughtfully snacked their way to a winning jar—Desert ..

Read more

Here is the standard mysqldump syntax I always use.  This dumps routines and triggers, does so in the most expeditious manner possible, and adds DROP xxxxx statements before all CREATE statements, just in case.  It also adds the FORCE parameter in case it runs into issues with views. The “xxxx” at the end can be ..

Read more

MySQL 8.x not only requires that the datadir be empty when initializing, but also the directory designated as the temp directory.  If the temp directory is not empty, the –initialize flag will not throw an error as it does if the datadir isn’t clean; rather, it will cause a “Data Dictionary initialization failed” message on ..

Read more

Clone Wars – Open source clones of popular sites 100+ open-source clones or alternatives of popular sites like Airbnb, Amazon, Instagram, Netflix, Tiktok, Spotify, Trello, Whatsapp, Youtube, etc. List contains source code, demo links, tech stack, and, GitHub stars count. Great for learning purpose! From https://gourav.io/clone-wars List of 100+ open-source clones Clone Demo Repo Tech ..

Read more

FFmpeg is a free and open-source collection of tools for handling multimedia files. It contains a set of shared audio and video libraries such as libavcodec, libavformat, and libavutil. With FFmpeg, you can convert between various video and audio formats, set sample rates, capture streaming audio/video, and resize videos. This tutorial walks you through installing ..

Read more

Chapter XXIV. “Peep o’ Day ” – Darkness Clearing Away – Advancement of Order – Returning Signs of Prosperity- The People Becoming Themselves Again – A Glance at Current Events up to the Present. The period about which I now write, was anticipated in the closing remarks of the last chapter. Several years elapsed before ..

Read more

Chapter XVIII. A Chapter of Biography – John Crosby – James M. Boiling – Rev. Hanson Lee, etc. JOHN CROSBY. Among the best and noblest of the citizens of Conecuh, during his career, was John Crosby. He came to the county from Chester District, South Carolina, in 1832, and settled, first, at the home owned ..

Read more

Chapter XII. Transportation and the Inauguration of Postal Routes- Navigation of the Conecuh River- Brooklyn- The First Post-Office- The Different Mail Lines Established. Products seek a market as the rivers do the sea. The productive yield from the virgin soil of Conecuh naturally sought an outlet, especially when as inviting a market as was Pensacola ..

Read more

PREFACE. About two years ago, it was suggested that the people of Conecuh take immediate steps toward the preparation of a history of their county. A society was formed bearing the title of “The Conecuh Historical Society” some interest was manifested, and after several meetings the author was requested to undertake the preparation of the ..

Read more

History Of Conecuh County, Alabama. Embracing A Detailed Record Of Events From The Earliest Period To The Present; Biographical Sketches Of Those Who Have Been Most Conspicuous In The Annals Of The County; A Complete List Of The Officials Of Conecuh, Besides Much Valuable Information Relative To The Internal Resources Of The County. BY Rev. ..

Read more

(from https://blog.billiongraves.com/2019/02/19/understanding-cemetery-crosses/) Understanding cemetery crosses can help us understand the faith of our ancestors. It can sometimes even help us discover their heritage and country of origin. Many American genealogists have discovered through DNA tests that the roots of their heritage are in Europe. European cultures have historically been rich in religious faith. Countless numbers ..

Read more

(from http://home.sprintmail.com/~cwhent/WilliamByrd.html) Any investigation of the music and life of William Byrd must depend heavily on the writings of E.H. Fellowes, Thurston Dart, Joseph Kerman, Craig Monson, Alan Brown, Richard Turbet and Philip Brett. Fellowes provided the first detailed account, which hasrecently been superseded by a new study by John Harley. Harley has revisited the ..

Read more

Our branch of the family remained in North Carolina for some time. By the time of William John Byrd (1704-1777, Dad’s 5th great grandfather) the Byrd clan was of some note in the Chowan and Halifax county areas of North Carolina. Both John Byrd Sr. (1732-1791, Dad’s 4th great grandfather) and George William Byrd (1730-1825, ..

Read more

The original Dewberry family in America descends from Peter De Berry (1619-1679, Dad’s 9th great grandfather). Peter seems to have been a pretty sharp fellow. To understand why, you must know a bit about French history. The DeBerry family was in fact a French family who were Protestant in their religion. Be aware of the ..

Read more

It always confused me that dad’s great grandfather, Stephen Talmadge Byrd, married his wife, Eugenia Mae Byrd, with her last name already being “Byrd.” I just always thought that was a mistake somehow. Well, it’s not. Stephen Talmadge married his 2nd cousin, once removed. It looks like this: Arthur Samuel is dad’s third great grandfather. ..

Read more

In attempting to use the mysqldump utility provided with MySQL 8.x against a 5.7 server, you may receive the following error message: mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, ‘$.”number-of-buckets-specified”‘) This is due to the INFORMATION_SCHEMA in 8.0 having more columns to support several new features in 8.x.  This error can be silenced by adding the ..

Read more

ContentsCommon SSH Configuration OptionsOrganizing your SSH configurationHow Does Agent Forwarding Work?ProxyJump for Multiple Hops This article will take a look at a few useful ways to modify your ssh_config file to achieve a greater degree of security and control. This post is not about server-side configuration via sshd_config, which deserves its own separate article. What ..

Read more

gron transforms JSON into discrete assignments to make it easier to grep for what you want and see the absolute ‘path’ to it. It eases the exploration of APIs that return large blobs of JSON but have terrible documentation. ▶ gron “https://api.github.com/repos/tomnomnom/gron/commits?per_page=1” | fgrep “commit.author” json[0].commit.author = {}; json[0].commit.author.date = “2016-07-02T10:51:21Z”; json[0].commit.author.email = “mail@tomnomnom.com”; json[0].commit.author.name ..

Read more

The latest enhancement in ProxySQL v2.0.0 is the native support of Galera Cluster. No more need to use an external script within the scheduler like explained also in this post of ours. This document will cover how to take an advantage of the new feature and integrate ProxySQL with Percona XtraDB Cluster to monitor galera ..

Read more

A man is flying in a hot air balloon and realizes he is lost. He spots a man down below and lowers the balloon to shout: “Excuse me, can you help me? I promised my friend I would meet him half an hour ago, but I don’t know where I am.” The man below says: ..

Read more

Things are being migrated from my professional website (rlbyrd.com) as time permits. For the time being, you can look here, where some of my works are ..

Read more

A sample service check, annotated:    host_name                       dbsrp2076                  <– name of server     service_description             SSH                        <– service being monitored     servicegroups                   PROD-ssh                   <– service groups     is_volatile                     0                          <– Does this service spontaneously start and stop (always 0 for “no”)     check_period                    24×7                       <– during what hours is this service checked?     max_check_attempts              10                         <– ..

Read more

Things are being migrated from my professional website (rlbyrd.com) as time permits. For the time being, you can look here. For family and friends, the full photo gallery is at https://photos.houseofbyrd.com. (Login..

Read more

This category is almost exclusively used for “find something interesting, forward it via email to your chapbook until you can properly edit and categorize it.” So, these aren’t the droids you’re looking for. Move along.         &nb..

Read more

This site will be periodically updated with stories, anecdotes, and other information regarding the following families and their branches hailing at some point from Alabama, primarily the Monroe, Conecuh, and Escambia county areas, ranging into Kentucky, North Carolina, Virginia, and Florida, although other localities are represented in the various branches and lines of the family: ..

Read more

What if Windows let you quickly access administrative tools, backup and restore options and other important management settings from a single window? If that sounds good, look no further than the so-called “God Mode.” What Is God Mode? No, God Mode doesn’t unlock any extra secret features in Windows or let you do any tweaking ..

Read more

After you configure all PXC nodes, initialize the cluster by bootstrapping the first node. The initial node should be the one that contains all your data, which you want to be replicated to other nodes. Bootstrapping implies starting the node without any known cluster addresses. If the wsrep_cluster_address variable is empty, Percona XtraDB Cluster assumes ..

Read more

SELECT u.usename, s.schemaname, has_schema_privilege (u.usename, s.schemaname, ‘create’) AS user_has_select_permission, has_schema_privilege (u.usename, s.schemaname, ‘usage’) AS user_has_usage_permission FROM pg_user u CROSS JOIN (SELECT DISTINCT schemaname FROM pg_tables) s WHERE u.usename = ‘tylerbullen’ AND s.schemaname = ‘vacasa’; SELECT u.usename, t.schemaname || ‘.’ || t.tablename, has_table_privilege (u.usename, t.tablename, ‘select’) AS user_has_select_permission, has_table_privilege (u.usename, t.tablename, ‘insert’) AS user_has_insert_permission, has_table_privilege (u.usename, ..

Read more

SELECT * FROM stl_scan ss JOIN pg_user pu ON ss.userid = pu.usesysid JOIN svl_query_metrics_summary sqms ON ss.query = sqms.query JOIN temp_mone_tables tmt ON tmt.table_id = ss.tbl AND tmt.table = ss.perm_table_name; SELECT perm_table_name, SUM(ROWS), SUM(bytes) SUM(fetches) FROM stl_scan WHERE starttime >= ‘2018-09-01 00:00:00’ GROUP BY perm_table_name ORDER BY SUM(bytes) DESC..

Read more

Save the SQL part as dump_rs_grants.sql, then run this bash bit: cd /usr/local/cron/dump_rs_grants PGPASSWORD=xxxxxxxxx psql -h redshiftFQDN -p 5439 -Uxxxxxx -dyyyyyy < dump_rs_grants.sql > current_rs_grants.txt dump_rs_grants.sql: WITH object_list(schema_name,object_name,permission_info) AS ( SELECT N.nspname, C.relname, array_to_string(relacl,’,’) FROM pg_class AS C INNER JOIN pg_namespace AS N ON C.relnamespace = N.oid WHERE C.relkind in (‘v’,’r’) AND N.nspname NOT IN ..

Read more

#SCHEMA=”${2}” STARTIME=`date` echo “Starting rowcount update at $STARTIME” # fivetran database DBASE=”fivetran” SCHEMALIST=”greenhouse hubspot jira mandrill marketo” # Truncate rollup table echo “Deleting from rollup table for ${DBASE} schema…” PGPASSWORD=xxxxxxxxxx psql -t -h warehouse.vacasa.services -p 5439 -Uvacasaroot -d${DBASE} -n -q -c “TRUNCATE TABLE admin.overall_rowcount;” # Iterate through schemata for SCHEMA in ${SCHEMALIST} do TABLES=`PGPASSWORD=xxxxxxxxxx psql ..

Read more

#!/bin/bash ################################################################################# # findlockblocks.sh # # Dead-stupid script that leverages existing RS queries and does a mashup that reports # the current running queries that are blocking others, sorted by time running. # # Nice, simple way to see if there’s actually a problem or if RS is just swamped. # # v1.01 2019-06-14 rlbyrd ..

Read more

#!/bin/bash ################################################################################# # do_analyze_by_batch.sh # # Using this query as the source… # # SELECT database, schema || ‘.’ || “table” AS “table”, stats_off # FROM svv_table_info # WHERE stats_off > 5 # ORDER BY 3 DESC, 2; # # …which displays all tables and their stats_off percentage in descending order. # # # Then ..

Read more

— Table level permissions SELECT * FROM ( SELECT schemaname ,objectname ,usename ,HAS_TABLE_PRIVILEGE(usrs.usename, fullobj, ‘select’) AND has_schema_privilege(usrs.usename, schemaname, ‘usage’) AS sel ,HAS_TABLE_PRIVILEGE(usrs.usename, fullobj, ‘insert’) AND has_schema_privilege(usrs.usename, schemaname, ‘usage’) AS ins ,HAS_TABLE_PRIVILEGE(usrs.usename, fullobj, ‘update’) AND has_schema_privilege(usrs.usename, schemaname, ‘usage’) AS upd ,HAS_TABLE_PRIVILEGE(usrs.usename, fullobj, ‘delete’) AND has_schema_privilege(usrs.usename, schemaname, ‘usage’) AS del ,HAS_TABLE_PRIVILEGE(usrs.usename, fullobj, ‘references’) AND has_schema_privilege(usrs.usename, schemaname, ‘usage’) ..

Read more

select relacl , ‘grant ‘ || substring( case when charindex(‘r’,split_part(split_part(array_to_string(relacl, ‘|’),pu.groname,2 ) ,’/’,1)) > 0 then ‘,select ‘ else ” end ||case when charindex(‘w’,split_part(split_part(array_to_string(relacl, ‘|’),pu.groname,2 ) ,’/’,1)) > 0 then ‘,update ‘ else ” end ||case when charindex(‘a’,split_part(split_part(array_to_string(relacl, ‘|’),pu.groname,2 ) ,’/’,1)) > 0 then ‘,insert ‘ else ” end ||case when charindex(‘d’,split_part(split_part(array_to_string(relacl, ‘|’),pu.groname,2 ) ,’/’,1)) ..

Read more

It’s columnar, donchaknow. drop table if exists example.reservation_finance_item_dedupe; create table example.reservation_finance_item_dedupe as (select distinct * from example.reservation_finance_item); select count(*) from example.reservation_finance_item; select count(*) from example.reservation_finance_item_dedupe; drop table if exists example.reservation_finance_item_old; set search_path=example; alter table reservation_finance_item rename to reservation_finance_item_old; alter table reservation_finance_item_dedupe rename to reservation_finance_item; select count(*) from example.reservation_finance_item; select count(*) from example.reservation_finance..

Read more

Most distributions of Linux come with a handy network latency utility called mtr.  Thankfully, it is included with the distributions of RHEL we use as well.  It’s a combination of ping and traceroute which show each hop of a network path, the time for that hop, and averages/standard deviations.  I use it all the time.  ..

Read more

From screentogif.com: This free tool was (and still is) mainly projected to work as a quick and small screen recorder. If you plan to record hours of fullscreen content, I recommend switching to more advanced software. Recording 📹 ScreenToGif allows you to record part of your screen with the Screen Recorder, also there’s the Webcam ..

Read more

Nikto is a very popular and easy to use webserver assessment tool to find potential problems and vulnerabilities very quickly. This tutorial shows you how to scan webservers for vulnerabilities using Nikto in Kali Linux. Nikto comes standard as a tool with Kali Linux and should be your first choice when pen testing webservers and web applications. ..

Read more

#!/usr/bin/env perl # mysqltuner.pl – Version 1.7.9 # High Performance MySQL Tuning Script # Copyright (C) 2006-2018 Major Hayden – major@mhtx.net # Inspired by Matthew Montgomery’s tuning-primer.sh script: # http://forge.mysql.com/projects/view.php?id=44 # # This version further hacked and slashed by rlbyrd off and on since 2009. package main; use 5.005; use strict; use warnings; use diagnostics; ..

Read more

— SQL snippet to calculate table fragmentation. SELECT table_schema, TABLE_NAME, ROUND(DATA_LENGTH / 1024 / 1024) AS data_length, ROUND(INDEX_LENGTH / 1024 / 1024) AS index_length, ROUND(DATA_FREE / 1024 / 1024) AS data_free, CONCAT( ROUND( ( data_free / (index_length + data_length) ) * 100 ), ‘%’ ) AS frag_ratio FROM information_schema.tables WHERE DATA_FREE > 0 AND TABLE_SCHEMA ..

Read more

#!/bin/bash # Expects: # If no *.last exists, make one. # if one does, diff it and report # Set this manually. Everything else will branch off this. BASEDIR=”/data/backups/ddl/” DBUSER=”svc_dba_adhoc” DBPASS=”ADXEZKZLbgdvcB24nvPu” TZ=”America/Los_Angeles” EMAILTO=”richard.byrd@example.com,mark.butler@example.com,rlbyrd@rlbyrd.com” if [ “$2” == “” ] then echo ” ” echo “USAGE: ddldiff ” echo ” ” fi HOST=${1} SCHEMA=${2} TMPFILE=”/tmp/${HOST}-${SCHEMA}.tmp” /bin/rm ..

Read more

Traverses all integer columns checking for capacity limits. #!/usr/bin/env perl #use 5.010; #use strict; #use warnings; # Richard L. Byrd, written sometime in the 90s and improved bit by bit over the next 20 years # # 2009-01-27: While originally written to take a configfile input on the CLI (–configfile=xxxxx.cfg) I’ve hacked # that out ..

Read more