DB PRod issues

 Production data transer issue i have faced

not using where update command using transaction
>>tansfer larger amount of data from dev emp table to test emp table mistate first load  less dpendent data
>> functions and tables and veiws 
then sps
>>it taking 40 mnts for 50k records.

dotnet 2026

 raodmap

when you order by two columns use this.imp

 

SELECT *

FROM dbo.tbl_WorkFlowMembers w

WHERE w.WorkFlow_ID IN (

    SELECT WorkFlow_ID

    FROM dbo.tbl_WorkFlow

    WHERE country_code = 'BE'

)

ORDER BY 

    w.WorkFlow_ID,

    w.Approver_Sequence DESC;

kAFKA CONFLUENT FREE TRAIL

 For me two promos are showing

VFREETRIAL400 $400.00 / $400.00 USD remaining Expires Jan. 13, 2026 CONFLUENTDEV1 $1.00 / $1.00 USD remaining Expires Jan. 13, 2026For me two promos are showing FREETRIAL400 $400.00 / $400.00 USD remaining Expires Jan. 13, 2026 CONFLUENTDEV1 $1.00 / $1.00 USD remaining Expires Jan. 13, 2026

Best UI

 BestUI

best UI

 https://ui-patterns.com/explore

create delete cascade

if you delete dependant record then child data also deleted 
ALTER TABLE tbl_UARRecord

ADD CONSTRAINT FK_tbl_UARRecord_tbl_UploadCycle

    FOREIGN KEY (UploadCycleId)

    REFERENCES tbl_UploadCycle(UploadCycleId)

    ON DELETE CASCADE;