EugeneChiang.com

Knowledge is Power. Never Stop Learning. Seek the Truth.

.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress

Windows Presentation Foundation (WPF)

Windows Presentation Foundation (WPF) is a graphical subsystem by Microsoft for rendering user interfaces in Windows-based applications. WPF, previously known as “Avalon”, was initially released as part of .NET Framework 3.0 in 2006. WPF uses DirectX and attempts to provide a consistent programming model for building applications. It separates the user interface from business logic, and resembles similar XML-oriented object models, such as those implemented... » read more

0
Read
echiang
Model–View–ViewModel (MVVM)

View Model – Data View – XAML, bind to data-model Model – Business Logic MVVM facilitates a separation of development of the graphical user interface from development of the business logic or back-end logic (the data model) The Model View ViewModel (MVVM) is an architectural pattern used in software engineering that originated from Microsoft which is specialized in the Presentation... » read more

0
Read
echiang
Domain Driven Design

Domain-driven design (DDD) is an approach to software development for complex needs by connecting the implementation to an evolving model. The premise of domain-driven design is the following: placing the project’s primary focus on the core domain and domain logic; basing complex designs on a model of the domain; initiating a creative collaboration between technical and domain experts to iteratively refine a conceptual... » read more

0
Read
echiang
SQL Server Utility Explorer

Utility Explorer works inside of Management Studio, so it uses the same familiar interface that you already know. In Management Studio, to switch to the Utility Explorer, go up to the View menu, and then click on Utility Explorer. Using the SQL Server Utility application, they can gather information about the status, health and performance... » read more

0
Read
echiang
SQL Server Activity Monitor

The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes.  Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries

0
Read
echiang
Database Waits and Deadlocks

Waits Waits occur when system resources are busy processing other tasks, and new tasks are placed into a holding queue until resources free up. Locks on data are the only reason a task will encounter a wait. Bottlenecks and hardware resources are also common contributors to a task having to wait before proceeding. A dynamic... » read more

0
Read
echiang
Transaction Isolation Types

As we know that, in order to maintain consistency in a database, it follows ACID properties. Among these four properties (Atomicity, Consistency, Isolation and Durability) Isolation determines how transaction integrity is visible to other users and systems. It means that a transaction should take place in a system in such a way that it is... » read more

0
Read
echiang
Implicit vs Explicit Transactions

SQL Server supports both implicit and explicit transactions. Implicit transactions are initiated when the system’s session option “Implicit Transactions” is set to ON. In this state, any of a number of commands, including Create, Insert, Update, Delete, Drop, and Select will automatically begin a new transaction. To finalize the transaction, the user must specifically issue... » read more

0
Read
echiang
Database Locking and Concurrency

When two or more users access the same tables at the same time, they’re considered concurrent users. If the operations that they are performing are simple reads, then SQL Server can easily accommodate both users simultaneously. But once one or more users begin updating and inserting records into a table that someone else is reading,... » read more

0
Read
echiang
SQL Server FILESTREAM and FILETABLES

If your database design calls for the immigration of files such as audio, images or other document types, then you’ll want to investigate the SQL Server feature called Filestream. In the past, immigrating a database with unstructured binary data files meant providing links to their location on the disk drive. This is not an ideal... » read more

0
Read
echiang