EugeneChiang.com

Adding Existing VS Project to Git BitBucket using Sourcetree

Adding an existing Visual Studio project to Git BitBucket using Sourcetree. Create new repository in BitBucket.org. Create new working folder on local computer. Using BitBucket Sourcetree app, create new project by clone. Clone BitBucket repository (https:// account01 @bitbucket.org/account01/project01.git) to local working folder (c:\git\project01). Add .gitattributes and .gitignore files to root of working folder. Add Files... » read more

Properly Shutdown Azure VM to Save Money

There are 2 ways to shutdown an Azure VM, and they are certainly not equal! One way you will still get charged for the compute resources, and the other will free you from paying for the compute resources and help you reduce overall cost. The first method to shutdown an Azure VM, that sounds logical... » read more

int, bigint, smallint, and tinyint in SQL Server

Data type Range Storage bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) 8 Bytes int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) 4 Bytes smallint -2^15 (-32,768) to 2^15-1 (32,767) 2 Bytes tinyint 0 to 255 1 Byte Sources: https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-2017

SVN – Get Latest

Periodically, you should ensure that changes done by others get incorporated in your local working copy. The process of getting changes from the server to your local copy is known as updating. Updating may be done on single files, a set of selected files, or recursively on entire directory hierarchies. To update, select the files... » read more

Create Folders from Command Script

Restart SQL Server From Command Script

Check for Table Dependency

Check for all database objects that depend on the table. If the table is to be dropped, the dependency objects will need to be dropped as well.

Check for Stored Procedure Dependency

Check for database objects that depend on the stored procedure.

Always On Availability Group Configuration

By default both read-write and read-intent access are allowed to the primary replica and no connections are allowed to secondary replicas of an Always On availability group.  Permissions Task Permissions To configure replicas when creating an availability group Requires membership in the sysadmin fixed server role and either CREATE AVAILABILITY GROUP server permission, ALTER ANY AVAILABILITY GROUP... » read more

@@ServerName

Get the actual server name of the current SQL Server. Useful when you are using listeners to connect into SQL Server and need to know the exact server name you are connected into.