BizTech

Windows, SQL and Exchange Server Licensing 101

As Microsoft phases out older Exchange Server versions, IT leaders are facing new decisions about how to stay compliant and cost-efficient. Understanding the current licensing landscape for Windows ...
note

Decoding ServiceNow Form Views and View Rules on a Live Instance: sys_ui_view (View Definitions) and sysrule_view (Rules for Switching Views Based on Conditions)

Even when opening records from the same table in ServiceNow, the "form seen by an administrator" and the "form seen in Self-Service (ESS)" may differ in the number and arrangement of fields. Although ...
GitHub

1_1_master table.sql

SELECT DISTINCT snz_uid FROM IDI_Clean_202503.[data].[personal_detail] WHERE snz_birth_year_nbr >= 1997 AND snz_person_ind = 1 ,IIF([dol_mov_movement_ind] = 'A', 0 ...
GitHub

max_date MOH pharmaceutical.sql

2 - Keep only records within the last five years (to minimse impact of changes in data collection on calculation) 3 - Count number of records on each date (very low counts will later imply incomplete ...