Example Visual Studio Project Git .gitattributes File
Sample file created by Visual Studio.
Author
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
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