Top 10 Blogs

My top blogs

 1- Setup source code of Visual studio on Bitbucket

2- SQL Server Advantages over MySQL



Comments

Post a Comment

Popular posts from this blog

Blockchain use cases for Banks

Image
Blockchain is a digital, decentralized, distributed ledger technology that records transactions on multiple computers in a secure and transparent manner. It allows for the secure and transparent transfer of digital assets without the need for intermediaries like banks, government agencies, or other third-party intermediaries. In a blockchain, transactions are recorded in a block that is linked to the previous block, forming a chain of blocks, hence the name "blockchain". Each block contains a cryptographic hash of the previous block, which ensures that the blockchain is tamper-resistant and secure. Blockchain technology can be used to create smart contracts, cryptocurrencies, and other applications that require secure, transparent, and decentralized record-keeping. It has the potential to transform various industries by reducing costs, improving efficiency, and increasing security and transparency. Use cases for Banks Blockchain technology has several potential use cases in t...
Read more

Optimizing .Net Core Web API's

Image
To optimize your web API's first of all you have to set up your branch mark up to what extent you need to optimize and what are your goals. There are several ways to optimize your API in .Net Core. Asynchronous Programming ASP.NET Core API's should be designed to process many requests simultaneously. Asynchronous APIs allow a small pool of threads to handle thousands of concurrent requests by not waiting on blocking calls. Rather than waiting on a long-running synchronous task to complete, the thread can work on another request. A common performance problem in ASP.NET Core API's is blocking calls that could be asynchronous. Many synchronous blocking calls lead to  Thread Pool starvation  and degraded response times. Make  repeatedly using function and heavy code area as  asynchronous. Call data access, I/O, and long-running operations API's asynchronously if an asynchronous API is available for that data retrieval API. Do  not  use  Task.Run  ...
Read more

Tables with ledger in sql server 2022

Image
Ledger  in Sql Server 2022 In SQL Server 2022, you can create a ledger using the built-in functionality of the system-versioned temporal tables. A ledger is a record of all transactions that have affected a particular account or set of accounts, and it can be used to keep track of financial data, inventory data, or any other data that involves transactions. Append-only ledger Are ideal for application patterns that are insert-only, such as security information and event management (SIEM) applications. Append-only ledger tables block updates and deletions at the API level. This blocking provides more tampering protection from privileged users such as system administrators and DBAs. To create a table with append-only control use following is the   query CREATE SCHEMA [AccessControl]; GO CREATE TABLE [AccessControl].[KeyCardEvents] ( [EmployeeID] INT NOT NULL , [AccessOperationDescription] NVARCHAR ( 1024 ) NOT NULL , [ Timestamp ...
Read more