Nuffing.com

Ohio wisely recommends Ohioans avoid traveling to Ohio

https://ift.tt/33J2fzw

Trigger Warning: If you like Ohio, this might make you mad.

fun

via Not the Bee https://notthebee.com

December 3, 2020 at 06:15PM

DIY Heated Concrete Bench

https://ift.tt/3oihV4I

Link

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.

fun

via The Awesomer https://theawesomer.com

December 2, 2020 at 11:00AM

Lol watch this poor Amazon driver get chased off by hens

https://ift.tt/3mAaQvA

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.

fun

via Not the Bee https://notthebee.com

December 2, 2020 at 01:30PM

MySQL Window Function Compilation

https://ift.tt/39ArmrO

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…

---

Self-Promotion:

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:

• Rolling sum and average – Window Functions MySQL
• RANK() and DENSE_RANK() differences
  
• ROWS and RANGE: Windowing clause defaults – learning by example in MySQL.
• ROW_NUMBER() Window Function – find duplicate values
• Top n Window Function queries in MySQL
• The PARTITION BY clause of a Window Function – with an example in MySQL

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.

technology

via Planet MySQL https://ift.tt/2iO8Ob8

December 2, 2020 at 07:35AM

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

https://ift.tt/36pmIuY

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.

technology

via TechCrunch https://techcrunch.com

December 1, 2020 at 12:34PM

The post-election fight continues

https://ift.tt/3loxrd9

 

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 accompli.  Millions 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!

Peter

non critical

via Bayou Renaissance Man https://ift.tt/1ctARFa

December 1, 2020 at 05:39AM

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

https://ift.tt/3odtOsi

Virginia – -(AmmoLand.com)- 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.

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 www.ammoseek.com (links each deal to the seller’s website for that item)
3. Virginia Gun Trader at www.vaguntrader.com (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.

• 9mm at Sportsman’s Guide
• 9mm at Brownells
• 9mm at Gorilla Ammunition
• 9mm at Optics Planet
• 9mm at Botach Tactical
• 9mm at Primary Arms
• 9mm at Eurooptic.com
• 9mm at Rainier Arms

---

About 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: www.vcdl.org.

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

guns

via AmmoLand.com https://ift.tt/2okaFKE

November 30, 2020 at 02:59PM

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

https://ift.tt/3fNwPwC

macintosh

via AppleInsider https://ift.tt/3dGGYcl

November 30, 2020 at 06:00AM

Kick your winter off with one of the funniest dad videos that has ever been uploaded to youtube dot com.

https://ift.tt/2KSNTGb

You gotta stick with it.

fun

via Not the Bee https://notthebee.com

November 29, 2020 at 10:27PM

Comic for November 27, 2020

https://ift.tt/3l7zZfT

fun

via Dilbert Daily Strip http://dilbert.com

November 27, 2020 at 05:26AM