Just another WordPress site
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…
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!!!
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