EugeneChiang.com

Get Values from JSON Web Service Response

JSON Web Service Response: C# JSON Parser:

Round to the Nearest Cent in C#

Round to the nearest cent. 10.34

Creating Database Backup via Maintenance Plan Wizard

Create simple database backup and remove old backup files.

Create Database Default Setting

AUTO_UPDATE_STATISTICS

The default option is ON. How do the statistics increase the performance of your SQL Server query execution? The statistical histograms are used by the Query Optimizer to choose the optimal query execution plan. If a query predicate contains a column with statistics, the Query Optimizer does not have to estimate the number of rows... » read more

Set dropdown value using jQuery

HTML Drop Down Set value using

Read-Only Domain Controller (RODC)

Read-Only Domain Controller or RODC is a type of domain controller which holds a read-only copy of active directory database. Why We Need an RODC? RODC is deployed in branch offices because of the following important reasons. Physical security is not guaranteed in branch offices so read-only DCs are preferred instead of write-able DCs. If... » read more

SQL Server Administration Blog Sites

Blog Sites https://blog.sqlauthority.com/

Creating Linked Servers

Link Server with a Specific Name ARCHIVE -> MyDB03 ARCHIVE is the link server name. MyDB03 is the actual database server name. Sources: https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-2017

RPC and RPC Out option on a SQL Server linked-server

The first RPC setting is mainly for a legacy feature called Remote Server, which is documented here. http://msdn.microsoft.com/en-us/library/ms190187.aspx You probably will not be using remote servers in SQL Server 2005 -SQL Server 2014 versions. If you do happen to use “remote servers”, the RPC setting enables a certain security feature. Sources: