ClamAV – Installation on CentOS – v8

Background Need an AntiVirus on my CentOS box. AntiVirus ClamAV is free and works on CentOS. Outline Package Verify ClamAV yum yum list installed dnf dnf list installed Install Identify Artifacts Install Artifacts Review Review Packages Configure ClamAV Configure SELinux Configure Services List of Services clamd@.service freshclam.service Configure Service Start Service Review Service Status Tasks … Continue reading ClamAV – Installation on CentOS – v8

Transact SQL :- String Concatenate using the Plus ( + ) Sign

Background I was doing a bit of code review. The developer cached data into a temporary table and wanted to review the fetched data.   Code Outline Temporary Table Temporary Table Create Populate data into the temporary table Concatenate String Display concatenated string Temporary Table Drop Temporary table SQL Output   Summary In Transact SQL, … Continue reading Transact SQL :- String Concatenate using the Plus ( + ) Sign

SQL and Bible Studies:- Books in each Genre

Background The Bible is a collection of books. One can categorize the books in so many different ways. In this post, we will use someone else work. He has categorized bible books into genres.   SQL The work avails a couple of database platforms. In this post, we will provide working samples for Transact SQL … Continue reading SQL and Bible Studies:- Books in each Genre

Transact SQL – Select And “FOR XML PATH”

Background A very, very good friend of mine runs a website where he posts quite a bit. Others post on the same site. Thankfully one of the persons that posted linked to his corporate website, as well. A good thing as I found a few interesting posts on the guest author's website. Transact SQL Transact … Continue reading Transact SQL – Select And “FOR XML PATH”

Browser – Error Message – “This site can’t be reached”

Background Trying to download software from Microsoft's Visual Studio Download web site,  https://download.my.visualstudio.com/ [ Link ], but ran into issues. Error The error message is documented below. Error - This site can't be reached Error - This site can't be reached - download.my.visualstudio.com Image   Text This site can’t be reached download.my.visualstudio.com refused to connect. Try: … Continue reading Browser – Error Message – “This site can’t be reached”

Magazine:- “Database – Trends and Applications” – Readers Choice Awards – 2020

Readers Choice Awards The Magazine "Database Trends and Applications" has out its Readers Choice Awards for 2020. The list is available here. Here is what it looks like. Best Cloud Database Winner Amazon RDS Finalists Microsoft Azure Couchbase Cloud Best Cloud Database Winner Microsoft Azure Finalists Amazon Web Services Quest Software Spotlight Cloud Data Lake … Continue reading Magazine:- “Database – Trends and Applications” – Readers Choice Awards – 2020

Microsoft Excel Files – Viewers And Editors

Background I have an excel file that I need to quickly view and check off some entries.   Options On my machine that I am using, I do not have Microsoft Office / Microsoft Excel installed. Here are some of the options:- Google Google Docs Web Site:- https://docs.google.com/spreadsheets/u/0/ ( Link ) Microsoft Excel Microsoft Excel … Continue reading Microsoft Excel Files – Viewers And Editors

Transact SQL – Windowing Functions – Lag and Lead

Background Have used Windowing Functions for years now. But, never used Lag and Lead. Just thought it was too hard to layer on top of what was already hard for me.   Easy Finally today, I ended up dealing with something actually hard for me. A good man gracefully scaled it and he sprinkled in … Continue reading Transact SQL – Windowing Functions – Lag and Lead

SQLCMD:- Informational Message – “Changed database context to ….”

Background Let us quickly address a message pattern that is familiar to those who use sqlcmd. Message The message reads "Changed database context to ...." Source It is sourced to the presence of "use [database]" within a SQL command or file.   Remediation We have a bit of control over whether SQL Server emits the … Continue reading SQLCMD:- Informational Message – “Changed database context to ….”

Transact SQL – STRING_AGG – Error – “Multiple ordered aggregate functions in the same scope have mutually incompatible orderings.”

Background Working on some Transact SQL code yesterday. Ran into an error that was new to me. Error Error - Image Error - Text Sample Code The original code is a bit complex and sharing it will distract from this post's point. So here we go with sample code:-   Outline Original The original code … Continue reading Transact SQL – STRING_AGG – Error – “Multiple ordered aggregate functions in the same scope have mutually incompatible orderings.”