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

===========