DIY Heated Concrete Bench

DIY Heated Concrete Bench

DIY Heated Concrete Bench


If you’re going to park your butt on an outdoor bench in the winter, it can be a jarring experience. HomeMadeModern wanted to improve upon the basic design, so he embedded a heated rubber mat in a DIY concrete bench. Heated seats are great in cars, so we imagine they’d be just as pleasant outdoors.


via The Awesomer

December 2, 2020 at 11:00AM

Lol watch this poor Amazon driver get chased off by hens

Lol watch this poor Amazon driver get chased off by hens

This poor dude was just trying to do his job when he nearly got mauled by a brood of angry hens. Thankfully the whole thing was caught on video.


via Not the Bee

December 2, 2020 at 01:30PM

MySQL Window Function Compilation

MySQL Window Function Compilation

If you use SQL on a regular basis, then you are well aware that Window Functions are powerful. They allow us to simplify queries that would otherwise be quite the mess. We can provide meaningful insight across rows of data without collapsing the results into a single value. I have written numerous blog posts on Window Functions, many here recently. I decided to make this blog post a compilation of all the Window Function posts I have written, providing a one-stop source for any readers interested in learning more about Window Functions…

several different sized windows on building side
Image by Free-Photos from Pixabay


If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Without further ado, here is the compilation. Be sure and share the posts along with others’ who may value them as well:

Like what you have read? See anything incorrect? Please comment below and thank you for reading!!!

A Call To Action!

Thank you for taking the time to read this post. I truly hope you discovered something interesting and enlightening. Please share your findings here, with someone else you know who would get the same value out of it as well.

Visit the Portfolio-Projects page to see blog post/technical writing I have completed for clients.

To receive email notifications (Never Spam) from this blog (“Digital Owl’s Prose”) for the latest blog posts as they are published, please subscribe (of your own volition) by clicking the ‘Click To Subscribe!’ button in the sidebar on the homepage! (Feel free at any time to review the Digital Owl’s Prose Privacy Policy Page for any questions you may have about: email updates, opt-in, opt-out, contact forms, etc…)

Be sure and visit the “Best Of” page for a collection of my best blog posts.

Josh Otwell has a passion to study and grow as a SQL Developer and blogger. Other favorite activities find him with his nose buried in a good book, article, or the Linux command line. Among those, he shares a love of tabletop RPG games, reading fantasy novels, and spending time with his wife and two daughters.

Disclaimer: The examples presented in this post are hypothetical ideas of how to achieve similar types of results. They are not the utmost best solution(s). The majority, if not all, of the examples provided, are performed on a personal development/learning workstation-environment and should not be considered production quality or ready. Your particular goals and needs may vary. Use those practices that best benefit your needs and goals. Opinions are my own.

The post MySQL Window Function Compilation appeared first on Digital Owl’s Prose.


via Planet MySQL

December 2, 2020 at 07:35AM

AWS goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL

AWS goes after Microsoft’s SQL Server with Babelfish for Aurora PostgreSQL

AWS today announced a new database product that is clearly meant to go after Microsoft’s SQL Server and make it easier — and cheaper — for SQL Server users to migrate to the AWS cloud. The new service is Babelfish for Aurora PostgreSQL. The tagline AWS CEO Andy Jassy used for this service in his re:Invent keynote today is probably telling: “Stop paying for SQL Server licenses you don’t need.” And to show how serious it is about this, the company is even open-sourcing the tool.

What Babelfish does is provide a translation layer for SQL Server’s proprietary SQL dialect (T-SQL) and communications protocol so that businesses can switch to AWS’ Aurora relational database at will (though they’ll still have to migrate their existing data). It provides translations for the dialect, but also SQL commands,  cursors, catalog views, data types, triggers, stored procedures and functions.

The promise here is that companies won’t have to replace their database drivers or rewrite and verify their database requests to make this transition.

“We believe Babelfish stands out because it’s not another migration service, as useful as those can be. Babelfish enables PostgreSQL to understand database requests—both the command and the protocol—from applications written for Microsoft SQL Server without changing libraries, database schema, or SQL statements,” AWS’s Matt Asay writes in today’s announcement. “This means much faster ‘migrations’ with minimal developer effort. It’s also centered on ‘correctness,’ meaning applications designed to use SQL Server functionality will behave the same on PostgreSQL as they would on SQL Server.”

PostgreSQL, AWS rightly points out, is one of the most popular open-source databases in the market today. A lot of companies want to migrate their relational databases to it — or at least use it in conjunction with their existing databases. This new service is going to make that significantly easier.

The open-source Babelfish project will launch in 2021 and will be available on GitHub under the Apache 2.0 license.

“It’s still true that the overwhelming majority of relational databases are on-premise,” AWS CEO Andy Jassy said. “Customers are fed up with and sick of incumbents.” As is tradition at re:Invent, Jassy also got a few swipes at Oracle into his keynote, but the real target of the products the company is launching in the database area today is clearly Microsoft.


via TechCrunch

December 1, 2020 at 12:34PM

The post-election fight continues

The post-election fight continues


There’s not much new to report on the fight over the results of the 2020 Presidential election.  It becomes clearer by the day that Joe Biden did not win it;  his votes were largely obtained by criminal means, vote-rigging and outright electoral fraud.  It’s no longer possible for any objective individual to doubt that.  Two recent summaries point out the highlights of the facts of the matter.  If you need ammunition, read them for yourselves, and follow the links.

The first is from American Thinker:  "A compilation of twenty alleged election ‘facts’ that don’t pass the smell test".  A brief selection:

7. In the Rust Belt, Biden lost black support everywhere except in Detroit, Philadelphia, and Milwaukee.  In those cities, every single black person apparently voted for Biden.

9. The fact that Pennsylvania, Wisconsin, Arizona, Nevada, and Georgia simultaneously pretended to halt ballot-counting while continuing to count is evidence of election fraud collusion.

12. In the contested states, the voting machines were alleged to have processed hundreds of thousands of ballots within a short time, which is a physical impossibility.

19. Over 100,000 Pennsylvania absentee ballots were returned a day after they were mailed out, on the day they were mailed out, or on the day before they were mailed out.

20. In all the contested areas, and at Dominion’s website, Democrats have been systematically failing to create or have destroyed all data that could be used to demonstrate fraud.  This creates the legal presumption that the data do, in fact, show fraud.

There’s more at the link.

The second article is from American Spectator:  "Legitimacy of Biden Win Buried by Objective Data".

A growing body of evidence ranging from straightforward ballot audits to complex quantitative analyses suggests that the tabulation of the votes was characterized by enough chicanery to alter the outcome of the election. Consequently, a consensus has gradually developed among the auditors of publicly available information released by the states, and it contradicts the narrative promulgated by the Democrats and the media. The more data experts see, the less convinced they are that Biden won.

Among the analysts who question the legitimacy of Biden’s victory is Dr. Navid Keshavarz-Nia, a cybersecurity expert whose technical expertise was touted by the New York Times last September and who has been described as a hero in the Washington Monthly … His nine-page affidavit describes how it is possible to manipulate votes, where this occurred, and sums up his findings as follows:

I conclude with high confidence that the election 2020 data were altered in all battleground states resulting in hundreds of thousands of votes that were cast for President Trump to be transferred to Vice President Biden. These alterations were the result of systemic and widespread exploitable vulnerabilities in DVS, Scytl/SOE Software and Smartmatic systems that enabled operators to achieve the desired results. In my view, the evidence is overwhelming and incontrovertible.

. . .

Meanwhile, no discussion of 2020 election skulduggery is complete without a discussion of the Democrat precincts that record more votes than registered voters. Rep. Bill Posey (R-Fla.) tweeted the following on that perennial topic: “According to an affidavit in the MI lawsuit, one Michigan precinct/twnship had 781.91% turnout. How does this happen?”

Good question. No fewer than six precincts listed by Rep. Posey experienced turnout exceeding 120 percent. Another 10 allegedly enjoyed 100 percent turnout. This is an insult to the electorate’s intelligence, and it happened in Democrat precincts all across the nation.

Again, more at the link.

I’m dumbfounded by the sheer chutzpah of the Democratic Party in expecting us to surrender to such naked, unmistakeable chicanery.  They really seem to believe that Americans will "roll over and play dead" in the face of a political fait accompliMillions of us will not.  I wasn’t joking when I warned, some weeks ago, that civil war was now a real possibility.  If it comes, it’s this electoral fraud that will have struck the spark and ignited the flame.

What’s equally astonishing is the complicity of the mainstream media in all this.  They seem to think that people still believe them:  that they can sway public opinion through their propaganda.  For a great many Americans, that’s no longer the case.  We don’t trust the news media at all, and regard journalists as no more trustworthy than politicians.

The journalists themselves don’t seem to get it.  They write articles with titles like "US election results: Why the most accurate bellwether counties were wrong" – but they never stop to consider that it’s the (false) election results that were wrong, not the bellwether counties.  The bellwethers voted for President Trump, and according to any authentic, non-criminally-influenced count of the votes, he did win.  They were right.

This is far from over.  President Trump’s biggest challenge is to get his evidence in front of the Supreme Court.  If he can do that, I can’t believe that our highest court will disregard or overrule the quantity and quality of that evidence.

If Joe Biden becomes President, it’ll be a sham, a fake and a public lie.  Our constitutional republic will effectively have ceased to exist – so it’ll be up to Americans who support the constitution to restore it to its rightful place.  If we can no longer trust the ballot box to produce an accurate, verifiable election result, then other means will gain stronger support.  May God preserve us from that!


non critical

via Bayou Renaissance Man

December 1, 2020 at 05:39AM

What Happened To All the Ammo? ~ 9mm? – 223? – 5.56? – 300BLK?

What Happened To All the Ammo? ~ 9mm? – 223? – 5.56? – 300BLK?

9mm Brass Primers Ammo Ammunition
What Happened To All the Ammo? ~ 9mm? – 223? – 5.56? – 300BLK?

Virginia – -( Where can I get ammo?

What Happened To All the Ammo?

A perfect storm has basically made cheap ammunition as scarce as hen’s teeth:

The state and federal threats to our gun rights is driving people to buy more ammunition to keep in reserve. COVID-19 is limiting the number of employees able to make ammunition and a wave of millions of new gun owners that need to feed their recent firearms purchases for purposes of training and carry are all eating up or holding back the supply lines.

Ammunition manufacturers customarily have a pretty good handle on how much of each type of ammunition they are going to sell annually. Knowing this, they tool up and crank out x number of rounds of say, .22 LR. They then retool and make y number of rounds of 9mm, then z rounds of .223, etc. The perfect storm has thrown a monkey wrench into those calculations and the industry is trying desperately to catch up to the exploding demand. See this related article “How Much Ammunition is Produced for the United States Market?“.

Even components for reloading are in short supply.

Where Can I Find Ammunition That is Cheap?

ROFL! Good luck on that cheap part. If you do find some cheap ammo at 2019 prices, you might also stumble on a unicorn or two in your backyard.

Barrels of Ammunition XM855
Barrels of Ammunition XM855

OK, OK. Where Can I Find Ammunition, Even If Pricey?

Fortunately, the free market can help. When a commodity is in short supply vs demand, the price of that commodity tends to rise, which helps lower demand, and keeps the product at least available to those who need it and are willing to pay extra to have it.

There are three places I go to look for the best prices and availability on ammunition:

  1. AmmoLand’s Gun Deal (go to the “Daily Deals Page” to see the deals and it links you to the seller’s website for that item)
  2. AmmoSeek at (links each deal to the seller’s website for that item)
  3. Virginia Gun Trader at (the ammunition section has private sellers, with their locality, in Virginia who have ammunition they want to sell – there are often good deals to be had this way)

Good luck and happy hunting!

Editors Note: Lots of folks are looking for 9mm ammunition check out these fast links for checking select ammunition retailers’ inventory online.

Virginia Citizens Defense LeagueAbout Virginia Citizens Defense League, Inc. (VCDL):

Virginia Citizens Defense League, Inc. (VCDL). VCDL is an all-volunteer, non-partisan grassroots organization dedicated to defending the human rights of all Virginians. The Right to Keep and Bear Arms is a fundamental human right.

For more information, visit:

The post What Happened To All the Ammo? ~ 9mm? – 223? – 5.56? – 300BLK? appeared first on



November 30, 2020 at 02:59PM

Cyber Monday deal: get up to 43% off Anker charging accessories for iPhone, iPad, and Mac

Cyber Monday deal: get up to 43% off Anker charging accessories for iPhone, iPad, and Mac

Now’s the time to make sure you never run out of charge on your iPhone, iPad, or even your Mac, as Anker chargers and cables are on sale for Cyber Monday.

Apple devices are now featuring longer battery life than before, but it would still be great if we didn’t have to keep charging them, or if we could just forget about charging. We’re not there yet, but get an Anker battery charging accessor and you’ll be close.

Your iPhone has run out of power at a key moment, and so have the iPhones of everyone you know. So now is the time to fix that for yourself by taking advantage of Anker’s Cyber Monday sale. Once you’ve got yours, you could stock up on Christmas presents for everyone else, too

Anker chargers for iPhone and iPad

The greatest saving in Anker’s Cyber Monday sale is on its Anker PowerCore 26800 Portable Charger. This is now $37.49 instead of $65.98 — a saving of 43%.

Charge up this device once and it can then recharge your iPhone more than six times. Alternatively, it can recharge certain iPads at least twice.

The PowerCore 26800 Portable Charger has with three USB ports so you can recharge multiple devices at once. You also get a micro USB cable for charging the PowerCore, and a travel pouch.

Also in the Cyber Monday sale is Anker’s PowerCore Slim 10000 PD, USB-C Power Bank (18W). Usually $29.99, the black version is on sale for $19.99, or a 33% saving.

It’s is a slimline charger, handy for travelling, which can still recharge two devices at once. Anker claims that it will recharge, for example, an iPhone XS, more than twice – and provide almost a full charge for an 11-inch iPad Pro.

Anker chargers for iPhone, iPad — and Mac

Plug the Anker USB C Fast Charger into a power adapter and you can simultaneously recharge four devices — including your USB-C-powered Mac. The Anker USB C Fast Charger is on sale for Cyber Monday at $39.99, a 31% saving on its regular price of $57.99.

It’s another slimline Anker charger, this time meant to be used at your desk instead of travelling, and offers 45W via its USB-C port for the Mac, or 18W for iPhones and iPads.

Anker cables

If you can never have enough power, you also can never have enough power cables. Anker is offering its twin-pack of USB-C to Lightning cables for $19.99.

That’s a 43% saving on its usual price of $34.99, and both cables are the full 6ft long.

Additional Apple deals


via AppleInsider

November 30, 2020 at 06:00AM