Links

H. Roark

it-books.info

https://rutracker.org/forum/viewtopic.php?t=5308801

https://habrahabr.ru/company/superjob/blog/323350/

https://habrahabr.ru/post/323966/

https://habrahabr.ru/post/324004/

http://www.enterpriseintegrationpatterns.com/patterns/messaging/MessageBroker.html

https://msdn.microsoft.com/ru-ru/library/ee872418.aspx#_%d0%90%d0%bd%d0%bd%d0%be%d1%82%d0%b0%d1%86%d0%b8%d1%8f

https://habrahabr.ru/post/254059/

http://geekswithblogs.net/hroggero/archive/2015/06/04/what-is-the-service-bus-for-windows-server.aspx

https://en.wikipedia.org/wiki/Microsoft_Message_Queuing

https://msdn.microsoft.com/en-us/library/ms711472(v=vs.85).aspx

https://habrahabr.ru/post/259219/#5

http://zguide.zeromq.org/page:all#toc86

http://mikehadlow.blogspot.co.uk/2011/04/message-queue-shootout.html

https://msdn.microsoft.com/en-us/library/ms978430.aspx

https://kishanthan.wordpress.com/2013/05/05/transaction-support-with-rabbitmq/

https://msdn.microsoft.com/en-us/library/ms978425.aspx

Poison Message

https://msdn.microsoft.com/en-us/library/ms978430.aspx#bdadotnetasync2_topic3a

https://msdn.microsoft.com/en-us/library/ms789028(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/ms731093(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/aa395218(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/ms703179(v=vs.85).aspx

Writing Transactional Apps

https://msdn.microsoft.com/en-us/library/system.transactions.transactionscope(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/ee818751(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/system.transactions.dependenttransaction(v=vs.110).aspx

https://msdn.microsoft.com/en-us/library/ms701784(v=vs.85).aspx

MS ServiceBus

https://msdn.microsoft.com/en-us/library/dn282144.aspx

WCF Books

Learning WCF: A Hands-on Guide

Programming WCF Services

WPF BOOK

https://rutracker.org/forum/viewtopic.php?t=4336555

https://rutracker.org/forum/viewtopic.php?t=941658

https://rutracker.org/forum/viewtopic.php?t=1663992

https://rutracker.org/forum/viewtopic.php?t=5320190

https://rutracker.org/forum/viewtopic.php?t=5320189

https://rutracker.org/forum/viewtopic.php?t=5323208

https://rutracker.org/forum/viewtopic.php?t=5353196

https://rutracker.org/forum/viewtopic.php?t=5321104

https://rutracker.org/forum/viewtopic.php?t=5348623

https://rutracker.org/forum/viewtopic.php?t=5330169

XAML

https://rutracker.org/forum/viewtopic.php?t=5040245

https://rutracker.org/forum/viewtopic.php?t=4966002

https://www.microsoft.com/ru-ru/learning/mcsd-app-builder-certification.aspx

https://docs.microsoft.com/en-us/windows/uwp/get-started/create-a-hello-world-app-xaml-universal

https://channel9.msdn.com/Series/Windows-10-development-for-absolute-beginners?fb_action_ids=969012646501511&fb_action_types=og.likes

https://mva.microsoft.com/en-us/training-courses/developing-universal-windows-apps-with-c-and-xaml-8363?l=8pXSyBGz_3904984382

https://habrahabr.ru/post/270781/

https://metanit.com/sharp/uwp/

https://docs.microsoft.com/en-us/windows/uwp/xaml-platform/

BIG DATA

http://rb.ru/list/bigdatye-kursy/

SELECT * FROM sys.dm_exec_connections

--LOCKS ON DB

SELECT L.*, P.*, O.* FROM sys.dm_tran_locks L

LEFT JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id

LEFT JOIN sys.objects O ON O.object_id = P.object_id

WHERE request_session_id IN(51,54)

--CURRENT REQUEST (QUERIES)

select * FROM sys.dm_exec_requests WHERE session_id IN(51,54)

--ACTIVE TRANSACTIONS

select GETDATE() - transaction_begin_time, *

FROM sys.dm_tran_active_transactions TAT

JOIN sys.dm_tran_session_transactions TST ON TST.transaction_id = TAT.transaction_id

WHERE TST.session_id IN(51, 54)

--ACTIVE TRANSACTIONS (WITH STATEMENTS)

select GETDATE() - transaction_begin_time, *

FROM sys.dm_tran_active_transactions TAT

LEFT JOIN sys.dm_exec_requests ER ON TAT.transaction_id = ER.transaction_id

JOIN sys.dm_tran_session_transactions TST ON TST.transaction_id = TAT.transaction_id

INNER JOIN sys.dm_exec_connections ec ON tst.session_id = ec.session_id

CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle)

OUTER APPLY sys.dm_exec_query_plan (ER.[plan_handle]) AS DEQP

WHERE TST.session_id IN(51, 54)

SELECT L.request_session_id AS SPID,

DB_NAME(L.resource_database_id) AS DatabaseName,

O.Name AS LockedObjectName,

P.object_id AS LockedObjectId,

L.resource_type AS LockedResource,

L.request_mode AS LockType,

ST.text AS SqlStatementText,

ES.login_name AS LoginName,

ES.host_name AS HostName,

TST.is_user_transaction as IsUserTransaction,

AT.name as TransactionName,

CN.auth_scheme as AuthenticationMethod

FROM sys.dm_tran_locks L

JOIN sys.partitions P ON P.hobt_id = L.resource_associated_entity_id

JOIN sys.objects O ON O.object_id = P.object_id

JOIN sys.dm_exec_sessions ES ON ES.session_id = L.request_session_id

JOIN sys.dm_tran_session_transactions TST ON ES.session_id = TST.session_id

JOIN sys.dm_tran_active_transactions AT ON TST.transaction_id = AT.transaction_id

JOIN sys.dm_exec_connections CN ON CN.session_id = ES.session_id

CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS ST

WHERE resource_database_id = db_id()

ORDER BY L.request_session_id

DECLARE @t TABLE

(

debtid bigint,

creditdate datetime, currentamount decimal(18,4), creditamount decimal(18, 4), servicefee decimal(18,4), isarchived tinyint, repayment decimal (18,4)

)

;with dbts(debtid, count)

(

SELECT debtid, COUNT(*) FROM DEBTCOLLECTIONSERVICE dc

WHERE dc.RECORDTIME >= '2017-04-27' AND recordtime < '2017-04-28'

AND resultcode=0

GROUP BY debtid

HAVING count(*) >= 2

repayments(recordtime, messageid, chargedamount, debtid, amountpriorcharging)

(

SELECT dc.recordtime,dc.messageid, dc.chargedamount, dc.debtid, dc.amountpriorcharging

FROM debtcollectionservice dc

JOIN dbts ON dbts.debtid = dc.debtid

WHERE dc.resultcode = 0

debtsinfo(debtid, creditdate, currentamount, creditamount, servicefee, isarchived)

(

SELECT d.debtid, d.creditdate, d.CURRENTAMOUNT, d.CREDITAMOUNT, d.SERVICEFEE, 0 as isarchived

FROM dbts

LEFT JOIN debts d ON dbts.debtid = d.debtid

UNION

SELECT d.debtid, d.creditdate, d.CURRENTAMOUNT, d.CREDITAMOUNT, d.SERVICEFEE, 1 as isarchived

FROM dbts

LEFT JOIN debtsarchive d ON dbts.debtid = d.debtid

debtswithrepayments (debtid, creditdate, currentamount, creditamount, servicefee, isarchived, repayment)

(

SELECT di.*, (SELECT SUM(chargedamount) FROM repayments r WHERE r.debtid = dbts.debtid) repayed

FROM dbts

JOIN debtsinfo di ON di.debtid = dbts.debtid

)

INSERT INTO @t(debtid, creditdate, currentamount, creditamount, servicefee, isarchived, repayment)

SELECT * FROM debtswithrepayments ;

;with

samer1 (debtid)

(

SELECT dc1.debtid

FROM DEBTCOLLECTIONSERVICE dc1

WHERE recordtime > '2017-04-27' AND debtid IN(

SELECT dwr.debtid

FROM @t dwr

WHERE

(dwr.isarchived = 0 AND dwr.creditamount + dwr.servicefee - dwr.repayment != dwr.currentamount)

OR (dwr.isarchived = 1 AND dwr.creditamount + dwr.servicefee - dwr.repayment != 0)

)

GROUP BY dc1.debtid, dc1.AMOUNTPRIORCHARGING

HAVING count(*) > 1

samer2 (debtid)

(

SELECT dc1.debtid

FROM DEBTCOLLECTIONSERVICE dc1

WHERE recordtime > '2017-04-27' AND debtid IN(

SELECT dwr.debtid

FROM @t dwr

WHERE

(dwr.isarchived = 0 AND dwr.creditamount + dwr.servicefee - dwr.repayment != dwr.currentamount)

OR (dwr.isarchived = 1 AND dwr.creditamount + dwr.servicefee - dwr.repayment != 0)

)

GROUP BY dc1.debtid, dc1.AMOUNTPRIORCHARGING, dc1.chargedamount

HAVING count(*) > 1

)

SELECT * FROM debtcollectionservice

WHERE recordtime >'2017-04-27' AND debtid IN(

SELECT s1.debtid

FROM samer1 s1

LEFT JOIN samer2 s2 ON s2.debtid = s1.debtid

WHERE s2.debtid IS NULL) AND resultcode = 0

order by debtid, recordtime

SELECT dwr.*, dwr.creditamount + dwr.servicefee - dwr.repayment

FROM debtswithrepayments dwr

WHERE

(dwr.isarchived = 0 AND dwr.creditamount + dwr.servicefee - dwr.repayment != dwr.currentamount)

OR (dwr.isarchived = 1 AND dwr.creditamount + dwr.servicefee - dwr.repayment != 0);

SELECT * FROM DEBTCOLLECTIONSERVICE

WHERE recordtime > '2017-04-27' AND debtid = 114358114

order by recordtime

Links

Google SEO

ASP

Actor model

PowerShell

Poison Message

Writing Transactional Apps

MS ServiceBus

WPF BOOK

XAML

Report Page