tag:blogger.com,1999:blog-42916640348280385932026-01-05T08:04:04.395+00:00Strictly SoftwareA technical blog about web and database development discussing the various issues and problems I have experienced and overcome in my 25+ years of coding.Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.comBlogger307125tag:blogger.com,1999:blog-4291664034828038593.post-12503802860273079512024-03-06T01:32:00.002+00:002024-03-06T01:32:31.066+00:00A New Test For The Brave Browser and New Security Focused BrowsersHow Can We Test For Brave?By Strictly-SoftwareI use the Brave browser as well as a few other Chromium-based security-focused browsers such as (Opera, CCleaner, and DuckDuckGo) most of the time due to their inbuilt security measures. My preferred browser is Brave due not only to its Shield which removes trackers, cookies, adverts, and has a measure of built-in fingerprint spoofing. Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com1tag:blogger.com,1999:blog-4291664034828038593.post-38747135861350896342023-01-22T16:07:00.004+00:002023-04-17T01:44:41.273+01:00TSQL Batch Updates SQL 2005 - 2008Updating tables in Batches to prevent locking in SQL
There are times when you may need to carry out UPDATES on large tables that are in use and constantly being inserted, deleted, or updated.
If you carry out a large UPDATE that affects all of the rows in the table, and in my case millions of rows, then the table will be locked for the duration of the update and any other processes that may Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com3tag:blogger.com,1999:blog-4291664034828038593.post-54556450170154871932022-10-30T00:10:00.001+01:002022-10-30T00:10:07.249+01:00What do you do when you have multiple blogs under one Google Blogger Account?Changing The Names Of Replies And PostsBy Strictly-SoftwareIf you are a blogger user and you have multiple blogs each with different names then you might run into the problem that when you post, or reply to a message using your Google account it will put your main Blogger account name in as the author, or comment author.Now the way I have got round this is to use JavaScript in the footer of the Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com2tag:blogger.com,1999:blog-4291664034828038593.post-14624038220587174912022-08-11T09:06:00.005+01:002022-08-11T09:09:50.872+01:00Testing For Internet ConnectivitySetup Measures For A Big API SystemBy Strictly-SoftwareI have a BOT that runs nightly, and in the SetUp() methods to ensure everything is okay, it runs a number of tests before logging to an API table in my database. This is so I know if the API I am using is available, whether I needed to login to it, when the last job was started and stopped, and when the last time I did log into the API. Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-26926143824660154662022-08-03T01:27:00.005+01:002022-08-03T01:48:21.702+01:00Extending Try/Catch To Handle Custom Exceptions - Part 2Extending Core C# Object Try/Catch To Display Custom Regular Expression Exceptions - Part 2By Strictly-SoftwareThis is the second part of our custom Try/Catch overwrite program that is aimed to catch Regular Expression errors that would normally be thrown up by !IsMatch (doesn't match) and so on. So why would you want to do this when the C# .NET RegEx functions already return a true or falseRob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-28810541015609679422022-05-26T02:01:00.003+01:002022-05-26T02:01:32.738+01:00Extending Try/Catch To Handle Custom Exceptions - Part 1Extending Core C# Object Try/Catch To Display Custom Regular Expression Exceptions - Part 1By Strictly-SoftwareHave you ever wanted to throw custom exception errors whether for business logic such as if a customer isn't found in your database, or whether more complex logic has failed that you don't want to handle but raise so that you know about it. For me, I required this solution due to a Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-65690942986160177022022-02-16T04:24:00.003+00:002022-02-16T04:24:18.377+00:00Blogger EU Cookie Message Missing Problem & SolutionMy EU Cookie Message Disappeared From My Site - How To Get It BackBy Strictly-Software
I had a bit of a weird experience recently, I found out, only from Google informing me, that for some reason one of my Blogger sites was not showing the EU Cookie Notice that should appear on all Blogger sites if in a European country where "Consent to use Cookies", is required by all website users.It used to Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com8tag:blogger.com,1999:blog-4291664034828038593.post-71214292272129411412022-02-03T08:31:00.001+00:002022-02-12T10:02:37.452+00:00Testing For The Brave BrowserHow Can We Test For Brave?By Strictly-SoftwareThe problem with detecting the Brave browser which I use most of the time is that it hides as Chrome and doesn't have its own user agent. It used to, and the hope is that in the future it will again but at the moment it just shows a Chrome user-agent. For example, my latest Brave user-agent is:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKitRob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com23tag:blogger.com,1999:blog-4291664034828038593.post-58002833764768074512022-01-17T19:30:00.004+00:002022-01-31T01:02:03.517+00:00Running JavaScript Before Any Other Scripts On A PageInjecting A Script At The Top Of Your HTML Page
By Strictly-Software
If you are developing an extension for either Firefox, Opera or Chrome, Brave, Edge, and Chromium, then you might come across the need to be able to inject some code into the top of your HTML page so that it runs before any other code.When developing extensions for Chromium based browsers such as Chrome, Brave and Edge, you Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com5tag:blogger.com,1999:blog-4291664034828038593.post-6014176966564099682022-01-07T23:17:00.009+00:002022-01-18T05:51:04.674+00:00Make Your First "Hello World" Brave / Chrome / Edge ExtensionMaking your 1st Chrome / Brave Extension....
By Strictly-Software
This article is about how to go ahead and make your first extension for Brave, Chrome, or Edge. As I no longer use Chrome but use Brave instead which like Microsoft Edge is based on the core Chromium Open Source standards-compliant browser, any mention of Brave in this article can be applied to Chrome or Edge as well.TheRob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com3tag:blogger.com,1999:blog-4291664034828038593.post-18937964604920440142021-12-27T20:40:00.000+00:002021-12-27T20:40:01.818+00:00SQL - Using CASE Statements IN SQL StatementsHow To Use IF Statements In Your SET BASED SQLBy Strictly-SoftwareNow if you are new to SQL you may not know the benefits of the CASE statement. It is basically the way you can implement an IF statement within your SET Based SQL.I do a lot of work with Horse Racing and I like to rank my horses on a number of variables adding up a "Rating" score by appending values to a default value so that Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-79311773958451541332021-12-07T02:50:00.002+00:002022-01-24T03:35:32.559+00:00Test Your Anti Virus SoftwareA Quick Way To Test If Your Computers Anti-Virus Software Is WorkingBy Strictly-SoftwareThis is a quick and quite a simple way of testing if your PC is protected properly from files that may contain viruses or malware. It has apparently been around for a long time but I only stumbled across it tonight and when I tested it against my AV tools I was surprised at the results.The test is called a Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-28410776947236779382021-10-28T10:42:00.002+01:002021-10-28T10:42:22.897+01:00Need Help Editing Your Blogger Blog?Do You Need Help Editing Your Blogger SiteBy Strictly-SoftwareAfter my last post about editing blogger blogs using JavaScript on the client side due to the lack of functionality in the back end of the admin side of blogger I was contacted by a couple of people who needed help on their blogs.I have implemented features such as the following using the JavaScript/Text widgets that you can add to Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-91613270861614782232021-10-21T03:21:00.005+01:002021-10-27T22:36:09.080+01:00Changing Blogger With JavaScriptUsing JavaScript To Edit Blogger LayoutBy Strictly-SoftwareIf you are using Googles blogger to output content then there will often be times where you want to edit the layout depending on the page you are on, or the content that is shown.I recently had a site where I needed to edit the content in multiple places depending on whether a GoFundMe post was being shown on the homepage, or it's own Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-67048825419899738752021-08-06T06:36:00.003+01:002021-08-06T06:38:11.296+01:00Fix for Wifi Adapter not working - no WiFiA WiFi Fix Without Rebooting PCBy Strictly SoftwareI just woke up again on my laptop at 5am, and the keyboard had all changed, I noticed as I went onto YouTube to post a video onto Twitter about the US Government wanting to spy on everyone's text messages and stop any that contain mis-information. Now if the US does it then you can be sure the UK GOV will follow as we are already halfway Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com1tag:blogger.com,1999:blog-4291664034828038593.post-68122184860551238652021-07-24T05:50:00.003+01:002021-07-24T06:08:15.260+01:00Do Not Be Scared!!!Main Site And Tools Still Running For NowBy Strictly-SoftwareJust to let you know that the main site with all the tools such as the:Best JavaScript HTML Encoder & Decoder available, handles double encoding, numeric or entity.Depacking packed code, even if it's been packed multiple times and reformatting it to a readable state.My top WordPress Strictly-AutoTags plugin (Free/Professional), Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com1tag:blogger.com,1999:blog-4291664034828038593.post-48206519370672738512021-07-21T03:10:00.000+01:002021-07-21T03:10:11.115+01:00Making A Super Trim FunctionUsing Regular Expressions To Make a SuperTrim() FunctionBy Strictly-SoftwareHow many times has there been when you have two bits of text that you have extracted from various websites, or feeds or even databases and tried to compare them but they would not match?I know I wrote a little example of when two different ASCII space characters are used within SQL the other day and how to check and Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com2tag:blogger.com,1999:blog-4291664034828038593.post-47523448307290328602021-06-10T23:08:00.009+01:002021-06-10T23:08:52.747+01:00Fallen asleep at your laptop and now the keyboard has changed letters?Fixing Keyboard Letter ChangesBy Strictly-SoftwareIf you anything like me then you may often move from room to room just to check on a program's running status or to run a query and then the next thing you know it's 3 hours later and you find that you have been asleep at your desk.You go to start writing something, maybe a Facebook post with a hash tag but when you hit the hash # key you find Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-78515708007037704552021-06-07T01:38:00.002+01:002021-07-02T03:23:22.062+01:00A little piece of SQL and a Regular Expression that saves me a hell of timeBetting, SQL and Regular ExpressionsBy Strictly-SoftwareFollowing on from the previous post, now that I am a professional trader on Betfair, or rather a bettor with some good luck, I managed to pick the 33/1 winner of the Derby out on Saturday somehow, I am always working on my code and my Automatic betting BOT which can TRADE for me on the Betfair Exchange.However as I also run a Facebook Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-47045420287656350812021-04-25T07:07:00.006+01:002021-07-02T03:31:33.400+01:00Solving an issue where you cannot tell the difference between the two conflicting wordsWeird Issue - Two Names That Look The Same But Aren't
By Strictly-software I have a table of Jockeys that returns me all jockeys from a RACE_RUNNERS table but I had a problem which was I kept getting one jockey returned twice in the output. I couldn't work out why this would be, and only for one jockey, and jumped straight to collations.
The column collation is set to DB default and Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-86365357224750125952020-03-18T22:25:00.003+00:002021-07-26T23:18:46.815+01:00MS SQL Collation Issues
Fixing MS SQL Collation Differences
By Strictly-Software
With the quiet due to the COVID19 virus scare, and all major sporting events being cancelled for the foreseen future, I decided now would be a good time to get my old Automatic Betting BOT back up and working.
It used to run on a dedicated Windows 2003 server and MS SQL 2012 database before being outsourced to a French hosting Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-24055018557667511072020-03-04T20:19:00.002+00:002020-03-04T20:19:21.598+00:00Samsung Phones SmartView Application Bug
Fixing Problems With Samsung Phone SmartView Application
By Strictly-Software
I have a Samsung Galaxy S8 mobile phone and recently I have had issues with the inbuilt SmartView application that allows you to mirror the screen of your phone to nearby devices such as Televisions, Rokus, Chromecasts and other Wifi enabled devices.
You access the app by using the swipe down settings Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-84554929694108541642020-01-24T21:22:00.001+00:002021-07-02T03:36:37.300+01:00Making It Hard For Humans and BOTS to use SELECT Inputs
How To Ensure A Human Has To Select From A List Rather Than Just Hitting A Letter, Word or Number
By Strictly-Software
I noticed something the other day when logging into Halifax my bank, when you get to the memorable information form, you have to select 3 letters picked by random from your word.
They will have 3 List boxes and they will pick 3 positions in your memorable phrase to Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-58821862400083771772019-12-29T01:08:00.001+00:002019-12-29T02:48:00.176+00:00Removing Chrome Has Sped Up My PC
How Removing Google Products Can Speed Up Your Laptop
By Strictly-Software
If you read my other recent pieces on speeding up my PC you might be interested in the fact that the other day I removed Google Chrome and now my PC is fast as road runner.
If you ever look at the task manager when you have 5+ tabs open in Chrome then you will see 5+ Google Chrome processes running. Their idea Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0tag:blogger.com,1999:blog-4291664034828038593.post-75693213894813904122019-12-15T18:43:00.006+00:002019-12-15T18:54:34.876+00:00
Browser Slow Down May Have a Windows Cause
By Strictly-Software
Yesterday if you read my blog article about Firefox and Chrome slowing me down as if I was being dragged through mud by a 3 legged donkey, then you will know that I was blaming the browsers and their settings for the slow down.
However when I could take no more, of browser windows hanging and then seemingly Windows Rob Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.com0