Logging

 https://craftinginterpreters.com/
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/logging/?view=aspnetcore-8.0
https://learn.microsoft.com/en-us/dotnet/core/extensions/logging?tabs=command-line

JSrender

 https://www.borismoore.com/2010/09/introducing-jquery-templates-1-first.html

Currently Reading

 jquery design pattern

Single Responsibility Principle | Object Oriented Design (oodesign.com)

file:///Users/kidwai/Downloads/Oliver%20Kiddle,%20Jerry%20Peek,%20Peter%20Stephenson%20-%20From%20Bash%20to%20Z%20Shell_%20Conquering%20the%20Command%20Line%20(2004,%20Apress)%20-%20libgen.li.pdf

file:///Users/kidwai/Downloads/Mark%20Seemann%20-%20Dependency%20Injection%20in%20.NET%20(2011,%20Manning%20Publications)%20-%20libgen.li.pdf

file:///Users/kidwai/Downloads/Stanley%20I.%20Grossman%20-%20Elementary%20Linear%20Algebra%20(1987,%20Wadsworth)%20-%20libgen.li.pdf

linked server sql

 SELECT * FROM OPENQUERY([ProdServer], 'SELECT * FROM ICSForTeams.dbo.Auth_users')

INSERT INTO AnalyticsCx.DBO.AUTH_USERS([EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen])

SELECT [EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen] FROM OPENQUERY([ProdServer], 'SELECT [UserId], [EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen] FROM ICSForTeams.dbo.Auth_users')

SELECT STRING_AGG(QUOTENAME(COLUMN_NAME), ', ') AS column_list

FROM (

    SELECT COLUMN_NAME

    FROM AnalyticsCx.INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'AUTH_USERS'

      AND TABLE_SCHEMA = 'dbo'

) AS columns;
==================

sqlcmd  -S ABDUL-RAHMAN\SQLEXPRESS -d Anlytics365CX_2025V2 -i "C:\Users\Tollring\Documents\QA_2025script.sql" -x

USE [master]

GO

CREATE LOGIN [ABDUL-RAHMAN\Tollring] FROM WINDOWS

GO

USE Analytics365CX_2025V2

GO

CREATE USER [ABDUL-RAHMAN\Tollring] FOR LOGIN [ABDUL-RAHMAN\Tollring]

GO

EXEC sp_addrolemember N'db_datareader', N'ABDUL-RAHMAN\Tollring'

EXEC sp_addrolemember N'db_datawriter', N'ABDUL-RAHMAN\Tollring'

GO

===========

SELECT 

    obj.name AS TableName, 

    fk.name AS ConstraintName

FROM sys.foreign_keys AS fk

INNER JOIN sys.objects AS obj ON fk.parent_object_id = obj.object_id

WHERE fk.referenced_object_id = OBJECT_ID('dbo.WB_Tile');

Reading

 https://theswissbay.ch/pdf/Gentoomen%20Library/Programming/CSharp/APress%20A%20Programmer%27s%20Introduction%20to%20C%23.pdf

https://www.red-gate.com/simple-talk/wp-content/uploads/RedGateBooks/ChrisFarrell/Under_the_Hood_of_NET_Management.pdf


https://learn.microsoft.com/en-gb/previous-versions/visualstudio/visual-studio-2015/debugger/specify-symbol-dot-pdb-and-source-files-in-the-visual-studio-debugger?view=vs-2015&redirectedfrom=MSDN


Bundling and Minification | Microsoft Learn
Async/Await FAQ - .NET Parallel Programming (microsoft.com)
Asynchronous Programming - Async Performance: Understanding the Costs of Async and Await | Microsoft Learn
Asynchronous Programming - Easier Asynchronous Programming with the New Visual Studio Async CTP | Microsoft Learn
Using Asynchronous Methods in ASP.NET 4.5 | Microsoft Learn

https://learn.microsoft.com/en-us/dotnet/architecture/modern-web-apps-azure/common-web-application-architectures

https://learn.microsoft.com/en-us/azure/bastion/connect-ip-address

https://www.devsecurely.com/blog/2024/06/cors-the-ultimate-guide?ref=dailydev

https://blog.bytebytego.com/p/ep147-the-ultimate-api-learning-roadmap?ref=dailydev


https://learn.microsoft.com/en-us/dotnet/standard/exceptions/best-practices-for-exceptions

https://codeblog.jonskeet.uk/2010/09/03/reimplementing-linq-to-objects-part-1-introduction/


https://addyosmani.com/blog/first-principles-thinking-software-engineers/?ref=dailydev


https://jonskeet.uk/csharp/parameters.html

 using (MemoryStream memoryStream = new MemoryStream())

 {

     BinaryFormatter binaryFormatter = new BinaryFormatter();

     binaryFormatter.Serialize(memoryStream, dtUserGroup);

     sizeInBytes = memoryStream.Length;

 }
================
Chrome Autofill Password Issue: Why Password Input Value is Empty Until Page Click? — codestudy.net

Issues

https://github.com/twbs/bootstrap/issues/20607

https://datatables.net/forums/discussion/49564/scrolling-header-alignment
https://datatables.net/forums/discussion/41587/scrolly-misaligned-table-headers-with-bootstrap

HTML CSS GUIDE

 https://developer.mozilla.org/en-US/docs/Web/HTML/Element/label
https://developer.mozilla.org/en-US/docs/Web/HTML/Content_categories#phrasing_content