In this post, I describe how to check for empty string in the SELECT statement in SQL. Resolution To check for an empty string in the SELECT statement in SQL, use ISNULL and NULLIF: SELECT ISNULL ( NULLIF ( s . [Name] , '' ), 'None' ) [Name] FROM [Sales] . [Store] s In this example. if the Store Name is empty, NULLIF will return null. If NULLIF returns null, ISNULL will show the value 'None'.

In this post, I describe two tools you can use to analyze your Group Policy objects. They serve as an alternative to the Save Report... function built into the Group Policy Management Console which is very limited. Issue If you want to analyze or run reports on your Group Policy objects, you can use the Group Policy Management Console user interface or the Save Report... function but this can be very slow and inefficient, particularly when auditing lots of Group Policy settings. Resolution Free GPO Analyzer Tool CENTREL Solutions has produced a C# data model API which allows you to access your GPO settings and analyse them more easily, either in PowerShell or in .NET code: You can download this tool for free here: Group Policy Report API for C#.NET and PowerShell XIA Configuration CENTREL Solutions has also produced a documentation tool called XIA Configuration which includes support for detailed GPO settings: You can run reports to audit GPO settings across all your GPOs at once: You ...

In this post, I describe how you can apply a box shadow (or drop shadow) to an element which also has the clip-path style. Issue If you add the box-shadow style to an element with clip-path, the shadow does not appear: You can deduce the clip-path style is the reason by toggling this style on and off. Resolution To add a drop shadow to an element which also has the clip-path style, simply wrap that element in another element: < div class ="hexagon-wrapper">     < div class ="hexagon"> Hexagon </ div > </ div > Then apply a drop-shadow filter to that parent element: .hexagon-wrapper {     filter : drop-shadow(2px 2px 3px rgba(0, 0, 0, 1)) ; } To apply multiple shadows, you can add more drop-shadow filters: .hexagon-wrapper {     filter : drop-shadow(2px 2px 3px rgba(0, 0, 0, 1)) drop-shadow(-1px 0 3px rgba(0, 0, 0, 1)) ; } Related Posts Thanks to Chris Coyier for his excellent pos...

In this post, I describe how to fix an issue whereby an SD card does not automatically appear in Finder on a Mac after you insert it. Cause If you have a Mac with Apple Silicon, you have to approve new SD cards that you connect to it.  The following prompt should appear however it was flashing up and disappearing before I could press Allow.  Resolution To resolve the issue:  - Open System Settings - Click Privacy & Security in the left hand sidebar - In the right hand pane, scroll down to Allow accessories to connect  and change the drop down to Automatically When Unlocked The SD card should now appear in Finder when it is inserted Related Links - Allow accessories to connect (Apple)

In this post, I describe how to fix: " Encouraging accidental clicks: Layout " on blogspot.com (blogger.com) sites. Cause If you received an email from Google stating: " We’ve found a high volume of policy violations on your site ( blogspot.com ), which is not in compliance with the  AdSense programme policies . As a result, Google intends to restrict all ad serving on this site on 1 Dec 2023. The following issues were found on your site: Encouraging accidental clicks: Layout" Resolution It seems this was a mistake from Google which has now been resolved as the policy violation warning has disappeared from Google AdSense. Others have had the same issue and the warning has gone for them too: https://support.google.com/adsense/thread/242015746?hl=en&msgid=242037329

In this post, I describe how to fix: "Intention to restrict Google ad serving on your site" on blogspot.com (blogger.com) sites. Cause If you received an email from Google stating the above and: " We’ve found a high volume of policy violations on your site ( blogspot.com ), which is not in compliance with the  AdSense programme policies . As a result, Google intends to restrict all ad serving on this site on 1 Dec 2023." The following issues were found on your site: Encouraging accidental clicks: Layout" Resolution Please see my other post for the resolution: Encouraging accidental clicks: Layout blogger blogspot.com