EugeneChiang.com

Facade Pattern

The Facade Pattern (or façade pattern) is a software design pattern commonly used with object-oriented programming. The name is by analogy to an architectural facade. A facade is an object that provides a simplified interface to a larger body of code, such as a class library. The facade pattern (also spelled façade) is a software-design pattern commonly used in object-oriented programming. Analogous to a facade in architecture, a facade... » read more

Creating directory.

Get setting from configuration file.

References Add System.Configration reference. App.config or Web.config Code

Prevent multiple instance of your app from running.

Add the following code to prevent multiple instance of your app from running.

Adding log4net to your .NET application.

Logging frameworks that allows you to easy to write your logs to different places by simply changing your configuration. You can write your .NET logs to a file on disk, a database, a log management system or potentially dozens of other places, all without changing your code. Installing Run this quick command from the Package Manager... » read more

Starting SSMS using bat file.

Create a bat file using the following…

Currency Type in SQL Server

Money vs Decimal(9,2) Precision defines total length of the number. Scale represents only position of the delimiter. Decimal(9, 2) will store numbers like 1234567.89 that is 9 digits so it will be 5 bytes. Decimal(9,2) = X,XXX,XXX.XX

Remote Desktop Manager

Remote Desktop Manager Free from Devolutions https://remotedesktopmanager.com Remove Desktop Connection Manager from Microsoft RDCMan manages multiple remote desktop connections. It is useful for managing server labs or large server farms where you need regular access to each machine such as automated checkin systems and data centers. It is similar to the built-in MMC Remote Desktops... » read more

Detach and Attach Database

Detaching a Database Detaching a database removes it from the instance of SQL Server but leaves the database intact within its data files and transaction log files. These files can then be used to attach the database to any instance of SQL Server, including the server from which the database was detached. You cannot detach... » read more

Backup and Restore Database with Move

Database Backup Database Info Use the following script to get information about the database backup file. Database Restore Note: Folder must be created first. Check Progress Sources: https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-to-a-new-location-sql-server?view=sql-server-2017